Facebook
Twitter
F
fparvini
Guest
Hi
I have a problem accesssign MySQL from JSP .
I have a very simple code (at the bottom).
This code gives the following error message :
java.sql.SQLException: Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)
I have tried may be ten different methods,
1. changing catalina.policy,
2. INSERT INTO db VALUES('localhost.localdomain' in Mysql
3. changing java.policy
among them , but NONE of them worked.
I really don't know what to do next.
Any help is really appreciated.
<%@ page import="java.sql.*" %>
<%@ page errorPage="ExceptionHandler.jsp" %>
<html>
<BODY>
<%
Statement s = null;
ResultSet rs = null;
Connection con= null;
out.println("Sunday, January 22, 2006 3:55:31 PM");
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/test?user=my_user&password=my_pass");
}
catch (Exception e)
{
out.println("<p> Error , cause:</p> <b> " + e + "</b>");
}
%>
</BODY>
</HTML>
I have a problem accesssign MySQL from JSP .
I have a very simple code (at the bottom).
This code gives the following error message :
java.sql.SQLException: Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve)
I have tried may be ten different methods,
1. changing catalina.policy,
2. INSERT INTO db VALUES('localhost.localdomain' in Mysql
3. changing java.policy
among them , but NONE of them worked.
I really don't know what to do next.
Any help is really appreciated.
<%@ page import="java.sql.*" %>
<%@ page errorPage="ExceptionHandler.jsp" %>
<html>
<BODY>
<%
Statement s = null;
ResultSet rs = null;
Connection con= null;
out.println("Sunday, January 22, 2006 3:55:31 PM");
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/test?user=my_user&password=my_pass");
}
catch (Exception e)
{
out.println("<p> Error , cause:</p> <b> " + e + "</b>");
}
%>
</BODY>
</HTML>