Make sanity check works with Oracle - Real's PowerBuilder Howto

Make sanity check works with OracleTag(s): Jaguar/EAServer

Before giving a connection from a connection cache, Jaguar can make a sanity check to determine a connection is still good. By default, Jaguar send SELECT 1 and then, from the SQLState value, check if the connection is alive or not. The statement used is not a valid one for Oracle. So each time, a reconnect will occur (this is not good for a cache!).

Jaguar provides a way to specify the statement used to check if a connection is still alive. Follow this simple procedure :

Define an Oracle cache named MyORCLCache
Create a file %JAGUAR%\Repository\ConnCache\MyORCLCache.props
Add the line com.sybase.jaguar.conncache.check=select 1 from dual
Make sure that sanity check is checked on the connection definition tab page.
Restart the server