Hi,
Add the following line to your sybase-ds.xml:
<check-valid-connection-sql>select 1</check-valid-connection-sql>
If the sybase is down, all connections in the pool are invalid.
The pool doesn't check them before handing them out and you get
this Exception.
With the above property, the pool executes a "select 1" any time
a Connection is returned to the applications. This query causes an exception. After
that the conneciton is dropped and a new one
will be created.
Correct me if I'm wrong.
Greetings,
Dietmar
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837726#3837726
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3837726
-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
