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

karianna Sep 16, 2010 10:33 AM

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

1. Re: SELECT @@VERSION for Sybase Connections isn't always what you want

jaikiran Sep 20, 2010 1:27 AM (in response to karianna)

Hi Martijn,

I updated the wiki http://community.jboss.org/wiki/WhatHappensToJBossIfIRestartTheDatabase to add a section pointing to this thread.
Actions
2. Re: SELECT @@VERSION for Sybase Connections isn't always what you want

karianna Sep 20, 2010 2:49 AM (in response to jaikiran)

Thanks Jaikiran, should've thought of doing that myself actually!
Actions

Go to original post