Servlets and JDBC driver: Access Exception

From: "Tom Donaldson" <tom(at)upstartinventions(dot)com>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Servlets and JDBC driver: Access Exception
Date: 2000-01-25 02:33:30
Message-ID: NDBBIBACDMIGENOIPLDMIELACBAA.tom@upstartinventions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I am using Javasoft JDK1.2.2, with the Postgresql 6.5 driver for JDK1.2,
running under Windows 98 at present (though I'll be switching to Linux once
the JDK1.2 production release is available). I am running from a JSP page
executing on Sun's JavaWebServer2.0.

I am receiving the following exception when trying to connect to my
Postgresql database:

Something unusual has occured to cause the driver to fail. Please report
this exception: java.security.AccessControlException: access denied
(java.net.SocketPermission 192.168.254.4:5432 connect,resolve)
at postgresql.Driver.connect(Driver.java:125)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at pagecompile.jsp._postgre._jspService(_postgre.java:72)
at
com.sun.server.http.pagecompile.jsp.runtime.HttpJspBase.service(HttpJspBase.
java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.runServlet(JspServlet
.java:469)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.processJspPage(JspSer
vlet.java:259)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.service(JspServlet.ja
va:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.server.ServletState.callService(ServletState.java:226)
at com.sun.server.ServletManager.callServletService(ServletManager.java:936)
at
com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:423)
at
com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:79)
at com.sun.server.http.stages.Runner.process(Runner.java:79)
at com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
at com.sun.server.Service.process(Service.java:204)
at
com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
:374)
at
com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
:166)
at com.sun.server.HandlerThread.run(HandlerThread.java:162)

The code I'm calling from is
Class.forName("postgresql.Driver");

java.sql.Connection db =
java.sql.DriverManager.getConnection("jdbc:postgresql://192.168.254.4:5432/S
essamiLondon","Postgre","xxxxxxxxxxx");

java.sql.Statement st = db.createStatement();

The commands execute successfully when I call them from a Main class, using
the same JDK and driver. Any suggestions as to how to get this working.

Thanks in advance for any help

Tom Donaldson

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Constantin Teodorescu 2000-01-25 07:01:45 Re:
Previous Message Donald J. Richards 2000-01-24 19:25:03 Complications with Crystal Reports