EAServer 6.3 Oracle Connection Cache problem

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)

0
Marc
12/3/2009 10:11:46 AM
sybase.easerver.general 7903 articles. 0 followers. Follow

0 Replies
227 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

easerver 3.6.1 C1 and oracle 8.1.6 connection cache driver
What parameters must I use to make a connection cache beetwen Jaguar 3.6.1 and Oracle 8.1.6? Jim O'Neill already answers this: >ODBC, JDBC or native OCI caches will work. If you are using native >OCI caches though, be advised there is a problem when using 8.1.6+ >client software. That problem is remedied in the eagerly awaited EBF >#1 to EAServer. I loaded the EBF#1 and still can't make the connection cache work. For the server name, I use the name of the Net8 service naming (orcl). I tried an other name with a oracle SID name, with no effect. For the...

Connection cache creation (EAServer 3.6.1 C2 (Bld: 36110), Oracle 8.1.7 client
Unable to successfully ping the data source. Error Message: "Ping for <cache_name> OCI_8 Connection Cache failed: The Ping operation did not complete successfully. Could not find the specified connection cache" Here's my connection cache properties. a) Servername: specified the Oracle SID without the "@" symbol b) user_name and password entered. c) Driver - oci.dll , OCI 8.x radio button checked. Expedited help is requested. Is the cache installed in a particular server? On Thu, 18 Apr 2002 22:29:15 -0400, Ram_L wrote: >...

Problem in creating Oracle connection cache using EAServer 5.0,Oracle 10g
This is a multi-part message in MIME format. ---=_forums-2-dub417ced02 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit I am facing problem to create connection cache using Oracle.I am attaching snapshot of EAServer properties which I set. I refered query dt. 21 jul,04 topic "EAServer JDBC connection to Oracle". But it not works. ---=_forums-2-dub417ced02 Content-Type: application/x-zip-compressed; name="Oracle connection cache problem.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=&q...

EAServer 3.6.1, Solaris 2.6 SVU Example cache connection
Hello group, I've got a fresh install on the above (subj) enviornment. I'm running witht the jagsrv_jdk12 startup. I have started the jagdemo.db. When I ping the installed cache connection for the Sample the manager the server process locks (No repaint or response in the manager, and a new manager session cannot connect to the jagsrvr) I do have the libodbc.so in my LD_LIBRARY_PATH and have verified the complete path to to the Driver is in the odbc.ini. Stuck, Stuck, Stuck, Thanks in advance. Is there any errors in the srv.log? Also can you connect to the datab...

EASERVER 3.5 and EASERVER 3.6
Hi ALL Who can tell me the difference between with EASERVER 3.5 and EASERVER 3.6 (EASERVER 3.6.1) thanks 361 is J2EE 1.2 complianant 36 is close to being compliant, and the final features are in 361 for J2EE 1.2 EAS 35 supports ejb 1.0. I strongly suggest you upgrade to 361. ...

How to setup connection property in Connection Cache using EAServer 3.6.1 + JDBC 2.0
Hi, The following properties is my connection cache property. Server Name ---> NetworkProtocol=Tds:Server=localhost:Port=4100:DatabaseName=odwas Class Name ---> com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource I am using the JDBC 2.0 to connect with my ASE 12.0 Server. I check all of the books about JDBC API. I could not find more information about connection property with JDBC 2.0 + Sybase jConnect 5.2. I already try to use the connection cache property file but it could not work. Do anyone know how to put the "PACKETSIZE" property to "Server Na...

Oracle Connection Cache Problem In EAServer 5.0
Hi, I create a connection cache for oracle using JDBC Oracle9i Enterprise Edition Release 9.2.0.1.0 JDBC driver is class12.jar JDBC class being used is oracle.jdbc.driver.OracleDriver Server entry is jdbc:oracle:thin:@host:port:sid Connection cache pings OK from jaguar manager EAServer v5.0 Jaguar Manager is running JDK1.3. When attempting to connect to the connection cache from a PowerBuilder NVO, however connection established but following error is loged in EAServer log every time a 'connect' or 'disconnect' statement execute. java.sql.SQLException: Overf...

Error with Connection Cache in EAServer 3.6.1
Hi, I have successfully used my Web application EAServer 3.6, but when it turn to EAServer 3.6.1, I cannot run the Web application at all ( I cannot login to my web application ), finally the problem seems to be solved by turning the no of cache in the connection Caches from 10 to 100, but a error message also comes out in the srv.log : Network error: status = 29 - Net-Library operation terminated due to disconnect Mar 09 14:22:38 2001: SRVLIB Message: 16240/10/0: Net-Library routine net_write() failed in srv_rawwrite Network error: status = 60 - Attempt to use invalid ...

EAServer 3.5 Connection Cache and Oracle 8i
I read a previous post on this subject whereby OCI connection caches in EAServer 3.5 do not work with Oracle 8i client. To follow up, I am having the same problem, and here are the facts: 1. EAServer 3.0 and Oracle 8i (8.1.5) client works. 2. EAServer 3.5 and Oracle 8i (8.1.5) client DOES NOT work (cannot find XA80.dll). 3. EAServer 3.5 and Oracle 8i (8.1.6) client DOES NOT work (cannot find XA80.dll). 4. EAServer 3.5 and Oracle 8.0.5 client works. Let me be clear that it WAS working with EAServer 3.0, then I simply upgraded to 3.5 and it no longer worked. I had to then ins...

EAServer 6.3 / ORACLE : Java connection PING but fails to SELECT
Hi, We have a new installation of EAServer 6.3 (upgraded from 5.5). The Java and PowerBuilder connections PING to the Oracle 10. The PowerBuilder connection works perfectly, but the Java connection fails to SELECT from DB. In the JAGUAR log we see the log below. After GOOGLING for a solution we=92ve tested with other Oracle Client versions: 10.2, 10.2.0.4 and 11; But the problem continues. Any idea what should be done on this? Thank you, Michael Voichek =3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d...

EAS 3.6.1 C1 & Oracle 8.1.7 Connection Cache Problem
I am experiencing inconsistent results when using an OCI 8.x connection cache with EAServer 3.6.1 C1 release. There are a few times when everything (i.e. database retrieves and updates) is working fine. If I close the browser (both IE 5.5 and Netscape 4.76) and try the same sequence of events again, Jaguar hangs while trying to connect to the connection cache. Most of the time, we can't even get a single update to work. There doesn't appear to be a pattern on why it works sometimes and doesn't work most of the time. I am not experiencing any problems if I use the...

serious problem with EAServer 3.6.1 ESD 3
This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C1815D.36DDC610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I think I have discovered a problem with form based authentication for web applications in ESD 3. I created a web application and tried to set up security to use form-based authentication. Using jaguar manager, I opened the properties for my web app, and changed authentication method to FORM, login page to /security/login.jsp and error page to /security/error.jsp. After restarting Jaguar, I tried to acc...

EAServer 3.6 and Oracle 8.1.6
We are developing a Web Application using EAServer 3.6. Our development platform is Jaguar 3.6 (Build 36017) on Sun-Solaris 7. We have deployed PB Components. Development Database Server is Oracle 8.1.5 on Sun-Solaris. Oracle client is 8.1.5 on Sun-Solaris. We use OCI8 Connection cache from Jaguar to connect to Oracle 8.1.5. This environment is working fine. Our Web Application is going to be in Production very soon. In order to install the Oracle Database Server in the Production machine, We approached Oracle for Licensing. They are advising us to install Oracle 8.1.6 in the Produc...

EAServer 3.6.1 C3 Solaris / PB 7.0.3 / Oracle 8.3) Empty Blob passed to Client
Hi all, I have a problem with PB 7.0.3 and EAS 3.6.1 C3 on Solaris 2.8. I defined a datawindow with PB that is supposed to show a list of all customers from an Oracle DB. On the server side it all seems to work well. The return status is ok and the number of rows inside the blob is exactly the number of rows in the customer table. When I check the blob after it's transfered to the client, the number of rows is 0. Any help is highly appreciated! Kind regards, Markus ...

