1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mysql access problem

Discussion in 'Plesk for Linux - 8.x and Older' started by fparvini, Jan 22, 2006.

  1. fparvini

    fparvini Guest

    0
     
    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>
     
Loading...