i've a messy java program i wrote to get the jdbc-postgres connection working, i'll post it when i get home, it's usually enough to find out where the problem lives.
Paul. ----- Original Message ----- From: "John Voiklis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 10:34 AM Subject: [cobalt-developers] Java Server Application using PostgreSQL: Success Stories? > I can't even establish a database connection. > > I downloaded the 7.0.x version of the jdbc driver and put it the Tomcat > classpath; I added the -i flag the /etc/rc.d/init.d/postgresql startup > script. > > I loaded the war files for Jive forum app (which, as you will see, keeps a > log of exceptions). When I try the simple connection test, I get the > following error: > > Starting ConnectionPool: > dbDriver = org.postgresql.Driver > dbServer = jdbcostgresql://localhost/mlewGuestForum > dbLogin = postgres > log file = > /home/sites/site4/web/WEB-INF/jiveHome/logs/DefaultConnectionProvider.log > minconnections = 3 > maxconnections = 10 > Total refresh interval = 0.5 days > ----------------------------------------- > --->Attempt (1 of 5) failed to create new connections set at startup: > Something unusual has occured to cause the driver to fail. Please report > this exception: Exception: java.security.AccessControlException: access > denied (java.net.SocketPermission localhost resolve) > Stack Trace: > > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) > at > java.security.AccessControlContext.checkPermission(AccessControlContext.java > :272) > at java.security.AccessController.checkPermission(AccessController.java:399) > at java.lang.SecurityManager.checkPermission(SecurityManager.java:545) > at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042) > at java.net.InetAddress.getAllByName0(InetAddress.java:559) > at java.net.InetAddress.getAllByName0(InetAddress.java:540) > at java.net.InetAddress.getByName(InetAddress.java:449) > at java.net.Socket.<init>(Socket.java:100) > at org.postgresql.PG_Stream.<init>(PG_Stream.java:40) > at org.postgresql.Connection.openConnection(Connection.java:131) > at org.postgresql.Driver.connect(Driver.java:122) > at java.sql.DriverManager.getConnection(DriverManager.java:517) > at java.sql.DriverManager.getConnection(DriverManager.java:177) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.cre > ateConn(Unknown Source) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<in > it>(Unknown Source) > at com.jivesoftware.forum.database.DefaultConnectionProvider.start(Unknown > Source) > at > com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(Conn > ectionManager.java:204) > at > f_00025rum.admin.setup._0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_00 > 02ejspsetup3_jsp_0._jsp > Service(_0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_0002ejspsetup3_js > p_0.java:426) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja > va:130) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > va:282) > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) > at org.apache.tomcat.core.Handler.service(Handler.java:287) > at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) > at > org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 > 2) > at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection > (Ajp12ConnectionHandler .java:166) > at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) > at java.lang.Thread.run(Thread.java:484) > End of Stack Trace > > Will try again in 10 seconds... > --->Attempt (2 of 5) failed to create new connections set at startup: > Something unusual has occured to cause the driver to fail. Please report > this exception: Exception: java.security.AccessControlException: access > denied (java.net.SocketPermission localhost resolve) > Stack Trace: > > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) > at > java.security.AccessControlContext.checkPermission(AccessControlContext.java > :272) > at java.security.AccessController.checkPermission(AccessController.java:399) > at java.lang.SecurityManager.checkPermission(SecurityManager.java:545) > at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042) > at java.net.InetAddress.getAllByName0(InetAddress.java:559) > at java.net.InetAddress.getAllByName0(InetAddress.java:540) > at java.net.InetAddress.getByName(InetAddress.java:449) > at java.net.Socket.<init>(Socket.java:100) > at org.postgresql.PG_Stream.<init>(PG_Stream.java:40) > at org.postgresql.Connection.openConnection(Connection.java:131) > at org.postgresql.Driver.connect(Driver.java:122) > at java.sql.DriverManager.getConnection(DriverManager.java:517) > at java.sql.DriverManager.getConnection(DriverManager.java:177) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.cre > ateConn(Unknown Source) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<in > it>(Unknown Source) > at com.jivesoftware.forum.database.DefaultConnectionProvider.start(Unknown > Source) > at > com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(Conn > ectionManager.java:204) > at > f_00025rum.admin.setup._0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_00 > 02ejspsetup3_jsp_0._jsp > Service(_0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_0002ejspsetup3_js > p_0.java:426) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja > va:130) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > va:282) > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) > at org.apache.tomcat.core.Handler.service(Handler.java:287) > at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) > at > org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 > 2) > at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection > (Ajp12ConnectionHandler .java:166) > at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) > at java.lang.Thread.run(Thread.java:484) > End of Stack Trace > > Will try again in 10 seconds... > --->Attempt (3 of 5) failed to create new connections set at startup: > Something unusual has occured to cause the driver to fail. Please report > this exception: Exception: java.security.AccessControlException: access > denied (java.net.SocketPermission localhost resolve) > Stack Trace: > > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) > at > java.security.AccessControlContext.checkPermission(AccessControlContext.java > :272) > at java.security.AccessController.checkPermission(AccessController.java:399) > at java.lang.SecurityManager.checkPermission(SecurityManager.java:545) > at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042) > at java.net.InetAddress.getAllByName0(InetAddress.java:559) > at java.net.InetAddress.getAllByName0(InetAddress.java:540) > at java.net.InetAddress.getByName(InetAddress.java:449) > at java.net.Socket.<init>(Socket.java:100) > at org.postgresql.PG_Stream.<init>(PG_Stream.java:40) > at org.postgresql.Connection.openConnection(Connection.java:131) > at org.postgresql.Driver.connect(Driver.java:122) > at java.sql.DriverManager.getConnection(DriverManager.java:517) > at java.sql.DriverManager.getConnection(DriverManager.java:177) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.cre > ateConn(Unknown Source) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<in > it>(Unknown Source) > at com.jivesoftware.forum.database.DefaultConnectionProvider.start(Unknown > Source) > at > com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(Conn > ectionManager.java:204) > at > f_00025rum.admin.setup._0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_00 > 02ejspsetup3_jsp_0._jsp > Service(_0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_0002ejspsetup3_js > p_0.java:426) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja > va:130) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > va:282) > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) > at org.apache.tomcat.core.Handler.service(Handler.java:287) > at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) > at > org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 > 2) > at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection > (Ajp12ConnectionHandler .java:166) > at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) > at java.lang.Thread.run(Thread.java:484) > End of Stack Trace > > Will try again in 10 seconds... > --->Attempt (4 of 5) failed to create new connections set at startup: > Something unusual has occured to cause the driver to fail. Please report > this exception: Exception: java.security.AccessControlException: access > denied (java.net.SocketPermission localhost resolve) > Stack Trace: > > java.security.AccessControlException: access denied > (java.net.SocketPermission localhost resolve) > at > java.security.AccessControlContext.checkPermission(AccessControlContext.java > :272) > at java.security.AccessController.checkPermission(AccessController.java:399) > at java.lang.SecurityManager.checkPermission(SecurityManager.java:545) > at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042) > at java.net.InetAddress.getAllByName0(InetAddress.java:559) > at java.net.InetAddress.getAllByName0(InetAddress.java:540) > at java.net.InetAddress.getByName(InetAddress.java:449) > at java.net.Socket.<init>(Socket.java:100) > at org.postgresql.PG_Stream.<init>(PG_Stream.java:40) > at org.postgresql.Connection.openConnection(Connection.java:131) > at org.postgresql.Driver.connect(Driver.java:122) > at java.sql.DriverManager.getConnection(DriverManager.java:517) > at java.sql.DriverManager.getConnection(DriverManager.java:177) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.cre > ateConn(Unknown Source) > at > com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<in > it>(Unknown Source) > at com.jivesoftware.forum.database.DefaultConnectionProvider.start(Unknown > Source) > at > com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(Conn > ectionManager.java:204) > at > f_00025rum.admin.setup._0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_00 > 02ejspsetup3_jsp_0._jsp > Service(_0002fforum_0002fadmin_0002fsetup_0002fsetup_00033_0002ejspsetup3_js > p_0.java:426) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja > va:130) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > va:282) > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) > at org.apache.tomcat.core.Handler.service(Handler.java:287) > at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) > at > org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 > 2) > at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) > at > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection > (Ajp12ConnectionHandler .java:166) > at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) > at > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) > at java.lang.Thread.run(Thread.java:484) > End of Stack Trace > > Will try again in 10 seconds... > > All attempts at connecting to Database exhausted > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers > _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