Web resources about EAServer 6.3 Oracle Connection Cache problem - sybase.easerver.general

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
If you send more email, you might make more money. Then again, you might destroy your reputation and revenue stream. Here's how to know what ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

MOTHER’S DAY: Facebook Examines Connections Between Moms, Kids
With Mother’s Day on the calendar this coming Sunday, Facebook examined the relationships between mothers and their children on the social network, ...

Police tear open roof to arrest man in connection with stabbing murder
Police have torn open the roof of a Gold Coast home to arrest a man in connection with the stabbing death of 16-year-old Michael Brack.

Paris attacks: Belgium connection probed as terrorist past of Brussels district of Molenbeek under spotlight ...
Prosecutors reveal a growing Belgian connection to the deadly Paris attacks, focusing on a poor Brussels district.

Cross-cultural Connections and Exchange: international study is more important than ever
... And, as a minority of ill-intentioned individuals and groups do their best to create divides, we need citizens equipped to create connections ...

Brussels Connection Under Spotlight After Paris Killings
(EurActiv) — Prosecutors on Sunday disclosed a growing Belgian connection to the Paris attacks as Premier Charles Michel conceded that a Brussels ...

Get ready for live-streamed extreme sports: Seattle startup Sioeye adds 4G connection to action cam
The history of people doing crazy stunts on camera is full of notable achievements. Motorcycle daredevil Evel Knievel jumped over whatever he ...

The First Android Wear Watch With a Cell Connection Has Been Pulled From Stores
The LG Watch Urbane 2 was notable among many other Android Wearables because of what’s inside: a cellular radio. But due to an unidentified ‘quality ...

resources last updated: 11/20/2015 12:49:00 AM