Received: from mail.ultracom.net (mail.ultracom.net [209.166.1.26])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA49870
	for <pgsql-interfaces@postgresql.org>;
	Mon, 24 Jan 2000 21:31:04 -0500 (EST)
	(envelope-from tom@upstartinventions.com)
Received: from upstartmaster ([209.166.22.75]) by mail.ultracom.net
	(Post.Office MTA v3.5.3 release 223 ID# 0-62403U7500L750S0V35)
	with SMTP id net for <pgsql-interfaces@postgresql.org>;
	Mon, 24 Jan 2000 21:19:07 -0500
From: "Tom Donaldson" <tom@upstartinventions.com>
To: <pgsql-interfaces@postgreSQL.org>
Subject: Servlets and JDBC driver: Access Exception  
Date: Mon, 24 Jan 2000 21:33:30 -0500
Message-ID: <NDBBIBACDMIGENOIPLDMIELACBAA.tom@upstartinventions.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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