Hi Oliver, ----- Original Message ----- From: "Paulus Oliver" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 7:12 AM Subject: AW: Parameters for connection-pooling
Hi Armin, sorry for asking that question. I mixed up the two types of pools because of the same properties. But nevertheless I encounterd a problem with the minEvictableIdleTimeMillis-property for the persistence broker pool in the ojb.properties file in OJB 0.9.8. Because of a typing error in the PoolConfiguration.java file, ojb is always taking the default value for that property. But I checked the current version in CVS and the problem has been already removed there. #### Fine ;-) And I have still another question. Is it possible to set the maxActive-property for the persistence broker pool to a value lesser than 0 as it is mentioned in the description. Because in that case I always get an error message which demands to put in a value greater than 0. Thank you for your patience. #### Think this should be possible with CVS head (next release). A workaround for 0.9.8 is to set whenExhaustedAction=2, then the pool grows automatic when exhausted. Regards Oliver Paulus -----Urspr�ngliche Nachricht----- Von: Armin Waibel [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 17. Januar 2003 16:38 An: OJB Users List Betreff: Re: Parameters for connection-pooling I checked both pool configurations, all seems to work as designed (CVS, thus I think 0.98 too). regards, Armin ----- Original Message ----- From: "Armin Waibel" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 3:47 PM Subject: Re: Parameters for connection-pooling > Hi Oliver, > > there are to different pools in OJB: > - a PersistenceBroker pool, all properties could > be set in OJB.properties (version 0.98) > - a connection pool, max active connection could set in > OJB.properties or in connection-pool tag in repository > file > > In CVS we made some improvements handling this > stuff, also we add a test case to check all properties > in connection-pool. I will check the property setting > for the PB pool too - add this on my todo list ;-) > > HTH, > Armin > > ----- Original Message ----- > From: "Paulus Oliver" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 17, 2003 10:54 AM > Subject: Parameters for connection-pooling > > > 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: > file://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]> > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
