Hi,
I encountered a problem with OJB 0.9.8 during modifying the parameters for
the connection pooling within my application.
I put the following parameters in the repository.xml file for the
connection-descriptor:
<connection-pool
minEvictableIdleTimeMillis="120000"
timeBetweenEvictionRunsMillis="120000"
whenExhaustedAction="0"
maxIdle="-1"
maxActive="-1"
maxWait="5000"
numTestsPerEvictionRun="20"
testWhileIdle="false"
testOnReturn="false"
testOnBorrow="true"
/>
And I also put the same parameters to the ojb.properties file. I got the
following output:
----------------------------------------------------------------------------
-------------
run:
[java] SollstellungData: bkz=0 rechBetrag=0 F�lligkeit=Fri Jan 17
10:26:22
CET 2003hkz=null hhj=null aostNr=null aostErw=null kapitel=null titel=null
zusat
z=null budgetNr=null e1=null e2=null e3=null[]
[java] OOPs
[java] [DEFAULT] ERROR: > 0. Value was -1
[java] [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl]
INFO:
Create PersistenceBroker instance pool, pool configuration was
{whenExhaustedAc
tion=0, maxIdle=-1, maxActive=15, maxWait=5000, numTestsPerEvictionRun=10,
testW
hileIdle=false, testOnReturn=false, timeBetweenEvictionRunsMillis=120000,
minEvi
ctableIdleIimeMillis=600000, testOnBorrow=false}
[java] [org.apache.ojb.broker.util.sequence.SequenceManagerFactory]
INFO: U
se sequence manager class: class
org.apache.ojb.broker.util.sequence.SequenceMan
agerHiLoImpl
[java] [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl]
INFO
: Create connection pool for JdbcDescriptorKey -1541372445
[java] [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl]
INFO
: Create new connection pool for
org.apache.ojb.broker.metadata.JdbcConnectionDe
scriptor,
[java] used descriptor: JdbcConnectionDescriptor
[java] DBMS:MsSQLServer
[java] DRIVER: com.microsoft.jdbc.sqlserver.SQLServerDriver
[java] PROTOCOL: jdbc
[java] SUBPROTOCOL: microsoft:sqlserver
[java] DBALIAS: //b3b357n3:1433;DatabaseName=JMBS;SelectMethod=cursor;
[java] USERNAME: sa
[java] PASSWORD: sa
[java] EAGER RELEASE: false
[java] pool configuration was: {whenExhaustedAction=0, maxIdle=-1,
maxActiv
e=21, maxWait=5000, numTestsPerEvictionRun=20, testWhileIdle=false,
testOnReturn
=false, timeBetweenEvictionRunsMillis=120000,
minEvictableIdleIimeMillis=120000,
testOnBorrow=true}
[java] hkz= hhj= aostNr= aostErw= kapitel= titel= zusatz= budgetNr= e1=
e2=
e3=
----------------------------------------------------------------------------
---------------------
The debug outputs for the connection pooling from
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] are different
from [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl]. The
parameters from the ojb.properties file are not taken properly. And in my
case the application is only working fine with the parameters from the
connection-pool element within the repository.xml file.
Has someone else already encountered the same problem?
Regards,
Oliver Paulus
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
