Sybase connection checking problem

[Simon Botting]

I am trying to build in resilience to a db app running on es 3.5.1 on solaris using sybase adaptive server 11.5 so that if any connections go down the app reconnects to the db

I do this by checking that the dbpool object is connected (i.e. myPool.connected())
and then check that the connection object is also connected (i.e. myConnection.connected())

I manually knock off the connections from the db
subsequently from viewing debug statements in the trace window checking the above, both dbpool object and connection objects appear to be connected fine?????? (as far as livewire is concerned), then when I run a stored procedure I get the following read out in the trace;

Database connection 'xConnect' : StoredProc function: SQL statement = "get_request"
Error in database services:
[VENDORLIB] Vendor Library Error: ct_cancel(): network packet layer: internal net library error: Net-Library    operation terminated due to disconnect ZZZZZ

Error in database services:
Vendor error 1: 84083974

Error in database services:
Vendor error 2: 5

Error in database services:
[VENDORLIB] Vendor Library Error: ct_command(): user api layer: external error: This routine cannot be called because the command structure is in an
undefined state. ZZZZZ

Error in database services:
Vendor error 1: 16843175

Error in database services:
Vendor error 2: 1

the app then hangs.
As far as I am aware I am running the correct client libraries etc

If anyone has any suggestions / help or has experienced this before please could you help me

many thanks

[Willy Mena]

Simon...

I'm working on some new code for this.  I'll send you an advanced copy to look.

Willy Mena

[Seth Osher]

Simon,

I issue a query that I know should succeed, such as: "select 1 as foo".
Then I check the error code. If its anything other than 0, I've lost the
connection.

- Seth Osher
os...@jemtech.com
Simon Botting wrote in message <3588E57...@bzw.com>...