Prev: Need help with hint syntax in SQL Server 2000
Next: Need to locate jobs running past their next scheduled run time SQL 2005
From: aj on 11 Dec 2008 12:48
MS SQL Server 2005 9.0.3054 64-bit

Does anyone have experience using the MS SQLS Server 1.2 JDBC Driver?

Since upgrading from the 1.1 driver, we have seen odd stuff, for
example:
---
Dec 10, 2008 6:02:57 AM com.microsoft.sqlserver.jdbc.TDSChannel
enableSSL
WARNING: TDSChannel ( ConnectionID:2374
TransactionID:0x0000000000000000) SSL handshake failed: Connection reset
Dec 10, 2008 6:02:57 AM com.microsoft.sqlserver.jdbc.SQLServerException:
The driver could not establish a secur e connection to SQL Server by
using Secure Sockets Layer (SSL) encryption. Error: Connection reset.

and

com.microsoft.sqlserver.jdbc.SQLServerException: The statement must be
executed before any results can be obtained.

and

WARNING: Processing trigger event:
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is
closed.
---
We are not using SSL ala JDBC in any form, and no code has changed
where these exceptions occur (and did not occur previously). This is
just straightforward java and jdbc..

Does anyone have any ideas, or opinions of/experience with the 1.2
jdbc driver? Its not CTP anymore, so it should be reliable, yes?

TIA

aj

 | 
Pages: 1
Prev: Need help with hint syntax in SQL Server 2000
Next: Need to locate jobs running past their next scheduled run time SQL 2005