I m trying to developed a form which is contain ajax for get realtime data on database. but im facing issues in accessing the pages while im execute the ajax. See the below error -
"Sorry, you do not have permission to access this page"
the error come if the role id = user, or login as user
but if we login as administrator it works
how to fix this...im still using joget 2.01
below is the sample of ajax
| Code Block | ||
|---|---|---|
| ||
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%
try {
String connectionURL = "jdbc:mysql://localhost:3307/sampledb";
Connection connection = null;
ResultSet rst = null;
Statement stmt = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "");
stmt=connection.createStatement();
String querys = request.getParameter("query");
String str_querys = querys.replace("+", " ");
String sqlna=str_querys;
rst = stmt.executeQuery(str_querys);
rst.next();
%>
<%=rst.getString(1)%>
<%
rst.close();
stmt.close();
connection.close();
}
catch(Exception ex){
out.println(ex);
}
%> |
or we use joget javascript function
| Code Block |
|---|
var callback2 = {
success : function(response){
alert("respon : "+response);
}
}
var query_str=query.replace(/\s/g,"+");
var m=query+"¶m=1";
ConnectionManager.post("http://localhost:8080/wflow-wfweb/testJSP.jsp", callback2, m); |