Hi Robert, seems that we need some AI for OJB ;-) When the validation query fails the connection was declared corrupt/removed from pool and the ConnectionFactory try to get a new connection, invoke the validation query .....
Thus, you should take care that your validation query is vaild. Maybe we could use a counter to avoid endless loops when database is down or someone uses invaild queries ;-). Could this be a adequate solution? regards, Armin ----- Original Message ----- From: "Robert S. Sfeir" <[EMAIL PROTECTED]> To: "oJB List" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 12:36 AM Subject: nasty endless loop bug found in 0.9.9 > I added this following to the validate-query of a DB connection > <connection-pool maxActive="5" validationQuery="select count(userID) > from users"/> > > > and since the userid is not a column name, I got this: > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > Destroy object was called, try to close connection: > [EMAIL PROTECTED] > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] WARN: > Validation query for connection failed, discard connection. Message: > ERROR: Attribute "userid" not found > > > and it went on and on and on. > > nasty stuff. > > > --------------------------------------------------------------------- > 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]