[jboss-user] [Datasource Configuration] - SELECT @@VERSION for Sybase Connections isn't always what you want

Martijn Verburg do-not-reply at jboss.com
Thu Sep 16 10:33:48 EDT 2010

Martijn Verburg [http://community.jboss.org/people/karianna] created the discussion

"SELECT @@VERSION for Sybase Connections isn't always what you want"

To view the discussion, visit: http://community.jboss.org/message/562199#562199

Hi all,

Quick note (not sure if Jboss docs should be update for this or not).  After some extensive testing we've discovered that when a Sybase server gets bounced that database connection pools can grab 'stale' connections if the connection SQL you use is the SELECT @@VERSION (as shown in the jboss docs as a default).  This is due to the master DB being up but the actual DB you want to hit not being up.

Something like the the detection of the sysobjects table in your DB is a better way to go.  We now have a happily recovering Jboss  :) 


Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100916/ca8b9db6/attachment.html 

More information about the jboss-user mailing list