Connection pool

Halas, Miroslav Thu, 26 Jul 2001 15:04:16 -0700

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.

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

This doesn't happen with any other driver. Any ideas? Thanks a lot,

Miro Halas

Connection pool

Reply via email to