my prob is that java.sql.Connection.isClosed() method is not working with MS sql server???
i am using com.microsoft.jdbc.sqlserver.SQLServerDriver.
I also saw the driver's code, wht i found tht the method always returns true.
so wht can be done???can neone suggest.
also i can use jTDS driver which works fine. but changing the driver is not feasible in our application as it will require extensive testing.
Also a possible solution is to use temp query and execute the query.but the prob with this solution is tht if else block has to be used for different databases as there isnt ne common query which can run on all the databases.
for eg. select 1 from dual will work in oracle but not in other databses.
thanking in advance