topic Connect to Database using javascript/ajax in alfresco in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260590#M213720 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys,</SPAN><BR /><BR /><SPAN>I would like to know how to connect to database using javascript/ajax in alfresco.</SPAN><BR /><SPAN>I am able to connect and add data using ajax, but when i used the code in alfresco it gives me error.</SPAN><BR /><SPAN>Below is the code:</SPAN><BR /><STRONG>index.jsp</STRONG><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;html&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;head&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;Sita Ajax test&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;script&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* —————————- */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* XMLHTTPRequest Enable */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* —————————- */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function createObject() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var request_type;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var browser = navigator.appName;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(browser == "Microsoft Internet Explorer"){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; request_type = new ActiveXObject("Microsoft.XMLHTTP");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; request_type = new XMLHttpRequest();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return request_type;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var http = createObject();<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* ————————– */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* INSERT */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* ————————– */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Required: var nocache is a random number to add to request. This value solve an Internet Explorer cache issue */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var nocache = 0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function insert() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Optional: Show a waiting message in the layer with ID login_response<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; document.getElementById('insert_response').innerHTML = "Just a second…"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Required: verify that all fileds is not empty. Use encodeURI() to solve some issues about character encoding.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var name= encodeURI(document.getElementById('name').value);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var city = encodeURI(document.getElementById('city').value);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var phone = encodeURI(document.getElementById('phone').value);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Set te random number to add to URL request<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nocache = Math.random();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Pass the login variables like URL variable<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; http.open('get', 'insert.jsp?name='+name+'&amp;city=' +city+'&amp;phone=' +phone+'&amp;nocache = '+nocache);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; http.onreadystatechange = insertReply;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; http.send(null);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function insertReply() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(http.readyState == 4){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var response = http.responseText;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // else if login is ok show a message: "Site added+ site URL".<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; document.getElementById('insert_response').innerHTML = ''+response;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/script&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/head&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;body&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;h1&gt;Welcome!&lt;/h1&gt;<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;form action="javascript:insert()" method="post"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;table style="background-color: #ECE5B6;" width="30%" &gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th width="50%"&gt;Name&lt;/th&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td width="50%"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;input type="text" name="name" id="name"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th width="50%"&gt;City&lt;/th&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td width="50%"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;input type="text" name="city" id="city"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th width="50%"&gt;Phone&lt;/th&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td width="50%"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;input type="text" name="phone" id="phone"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th&gt;&lt;/th&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td width="50%"&gt;&lt;input type="submit" value="submit"&gt;&lt;/td&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/table&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/form&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Show Message for AJAX response –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div id="insert_response"&gt;&lt;/div&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;/body&gt;<BR />&lt;/html&gt;<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><STRONG>insert.jsp</STRONG><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;%@ page import="java.sql.*" %&gt; <BR />&lt;%@ page import="java.io.*" %&gt;&nbsp;<BR /><BR />&lt;%<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String name = request.getParameter("name");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String city = request.getParameter("city");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String phone = request.getParameter("phone");<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Create string of connection url within specified format with machine name,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; port number and database name. Here machine name id localhost and database name is student. */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String connectionURL = "jdbc:mysql://localhost:3306/alfresco";<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // declare a connection by using Connection interface<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Connection connection = null;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // declare object of Statement interface that uses for executing sql statements.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PreparedStatement pstatement = null;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Load JBBC driver "com.mysql.jdbc.Driver"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Class.forName("com.mysql.jdbc.Driver").newInstance();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int updateQuery = 0;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // check if the text box is empty<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (name != null &amp;&amp; city != null &amp;&amp; phone != null) {<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // check if the text box having only blank spaces<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (name != "" &amp;&amp; city != "" &amp;&amp; phone != "") {<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Create a connection by using getConnection() method that takes<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parameters of string type connection url, user name and password to connect<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; to database. */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection = DriverManager.getConnection(connectionURL, "root", "root");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // sql query to insert values in the secified table.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String queryString = "INSERT INTO stu_info(Name,City,Phone) VALUES (?, ?, ?)";<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* createStatement() is used for create statement object that is used for<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sending sql statements to the specified database. */<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstatement = connection.prepareStatement(queryString);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstatement.setString(1, name);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstatement.setString(2, city);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstatement.setString(3, phone);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateQuery = pstatement.executeUpdate();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (updateQuery != 0) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out.println("Data was inserted successfuly.");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (Exception ex) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out.println("Unable to connect to batabase.");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out.println(ex);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ex.printStackTrace();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } finally {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // close all the connections.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstatement.close();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection.close();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />%&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>This code works fine if i run it as a separate web application, but gives errors when i copy it to alfresco.</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN><BR /><SPAN>Croc</SPAN></BODY></HTML> Tue, 23 Nov 2010 08:01:16 GMT croc 2010-11-23T08:01:16Z Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260590#M213720 Hi Guys,I would like to know how to connect to database using javascript/ajax in alfresco.I am able to connect and add data using ajax, but when i used the code in alfresco it gives me error.Below is the code:index.jsp&lt;html&gt;&nbsp;&nbsp;&nbsp; &lt;head&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;meta http-equiv="Content-Type" content="te Tue, 23 Nov 2010 08:01:16 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260590#M213720 croc 2010-11-23T08:01:16Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260591#M213721 <HTML><HEAD></HEAD><BODY><SPAN>As always, it's going to be very difficult for anyone to help you unless you post the exact error you're getting.</SPAN><BR /><BR /><SPAN>Mike</SPAN></BODY></HTML> Tue, 23 Nov 2010 09:23:25 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260591#M213721 mikeh 2010-11-23T09:23:25Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260592#M213722 <HTML><HEAD></HEAD><BODY><SPAN>Sorry about that.</SPAN><BR /><SPAN>It first complained about&nbsp; navigator (var browser = navigator.appName<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /> on index.jsp, i commented it out and I got the error below:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />he Web Script /alfresco/service/sita/dbsave has responded with a status of 500 - Internal Error.<BR /><BR />500 Description:&nbsp;&nbsp;&nbsp;An error inside the HTTP server which prevented it from fulfilling the request.<BR /> <BR />Message:&nbsp;&nbsp;&nbsp;10220012 Wrapped Exception (with status template): 10220202 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10220201 ReferenceError: "document" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#28)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.mozilla.javascript.EcmaError - ReferenceError: "document" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#28)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37._c1(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js:28)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37._c0(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js:48)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c37.exec(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:453)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:179)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:268)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:971)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:367)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:417)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:434)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:298)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:319)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:177)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:116)<BR />&nbsp;&nbsp;&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<BR />&nbsp;&nbsp;&nbsp;org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)<BR />&nbsp;&nbsp;&nbsp;org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<BR />&nbsp;&nbsp;&nbsp;org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<BR />&nbsp;&nbsp;&nbsp;java.lang.Thread.run(Thread.java:619)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.alfresco.error.AlfrescoRuntimeException - 10220201 ReferenceError: "document" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#28)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:469)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.alfresco.scripts.ScriptException - 10220202 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10220201 ReferenceError: "document" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#28)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:183)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.WebScriptException - 10220012 Wrapped Exception (with status template): 10220202 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10220201 ReferenceError: "document" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#28)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:740)<BR />&nbsp;&nbsp;&nbsp; <BR />Server:&nbsp;&nbsp;&nbsp;Enterprise v3.3.1 (96) schema 4,013<BR />Time:&nbsp;&nbsp;&nbsp;22 Nov 2010 4:15:00 PM<BR />&nbsp;&nbsp;&nbsp; <BR />Diagnostics:&nbsp;&nbsp;&nbsp;Inspect Web Script (org/alfresco/sita/dbsave/dbsave.post)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 23 Nov 2010 09:43:00 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260592#M213722 croc 2010-11-23T09:43:00Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260593#M213723 <HTML><HEAD></HEAD><BODY><SPAN>Below is the error when&nbsp;&nbsp; function createObject() is not commented out:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />The Web Script /alfresco/service/sita/dbsave has responded with a status of 500 - Internal Error.<BR /><BR />500 Description:&nbsp;&nbsp;&nbsp;An error inside the HTTP server which prevented it from fulfilling the request.<BR /> <BR />Message:&nbsp;&nbsp;&nbsp;10230006 Wrapped Exception (with status template): 10230573 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10230572 ReferenceError: "navigator" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#7)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.mozilla.javascript.EcmaError - ReferenceError: "navigator" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#7)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44._c1(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js:7)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44._c0(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js:16)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44.call(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.mozilla.javascript.gen.c44.exec(workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:453)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:179)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:268)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:971)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:367)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:417)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:434)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:298)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:319)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:177)<BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:116)<BR />&nbsp;&nbsp;&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<BR />&nbsp;&nbsp;&nbsp;org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)<BR />&nbsp;&nbsp;&nbsp;org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<BR />&nbsp;&nbsp;&nbsp;org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<BR />&nbsp;&nbsp;&nbsp;java.lang.Thread.run(Thread.java:619)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.alfresco.error.AlfrescoRuntimeException - 10230572 ReferenceError: "navigator" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#7)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:469)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.alfresco.scripts.ScriptException - 10230573 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10230572 ReferenceError: "navigator" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#7)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:183)<BR />&nbsp;&nbsp;&nbsp; <BR />Exception:&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.WebScriptException - 10230006 Wrapped Exception (with status template): 10230573 Failed to execute script '/org/alfresco/sita/dbsave/dbsave.post.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts)': 10230572 ReferenceError: "navigator" is not defined. (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts/org/alfresco/sita/dbsave/dbsave.post.js#7)<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:740)<BR />&nbsp;&nbsp;&nbsp; <BR />Server:&nbsp;&nbsp;&nbsp;Enterprise v3.3.1 (96) schema 4,013<BR />Time:&nbsp;&nbsp;&nbsp;23 Nov 2010 11:32:58 AM<BR />&nbsp;&nbsp;&nbsp; <BR />Diagnostics:&nbsp;&nbsp;&nbsp;Inspect Web Script (org/alfresco/sita/dbsave/dbsave.post)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 23 Nov 2010 09:54:01 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260593#M213723 croc 2010-11-23T09:54:01Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260594#M213724 <HTML><HEAD></HEAD><BODY><SPAN>Can you post the entire script? I'm not quite sure what you are trying to do.</SPAN></BODY></HTML> Tue, 23 Nov 2010 12:01:27 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260594#M213724 kevinr 2010-11-23T12:01:27Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260595#M213725 <HTML><HEAD></HEAD><BODY><SPAN>I need to connect to the database and insert data in alfresco. So i have created to files, the index and inser.jsp using ajax to do that, now i wanna move that logic to alfresco. But I am getting errors.</SPAN><BR /><BR /><SPAN>So in short I am looking for a way to connect to database in alfresco. I have created a form, i now want to send the data from that form to the database and be able to read it at a later stage.</SPAN></BODY></HTML> Tue, 23 Nov 2010 12:14:26 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260595#M213725 croc 2010-11-23T12:14:26Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260596#M213726 <HTML><HEAD></HEAD><BODY><SPAN>If i remember right, some of Rhinos fancy features are not available to webscripts, most notably the creation of arbitrary Java objects&nbsp; <img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /> </SPAN><BR /><BR /><SPAN>Thus, the most alfrescan way of doing things like direct database access would be writing some custom action (i.e., an subclass of ActionExecuterAbstractBase) in java.</SPAN><BR /><BR /><SPAN>However, there some points worth noting:</SPAN><BR /><BR /><BR /><SPAN>* Do you really need to use your own database? In most cases you are better off by doing things in Alfresco itself, e.g. by extending the document model and storing your data in custom node properties.</SPAN><BR /><BR /><SPAN>* If you really really want to access your own database, you should not directly load the JDBC-Driver - in a J2EE environment, you would rather define a database connection pool (this can be either done in Tomcat itself, or even better by providing some fancy Spring bean).&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>HTH</SPAN><BR /><SPAN>Gyro</SPAN></BODY></HTML> Tue, 23 Nov 2010 15:01:42 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260596#M213726 gyro_gearless 2010-11-23T15:01:42Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260597#M213727 <HTML><HEAD></HEAD><BODY><SPAN>I was able to get data from the database into my dropdownlist in Alfresco V3.3x, but it doesn't work anymore in V3.4.</SPAN><BR /><BR /><SPAN>I have created a Java class that connects to the database, get the values and passes them to my model. then inside </SPAN><STRONG>form.get.js</STRONG><SPAN> file under createFieldConstraint method, i was populating the list by assigning a list like: fieldDef.control.params.options = constraintParams.status.join(); if my list name is status. </SPAN><BR /><SPAN>and in my model I have:</SPAN><BR /><BR /><SPAN> &lt;constraint name="wfl<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocurementRequestStatus" type="ListOfValuesQueryConstraint"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;parameter name="status"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/parameter&gt;</SPAN><BR /><SPAN>&lt;/constraint&gt;</SPAN><BR /><BR /><SPAN>This was working fine, but now it doesn't work on V 3.4. form.get.js is not available anymore. can someone tell help me</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Croc</SPAN></BODY></HTML> Wed, 23 Feb 2011 13:34:00 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260597#M213727 croc 2011-02-23T13:34:00Z Re: Connect to Database using javascript/ajax in alfresco https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260598#M213728 <HTML><HEAD></HEAD><BODY><SPAN>Hi Croc,</SPAN><BR /><BR /><SPAN>I have also a similar requirement for my project. Here we have created custom forms out of alfresco, but we are not able to connect it to the alfresco database(PostgreSQL). We are using 4.2.c version of Alfresco community. ZIf you achieved in doing this can you share the steps with us. It would be of great help.</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Anand. </SPAN></BODY></HTML> Mon, 04 Feb 2013 08:01:22 GMT https://connect.hyland.com/t5/alfresco-archive/connect-to-database-using-javascript-ajax-in-alfresco/m-p/260598#M213728 anand6105 2013-02-04T08:01:22Z