java.security.AccessControlException - ? n idea why

Hi all, i have been getting this message with my server all day but just with one page i have made.

jsp page code:

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>

<%

String url ="jdbc:mysql://p41mysql47.secureserver.net:3306/morgandesign";

String user="morgandesign";

String pass="j14E03m87";

try{

Class.forName("com.mysql.jdbc.Driver").newInstance ();

//get parameter to search by

String Email = request.getParameter("custUsername");

String Password = request.getParameter("custPassword");

// pass database parameters to JDBC driver

Connection conn = DriverManager.getConnection(url, user, pass);

// query statement

Statement stmt = conn.createStatement();

// generate query

String selectSQL ="SELECT * FROM md_customer_base where cust_email = '" + Email +"' and cust_pass = '" + Password +"'";

//out.println(selectSQL);

// get result

ResultSet rs1 = stmt.executeQuery(selectSQL);//results set got back form DB query

boolean validLogon;

//change int to string

if (rs1.next()){validLogon =true;

out.println("valid logon");

//--cookies for valid logon//

//email adress

String username=rs1.getString("cust_email");

if(username==null) username="";

Cookie cookie =new Cookie ("md_custUsername",username);

cookie.setMaxAge(-1);//expires after session

response.addCookie(cookie);

//userID

String adminID=rs1.getString("cust_id");

if(adminID==null) adminID="";

Cookie cookie2 =new Cookie ("md_custID",adminID);

cookie2.setMaxAge(-1);//expires after session

response.addCookie(cookie2);

//-//

//adds OBJECT session variables//

session.setAttribute("custEmail", Email);//set it

session.setAttribute("custID", adminID);//set it

Object JSESSIONID = session.getId();//gets sessionID

//-//

//direct to custControlPannelPage with details of who it is etc.

response.sendRedirect("custControlPannel.jsp?validLogin=True"+"&custEmail="+Email+"&custID="+adminID+"&JSESSIONID="+JSESSIONID);

}

else{ validLogon =false;

out.println("invlaid logon");

response.sendRedirect("customerLogin.jsp?validLogin=False");

}

// close connection

stmt.close();

conn.close();

}catch(Exception e)

{

out.println(e.toString());

}

%>

error msg code:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.security.AccessControlException

MESSAGE: access denied (java.net.SocketPermission p41mysql47.secureserver.net resolve)

STACKTRACE:

java.security.AccessControlException: access denied (java.net.SocketPermission p41mysql47.secureserver.net resolve)

at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)

[5078 byte] By [JamesMorgana] at [2007-11-27 9:32:37]
# 1
Maybe you could show more of the stack trace?Is your MySQL server configured to allow connections from this machine/user?Is there maybe a firewall or something in the way?
evnafetsa at 2007-7-12 22:51:13 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2

here is the full error msg, not sure why, i have the correct username and passdword etc.

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.security.AccessControlException

MESSAGE: access denied (java.net.SocketPermission p41mysql47.secureserver.net resolve)

STACKTRACE:

java.security.AccessControlException: access denied (java.net.SocketPermission p41mysql47.secureserver.net resolve)

at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)

at java.security.AccessController.checkPermission(AccessController.java:427)

at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)

at java.lang.SecurityManager.checkConnect(SecurityManager.java:1031)

at java.net.InetAddress.getAllByName0(InetAddress.java:1117)

at java.net.InetAddress.getAllByName0(InetAddress.java:1098)

at java.net.InetAddress.getAllByName(InetAddress.java:1061)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:137)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)

at com.mysql.jdbc.Connection.<init>(Connection.java:1531)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at org.apache.jsp.customer.customerLoginCheck_jsp._jspService(customerLoginCheck_jsp.java:60)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:239)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:266)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:157)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:140)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:417)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)

at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)

at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)

at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)

at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

at java.lang.Thread.run(Thread.java:595)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.

JamesMorgana at 2007-7-12 22:51:13 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...