Hi there,
We have a connection cache configured to an Oracle 9i database and have a
limit on the number of connections. When accessing the web application via
a browser, refreshing the page rapidly a few times results in a broken
connection cache. The cache cannot be pinged and PowerBuilder cannot
connect to the cache via SQLCA. The only way to restore the cache is either
via refreshing the cache, or restarting the server.
This occurs in a development environment using a development version of
EAServer 6.3 for Windows. The Oracle server is also installed on the same
host. We're migrating from EAServer 5.5 to 6.3 and did not experience this
problem in 5.5.
I've tried using both the JCM_Oracle and Oracle database types and both
experience the same problem. No error shows in the server log till the
cache is down. The error text is at the bottom of this post.
Anyone got any ideas?
Regards,
Marc
Extract from EAServer log :
2009-11-30 15:25:24.121 INFO btpool4-10 [SystemException]
com.sybase.djc.util.ResourceMonitorTimeoutException was thrown by method
com.sybase.jaguar.jcm.JagCm.getConnection
2009-11-30 15:25:24.121 INFO btpool4-10
com.sybase.djc.util.ResourceMonitorTimeoutException: DataSource:cms
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.util.ResourceMonitor.enter(ResourceMonitor.java:111)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:229)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.sql.ConnectionPool.getConnection(ConnectionPool.java:198)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.sql.ConnectionWrapper.checkOpen(ConnectionWrapper.java:198)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.sql.ConnectionWrapper.getConnection(ConnectionWrapper.java:146)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.sql.ConnectionWrapper_DJC.nativeSQL(ConnectionWrapper_DJC.java:102)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.jcm.JagCm.getConnection(JagCm.java:172)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invoke(Native Method)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invoke(JaguarObject.java:303)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invokeControlOperation(JaguarObject.java:118)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject_DJC.invokeControlOperation(JaguarObject_DJC.java:377)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.activate(JaguarObject.java:143)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject_DJC.activate(JaguarObject_DJC.java:78)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrm_EJB.$getObject(n_cms_pscrm_EJB.java:51)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrm_EJB.of_call(n_cms_pscrm_EJB.java:73)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrmRemote.of_call(n_cms_pscrmRemote.java:60)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrmRemote_DJC.access$001(n_cms_pscrmRemote_DJC.java:4)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrmRemote_DJC$1.invoke(n_cms_pscrmRemote_DJC.java:205)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:675)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported(TransactionManager.java:631)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrmRemote_DJC.of_call(n_cms_pscrmRemote_DJC.java:230)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.cms_crmframework.n_cms_pscrmRemote_DJC.$invoke(n_cms_pscrmRemote_DJC.java:129)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarServer.iiopHandler(JaguarServer.java:273)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invoke(Native Method)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invoke(JaguarObject.java:303)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject.invoke(JaguarObject.java:97)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarObject_DJC.invoke(JaguarObject_DJC.java:341)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cms_EJB.of_cms(n_cms_EJB.java:973)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote.of_cms(n_cmsRemote.java:1396)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote_DJC.access$401(n_cmsRemote_DJC.java:4)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote_DJC$5.invoke(n_cmsRemote_DJC.java:1589)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:675)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported(TransactionManager.java:631)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeSupported(TransactionManager.java:1077)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote_DJC.of_cms(n_cmsRemote_DJC.java:1618)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote_DJC.$invoke_0(n_cmsRemote_DJC.java:614)
2009-11-30 15:25:24.121 INFO btpool4-10 at
ejb.components.tscms.n_cmsRemote_DJC.$invoke(n_cmsRemote_DJC.java:520)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.JaguarServer.iiopHandler(JaguarServer.java:273)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.jaguar.server.RequestHandler.processRequest(RequestHandler.java:9)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.rmi.iiop.server.MessageHandler.invokeLocal(MessageHandler.java:383)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.rmi.iiop.server.MessageHandler$1.invoke(MessageHandler.java:123)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.rmi.iiop.client.LocalConnection.invoke(LocalConnection.java:72)
2009-11-30 15:25:24.121 INFO btpool4-10 at
tscms.iiop_stubs.n_cms.of_cms(n_cms.java:273)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.apache.jsp.cms_jsp._jspService(cms_jsp.java:133)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
2009-11-30 15:25:24.121 INFO btpool4-10 at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
2009-11-30 15:25:24.121 INFO btpool4-10 at
web.components.cms.JspServlet_DJC.access$201(JspServlet_DJC.java:4)
2009-11-30 15:25:24.121 INFO btpool4-10 at
web.components.cms.JspServlet_DJC$3.invoke(JspServlet_DJC.java:310)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:675)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.transaction.TransactionManager.invokeBeanManaged(TransactionManager.java:610)
2009-11-30 15:25:24.121 INFO btpool4-10 at
web.components.cms.JspServlet_DJC.service(JspServlet_DJC.java:339)
2009-11-30 15:25:24.121 INFO btpool4-10 at
web.components.cms.JspServlet$WC.service(JspServlet$WC.java:24)
2009-11-30 15:25:24.121 INFO btpool4-10 at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.server.jetty.SybSessionHandler.handle(SybSessionHandler.java:147)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.server.jetty.SybWebAppContext.handle(SybWebAppContext.java:167)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.Server.handle(Server.java:324)
2009-11-30 15:25:24.121 INFO btpool4-10 at
com.sybase.djc.server.jetty.JettyServer.handle(JettyServer.java:171)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:533)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:207)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.jetty.nio.BlockingChannelConnector$Connection.run(BlockingChannelConnector.java:163)
2009-11-30 15:25:24.121 INFO btpool4-10 at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)
|