JDBC Connection returns wrong status

From: "evgchech" <evgchech@xxxxxxxxx>
Date: 15 Dec 2006 06:07:57 -0800

Hello Everybody

I am using jdbc:odbc driver to connect to MSSQL 2000
I acquire the connection object using DriverManager.getConnection()
I observe some strange behavior of the connection object.
If the database was brought down , the connection keeps returning false
on
m_conConnection.isClosed() query same goes for
m_conConnection.getMetaData().
I have clanged the driver to the Microsoft native one
jdbc:microsoft:sqlserver, and still the same behavior.
How do i know whether the connection is active or not??

Please help

.

Follow-Ups:
- Re: JDBC Connection returns wrong status
  - From: joeNOSPAM@xxxxxxx

Prev by Date: Re: semi-colon weirdness when converting from mysql to Oracle
Next by Date: Re: JDBC Connection returns wrong status
Previous by thread: semi-colon weirdness when converting from mysql to Oracle
Next by thread: Re: JDBC Connection returns wrong status
Index(es):
- Date
- Thread

Relevant Pages

Re: Autocommit, Implicit Transactions, and Connection Pools
... My question is what is the difference between setting autocommit on using the method on the connection object, and running a command on the server to turn on implicit connections. ... That driver flag may or may not be important though. ... SQL instead of the setAutoCommitcall. ...
(microsoft.public.sqlserver.jdbcdriver)
Re: Autocommit, Implicit Transactions, and Connection Pools
... My question is what is the difference between setting autocommit on using the method on the connection object, and running a command on the server to turn on implicit connections. ... The driver may keep a flag denoting it's autocommit state, ... SQL instead of the setAutoCommitcall. ...
(microsoft.public.sqlserver.jdbcdriver)