ASE Database forum - Statuscheck of a direct

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Statuscheck of a direct_connection to Oracle

Alexander Gudenus

2005-04-13, 3:24 am

Hi,

My problem is that I would like to check the connection
status of a direct_connect connection to an Oracel DB, which
is sometimes offline, in SQL. Unfortunately I couldnt find a
function or sp which does that :(

I would appreciate help

thx

alexander

ps: another solution would be if it would be possible to
catch a raiserror in sql without throwing an exception to
the calling java application. I tried @@error, which I can
catch, but unfortunately the exception is shown in the
application anyway. I suppose the problem might be the jdbc
driver

Sponsored Links