Hi,
I use PB and close the broker too.
With a single user i have many inactives connections and get the same
exception.
Any idea ?
Thanks,
Vinicius Bomfim
<jdbc-connection-descriptor
jcd-alias="teste"
default-connection="true"
platform="oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@192.168.254.3:1521:bddes02"
username="test"
password="test">
<connection-pool
maxActive="3"
maxIdle="-1"
maxWait="2000"
whenExhaustedAction="0"
testOnBorrow="true"
testOnReturn="true"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="100000"
minEvictableIdleTimeMillis="1000000"
removeAbandoned="true"
removeAbandonedTimeout="1000"
validationQuery="SELECT SYSDATE FROM DUAL" />
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="1"/>
<attribute attribute-name="globalSequenceId"
attribute-value="false"/>
<attribute attribute-name="autoNaming" attribute-value="true"/>
<attribute attribute-name="globalSequenceStart"
attribute-value="00"/>
</sequence-manager>
</jdbc-connection-descriptor>
-----Mensagem original-----
De: Armin Waibel [mailto:[EMAIL PROTECTED]
Enviada em: s�bado, 28 de junho de 2003 17:57
Para: OJB Users List
Assunto: Re: Connection pool scalability problem
Hi,
seems your pool is exausted.
see
http://db.apache.org/ojb/repository.html
section connection-pool
connection-pool element in repository
attribute 'whenExhaustedAction':
0 - fail when pool is exhausted
1 - block when pool is exhausted
2 - grow when pool is exhausted
regards,
Armin
----- Original Message -----
From: "Philippe Collignon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 10:15 PM
Subject: Connection pool scalability problem
> Hi,
>
> Under high use, I get a connection pool exception, after 1 sec the
> connection are released. I use PB and close the broker in a finally
block.
>
> Did I miss something or is it a bug in the connection pool ?
>
> Philippe
>
> javax.servlet.ServletException: Could not borrow connection from
pool -
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
> [EMAIL PROTECTED]
> jcd-alias=test
> default-connection=true
> dbms=MySQL
> jdbc-level=2.0
> driver=com.mysql.jdbc.Driver
> protocol=jdbc
> sub-protocol=mysql
> db-alias=//localhost/test
> user=sa
> password=*****
> eager-release=false
> ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1,
> maxActive=20,
> maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10,
> testWhileIdle=false, minEvictableIdleTimeMillis=600000,
testOnReturn=false,
> logAbandoned=false, removeAbandonedTimeout=300,
> timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
> batchMode=false
> useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
> ignoreAutoCommitExceptions=false
>
>
>
[EMAIL PROTECTED]
f939
> [
> sequenceManagerClass=class
> org.apache.ojb.broker.util.sequence.SequenceManagerMySQLImpl
> Properties={}
> ]
>
> ...
> java.util.NoSuchElementException
> at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown
> Source)
> ...
>
> Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could
not
> borrow connection from pool -
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
