When the SQL Server query optimizer then tries to figure out the best execution plan, part of that execution plan may be converting the type sent across to the field type. I didn’t read it. October 14, at 1: October 26, at 4: June 12, at 8:

Uploader: Shaktirg
Date Added: 26 October 2012
File Size: 13.60 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 97661
Price: Free* [*Free Regsitration Required]

Depending on the conversion, this can result in a more or less efficient query. IdPersona has a clustered index.

Microsoft JDBC Driver for SQL Server Support Matrix | Microsoft Docs

Less efficient queries take longer to run. I have no idea what Windows was up to, maybe some new security feature?

It was quiet nice when MS took long to release new versions jddbc its flagship database because it meant I didn’t have mssql 2005 jdbc learn anything new for years. We are evaluating JDBC v1. We are currently investigating this.

Thank-you for your feedback. We will post an update once we have identified the issue. In revisiting the JDBC 3. Rohit Haval 2 Post Your Mssql 2005 jdbc Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of mssql 2005 jdbcprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


I tried removing the read only attribute on the folder but no luck. October 24, at Sign up using Facebook.

October 19, at Don’t foget to allow the windows firewall to let external request to the port through. Mssql 2005 jdbc server runtime is present in project’s build path. Looks like you introduced a severe bug in version 1.

October 20005, at 1: I have a sample java program just to get a timestamp from a table. Sign up or log in Sign up using Google.

Microsoft SQL Server 2005 JDBC Driver v1.2 official release

October 18, at When the SQL Server query optimizer then mssql 2005 jdbc to figure out the best execution plan, part of that execution plan may be converting the type sent across to the field type.

We have investigated the problem you reported and confirmed that it is a not a regression but rather the intended consequence of fixing a defect in mssql 2005 jdbc. It later emerged that MS SQL, sinceis using dynamic ports on its instances so maybe they would work it I knew this before hand.


Since you are using three different Java types, you are likely going to get three different SQL types sent across the wire. June 18, at 9: I would suggest to review all your classpath config. November 1, at 7: You can pick up the dynamic port it is using with netstat or from the “IP Addesses” tab. October 17, at 4: I had the old drivers for from MS and the open mssql 2005 jdbc ones but couldn’t get them to work. I then setup a connection pool mssql 2005 jdbc the following properties: I then started looking around for JDBC drivers.

Basically, the byte order you observe in v1. You should now be able to do this in v1.