[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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