RE: Pooled Connections Question - V 3.2 RC-2 -= Java/DB2

[Jim Caserta <sm...@yahoo.com>]

When you say the "maximum memory pool", you are
refering to the "pool.maxActive" number.. correct?

And leave the "maxidle" where it is? I'm a little
fuzzy on how the maxidle affects how many connections
are available in the pool..

Thanks! 

--- Greg Monroe <Gr...@DukeCE.com> wrote:

> I seem to remember getting this error when load
> testing an application.  I think the solution was
> to bump up the JVM initial memory pool and 
> maximum memory pool (good thing to do by default).
> 
> But then again, my neural net sometimes makes the 
> wrong connections as I get older.
> 
> > -----Original Message-----
> > From: Jim Caserta [mailto:smoothie_jc@yahoo.com] 
> > Sent: Tuesday, January 31, 2006 8:25 AM
> > To: Apache Torque Users List
> > Subject: Pooled Connections Question - V 3.2 RC-2
> -= Java/DB2
> > 
> > 
> > Hi all,
> > 
> > Occasionally we receive the following connection
> error
> > message: Torque Exception Message: .  Error
> Message
> > is:  org.apache.commons.dbcp.SQLNestedException:
> Could
> > not retrieve connection info from pool
> >  
> > Occasionally we also find that a connection does
> not
> > close after a commit. Our code is basic..
> > 
> > con =
> Torque.getConnection(db2.torque.environment)); 
> > //do  stuff
> > con.commit();
> > }finally {  
> > if (con != null) { //this is prob never null
> >     if (!con.isClosed()) {
> >         // send a message the con is NOT closed
> > 	Torque.closeConnection(con);  }
> > 
> > Here is a portion of the prop file: 
> >
>
torque.dsfactory.eMarine.factory=org.apache.torque.dsfactory.S
> > haredPoolDataSourceFactory
> > torque.dsfactory.eMarine.connection.driver = 
> > COM.ibm.db2.jdbc.app.DB2Driver
> > 
> > torque.defaults.pool.initialSize = 1 
> > torque.defaults.pool.maxIdle = 40
> torque.defaults.pool.maxActive = 60
> > 
> > torque.defaults.pool.maxWait = 50000 
> >
> torque.defaults.pool.timeBetweenEvictionRunsMillis=
> > 200000
> > torque.defaults.pool.minEvictableIdleTimeMillis =
> > 2000000
> > torque.defaults.connection.driver = 
> > COM.ibm.db2.jdbc.app.DB2Driver
> torque.idbroker.clever.quantity=true
> > torque.manager.useCache = true
> torque.database.eMarine.adapter=db2app
> > torque.defaults.connection.driver = 
> > COM.ibm.db2.jdbc.app.DB2Driver
> torque.defaults.connection.url 
> > = jdbc:db2:DB2B
> > 
> > 
> > Does anything jump out that might be set wrong?
> > 
> > Thank you for any help!
> > Jim
> > 
> > 
> > 
> > 			 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> > 
> > 
> 
> Duke CE Privacy Statement
> Please be advised that this e-mail and any files
> transmitted with it are confidential communication
> or may otherwise be privileged or confidential and
> are intended solely for the individual or entity to
> whom they are addressed.  If you are not the
> intended recipient you may not rely on the contents
> of this email or any attachments, and we ask that
> you  please not read, copy or retransmit this
> communication, but reply to the sender and destroy
> the email, its contents, and all copies thereof
> immediately.  Any unauthorized dissemination,
> distribution or copying of this communication is
> strictly prohibited.
> 
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org