Received: from mail.ultracom.net (mail.ultracom.net [209.166.1.26]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA34038 for ; Mon, 24 Jan 2000 20:52:25 -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 ; Mon, 24 Jan 2000 20:40:29 -0500 From: "Tom Donaldson" To: Subject: JDK1.2 Driver to Postgresql 6.5.3 - connection problem Date: Mon, 24 Jan 2000 20:54:51 -0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01BF66AD.4274A7E0" 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 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01BF66AD.4274A7E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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(); Any ideas as to the cause and solution. Thanks in advance for any help Tom Donaldson ------=_NextPart_000_0000_01BF66AD.4274A7E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I am = using Javasoft=20 JDK1.2.2, with the Postgresql 6.5 driver for JDK1.2, running under = Windows 98 at=20 present (though I'll be switching to Linux once the JDK1.2 production = release is=20 available). I am running from a JSP page executing on Sun's=20 JavaWebServer2.0.
 
I am = receiving the=20 following exception when trying to connect to my Postgresql=20 database:
 
Something unusual has occured to cause = the driver=20 to fail. Please report this exception: = java.security.AccessControlException:=20 access denied (java.net.SocketPermission 192.168.254.4:5432=20 connect,resolve)
at postgresql.Driver.connect(Driver.java:125)
at=20 java.sql.DriverManager.getConnection(DriverManager.java:457)
at=20 java.sql.DriverManager.getConnection(DriverManager.java:137)
at=20 pagecompile.jsp._postgre._jspService(_postgre.java:72)
at=20 com.sun.server.http.pagecompile.jsp.runtime.HttpJspBase.service(HttpJspBa= se.java:87)
at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at=20 com.sun.server.http.pagecompile.jsp.runtime.JspServlet.runServlet(JspServ= let.java:469)
at=20 com.sun.server.http.pagecompile.jsp.runtime.JspServlet.processJspPage(Jsp= Servlet.java:259)
at=20 com.sun.server.http.pagecompile.jsp.runtime.JspServlet.service(JspServlet= .java:97)
at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at=20 com.sun.server.ServletState.callService(ServletState.java:226)
at=20 com.sun.server.ServletManager.callServletService(ServletManager.java:936)=
at=20 com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:4= 23)
at=20 com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:= 79)
at=20 com.sun.server.http.stages.Runner.process(Runner.java:79)
at=20 com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
a= t=20 com.sun.server.Service.process(Service.java:204)
at=20 com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.j= ava:374)
at=20 com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.j= ava:166)
at=20 com.sun.server.HandlerThread.run(HandlerThread.java:162)
 
 
The = code I'm calling=20 from is

Class.forName("postgresql.Driver");

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

java.sql.Statement st =3D=20 db.createStatement();

Any ideas as to the = cause and=20 solution.

Thanks in advance for = any=20 help

Tom = Donaldson

 

------=_NextPart_000_0000_01BF66AD.4274A7E0--