Re: [cobalt-developers] Java Server Application using PostgreSQL: Success Stories?

["Paul Adamson" <paul@xxxxxxxxxxxxx>]

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" <voiklis@xxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
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
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>