Thread: BUG #1048: error connection to dbms from java app server

BUG #1048: error connection to dbms from java app server

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1048
Logged by:          Christopher Conlon

Email address:      chrisc@csh.rit.edu

PostgreSQL version: 7.4

Operating system:   FreeBSD 5.1

Description:        error connection to dbms from java app server

Details:

I get an error from Jboss app server when trying to connect to postgresql. I
am using the jdbc driver that was built with --with-java.  This same bug
showed up when  I tried to use Postgres 7.3.4.

17:40:30,661 WARN  [JBossManagedConnectionPool] Throwable while attempting
to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (java.sql.SQLException: ERROR:  unrecognized configuration
 parameter "xactisolevel"
)
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createM
        at anagedConnection(LocalManagedConnectionFactory.java:160)
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createCo
        at nnectionEventListener(InternalManagedConnectionPool.java:477)
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConne
        at ction(InternalManagedConnectionPool.java:213)
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.ge
        at tConnection(JBossManagedConnectionPool.java:496)
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConne
        at ction(BaseConnectionManager2.java:425)
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnecti
        at on(TxConnectionManager.java:318)
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnect
        at ion(BaseConnectionManager2.java:477)
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManag
        at erProxy.allocateConnection(BaseConnectionManager2.java:814)
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperData
        at Source.java:102)
        at truss.user.UserBean.makeConnection(UserBean.java:142)
        at truss.user.UserBean.insertRow(UserBean.java:162)
        at truss.user.UserBean.ejbCreate(UserBean.java:32)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceMana
        at ger.java:196)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEnti
        at ty(CachedConnectionInterceptor.java:269)
        at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContain
        at er.java:1043)
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySyn
        at chronizationInterceptor.java:197)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome
        at (CachedConnectionInterceptor.java:214)
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.ja
        at va:88)
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceIn
        at terceptor.java:89)
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockIntercepto
        at r.java:61)
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationIn
        at terceptor.java:28)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto
        at r.java:88)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT
        at .java:267)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.ja
        at va:92)
        at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactory
        at FinderInterceptor.java:93)
        at
org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
        at org.jboss.ejb.Container.invoke(Container.java:720)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispa
        at tcher.java:284)
        at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
        at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
        at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:4
        at 6)
        at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
        at
org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
        at $Proxy86.create(Unknown Source)
        at truss.user.UserSessionBean.createUser(UserSessionBean.java:59)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Statele
        at ssSessionContainer.java:683)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cac
        at hedConnectionInterceptor.java:185)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessS
        at essionInstanceInterceptor.java:72)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto
        at r.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT
        at .java:267)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:1
        at 18)
        at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFind
        at erInterceptor.java:122)
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionCont
        at ainer.java:331)
        at org.jboss.ejb.Container.invoke(Container.java:700)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispa
        at tcher.java:284)
        at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
        at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
        at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:4
        at 6)
        at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInte
        at rceptor.java:100)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
        at $Proxy84.createUser(Unknown Source)
        at org.apache.jsp.index_jsp._jspService(index_jsp.java:76)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
        at 210)
        at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
        at nFilterChain.java:247)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
        at hain.java:193)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
        at ava:256)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
        at ava:191)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgr
        at Realm.java:220)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:
        at 246)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerSta
        at tsValve.java:76)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
        at 0)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
        at .java:171)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
        at 2)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssoc
        at iationValve.java:65)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
        at a:174)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
        at ection(Http11Protocol.java:549)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
        at va:677)
        at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ERROR:  unrecognized configuration
parameter "xactisolevel"

        at org.postgresql.core.QueryExecutor.execute(Unknown Source)
        at org.postgresql.Connection.ExecSQL(Unknown Source)
        at org.postgresql.Connection.ExecSQL(Unknown Source)
        at org.postgresql.Connection.getTransactionIsolation(Unknown Source)
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.<init>(BaseWra
        at pperManagedConnection.java:90)
org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.<init>(LocalMa
        at nagedConnection.java:57)
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createM
        at anagedConnection(LocalManagedConnectionFactory.java:156)
        ... 125 more
17:40:30,762 ERROR [LogInterceptor] TransactionRolledbackException in
method: public abstract truss.user.UserRemote
truss.user.UserRemoteHome.create(j
ava.lang.String,java.lang.String) throws
java.rmi.RemoteException,javax.ejb.CreateException, causedBy:
javax.ejb.EJBException: ejbCreate: Could not create connection; - nested
throwable: (java.sql.SQLException: ERROR:  unrecognized configuration
paramet
er "xactisolevel"
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not
create connection; - nested throwable: (java.sql.SQLException: ERROR:  un
recognized configuration parameter "xactisolevel"
))
        at truss.user.UserBean.ejbCreate(UserBean.java:37)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceMana
        at ger.java:196)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEnti
        at ty(CachedConnectionInterceptor.java:269)
        at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContain
        at er.java:1043)
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySyn
        at chronizationInterceptor.java:197)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome
        at (CachedConnectionInterceptor.java:214)
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.ja
        at va:88)
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceIn
        at terceptor.java:89)
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockIntercepto
        at r.java:61)
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationIn
        at terceptor.java:28)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto
        at r.java:88)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT
        at .java:267)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.ja
        at va:92)
        at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactory
        at FinderInterceptor.java:93)
        at
org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
        at org.jboss.ejb.Container.invoke(Container.java:720)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispa
        at tcher.java:284)
        at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
        at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
        at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:4
        at 6)
        at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
        at
org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
        at $Proxy86.create(Unknown Source)
        at truss.user.UserSessionBean.createUser(UserSessionBean.java:59)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Statele
        at ssSessionContainer.java:683)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cac
        at hedConnectionInterceptor.java:185)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessS
        at essionInstanceInterceptor.java:72)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto
        at r.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT
        at .java:267)
        at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:1
        at 18)
        at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFind
        at erInterceptor.java:122)
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionCont
        at ainer.java:331)
        at org.jboss.ejb.Container.invoke(Container.java:700)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
        at 9)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
        at l.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispa
        at tcher.java:284)
        at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
        at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
        at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:4
        at 6)
        at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInte
        at rceptor.java:100)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
        at $Proxy84.createUser(Unknown Source)
        at org.apache.jsp.index_jsp._jspService(index_jsp.java:76)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
        at 210)
        at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
        at nFilterChain.java:247)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
        at hain.java:193)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
        at ava:256)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
        at ava:191)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgr
        at Realm.java:220)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:
        at 246)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerSta
        at tsValve.java:76)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
        at 0)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
        at .java:171)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
        at 2)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssoc
        at iationValve.java:65)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
        at a:174)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
        at keNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
        at ection(Http11Protocol.java:549)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
        at va:677)
        at java.lang.Thread.run(Thread.java:534)

Re: BUG #1048: error connection to dbms from java app server

From
Kris Jurka
Date:
On Sat, 10 Jan 2004, PostgreSQL Bugs List wrote:

>
> The following bug has been logged online:
>
> PostgreSQL version: 7.4
>
> Operating system:   FreeBSD 5.1
>
> Description:        error connection to dbms from java app server
>
>
> I get an error from Jboss app server when trying to connect to postgresql. I
> am using the jdbc driver that was built with --with-java.  This same bug
> showed up when  I tried to use Postgres 7.3.4.

You are not using the correct jdbc driver.  The outrageously long stack
trace shows the org.postgresql.Connection class involved which does not
exist in either the 7.3 or 7.4 drivers.  You may have an old version
somewhere in your classpath.

Kris Jurka