RE: Connection pool 2

[Halas, Miroslav]

Just a side note, the same is happening with i-net Opta drivers. -----Original Message----- From: Halas, Miroslav Sent: Thursday, July 26, 2001 5:29 PM To: [EMAIL PROTECTED] Subject: Connection pool I am evaluating different JDBC drivers for MS SQLServer with Jonas 2.3. JTurbo driver trial version has limit of 5 connections. This is my datasource file   datasource.name         aqpjdbc datasource.url          jdbc:JTurbo://localhost:1433/database=aqp datasource.classname    com.ashna.jturbo.driver.Driver datasource.username     ******* datasource.password     ****** datasource.mincon         5 datasource.maxcon        5     # ------------------------------------------------------------- # JDBC Connection Pool Configuration # -------------------------------------------------------------   jdbc.minconpool 5 jdbc.maxconpool            %     #  JDBC connection checking level. #     0 = no special checking #     1 = check physical connection is still open before reusing it #     2 = try every connection before reusing it jdbc.connchecklevel       1   #  max age for jdbc connections #     nb of minutes a connection can be kept in the pool jdbc.connmaxage                       30   #  max concurrent threads on same tx/connection jdbc.connmaxthreads     4   #  max wait time if more than connmaxthreads threads request conn #     value is in seconds jdbc.connexcltimeout     30   # test statement jdbc.connteststmt          select 1     The test is failing with error Could not get Connection on jdbc:JTurbo://localhost:1433/database=aqp: java.sql.SQLException: « Ashna Inc. You are licensed for only 5 Connections. java.sql.SQLException: « Ashna Inc. You are licensed for only 5 Connections.  System Exception in business method:javax.ejb.EJBException  System Exception raised by request: javax.ejb.EJBException  System Exception in business method:javax.ejb.EJBException   I cannot see any problem with my configuration file (tried different numbers for min/max connections). Can you see any? Is it a problem of Jonas? I have 20 clients connecting to the server. Only 5 of them get connection and the rest fails but sometimes (not consistent) even some of those five throw an error   doDetach: javax.transaction.SystemException: Cannot send XA end:javax.transaction.xa.XAException         at org.objectweb.jonas_tm.TransactionImpl.delistResource(TransactionImpl.java:201)         at org.objectweb.jonas_tm.Current.doDetach(Current.java:639)         at org.objectweb.jonas_tm.Current.commit(Current.java:202)         at org.objectweb.jonas_ejb.container.JBean.postinvoke(JBean.java:182)         at org.objectweb.jonas_ejb.container.JBeanSession.postinvoke(JBeanSession.java:190)         at org.objectweb.jonas_ejb.container.JBeanSessionSl.postinvoke(JBeanSessionSl.java:166)         at com.compuware.cgf.beans.document.JOnAScom_compuware_cgf_beans_document_DocumentControllerRemote.remove(JOnASc om_compuware_cgf_beans_document_DocumentControllerRemote.java:420)         at com.compuware.cgf.beans.core.ControllerFactory.destroyDocumentController(ControllerFactory.java:682)         at com.compuware.cgf.beans.user.UserControllerBean.resolveDocumentDependencies(UserControllerBean.java:1142)         at com.compuware.cgf.beans.core.CoreDocumentStatelessControllerBean.resolveDocumentDependencies(CoreDocumentStat elessControllerBean.java:4614)         at com.compuware.cgf.beans.core.CoreDocumentStatelessControllerBean.get(CoreDocumentStatelessControllerBean.java :894)         at com.compuware.cgf.beans.user.JOnAScom_compuware_cgf_beans_user_UserControllerRemote.get(JOnAScom_compuware_cg f_beans_user_UserControllerRemote.java:224)         at com.compuware.cgf.tools.UserWorker.run(UserStressTest.java:171)         at java.lang.Thread.run(Thread.java:484) XAResource ---> commit: XA START without XA END XAResource ---> commit: XA START without XA END     This doesn't happen with any other driver. Any ideas? Thanks a lot,   Miro Halas