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
>
>
>
> 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]