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

[Martijn Verburg]

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  :) 

Cheers,
Martijn
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/562199#562199]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

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