Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA01863 for ; Wed, 26 Jan 2000 22:30:07 -0500 (EST) (envelope-from jks@p1.selectacast.net) Received: from p1.selectacast.net (p1.selectacast.net [206.41.1.251]) by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id WAA20809 for ; Wed, 26 Jan 2000 22:04:39 -0500 (EST) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id WAA17899; Wed, 26 Jan 2000 22:02:37 -0500 Sender: jks@p1.selectacast.net Message-ID: <388FB54C.91B66F34@selectacast.net> Date: Wed, 26 Jan 2000 22:02:37 -0500 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Donaldson CC: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] Servlets and JDBC driver: Access Exception References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Use policytool to grant the codebase file://- a socketpermission for that ipaddress with connect and resolve. Tom Donaldson wrote: > 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 > > ************