Microsoft SQL Server 2005 JDBC Driver v1.2 official release
The Microsoft SQL Server JDBC team is proud to announce the general availability of the v1.2 RTW release. The driver can be found at https://msdn.microsoft.com/data/jdbc. In this release we significantly reduced the driver's memory footprint usage especially when handling large clobs and blobs on multiple active connections. This resulted in performance and scalability improvements, through the use of "responseBuffering=adaptive" connection property. We also introduced SQL Server SSL encryption support.
Jimmy Wu
Microsoft SQL Server
Comments
Anonymous
October 12, 2007
PingBack from http://www.artofbam.com/wordpress/?p=8019Anonymous
October 17, 2007
Can I found release notes somewhere? thanks.Anonymous
October 18, 2007
Yes - where can I get the release notes? Also is there some performance benchmarking for SSL enabled connections. Thanks!!Anonymous
October 19, 2007
The comment has been removedAnonymous
October 23, 2007
JDBC driver behaves differently for the next query: IF (db_id('x') IS NULL) BEGIN CREATE DATABASE "x"; SELECT db_id('x') AS id; END ELSE SELECT NULL AS id; Ver 1.1 returns a ResultSet or NULL. Ver 1.2 throws an exception if database was created (obviously according to No. 45827 from release notes: The SQLServerStatement.executeQuery method now throws an SQLException if the specified argument, an SQL statement, returns a result other than a single ResultSet). It looks like general approach to executing a number of statements in one query changed: result of the first or last statement is returned. Which approach is here to stay - 1.1 or 1.2? Thanks, MichaelAnonymous
October 24, 2007
Looks like you introduced a severe bug in version 1.2: subclasses of Throwable (like SQLServerException) must implement Serializable. However, this is no longer the case for SQLServerException, as it has a StreamError field, which isn't Serializable anymore in 1.2 (it was in 1.1). Is this a known bug?Anonymous
October 24, 2007
Looks like you introduced a severe bug in version 1.2: subclasses of Throwable (like SQLServerException) must implement Serializable. However, this is no longer the case for SQLServerException, as it has a StreamError field, which isn't Serializable anymore in 1.2 (it was in 1.1). Is this a known bug?Anonymous
October 26, 2007
Hi, We are evaluating JDBC v1.2 and found out there is different result with getBytes Method (SQLServerResultSet) call. this is output when I tried two drivers: using JDBC v1.1 Timestamp from DB is: 2007-10-26 12:45:45.9 byte array is: 0 is -45 1 is -103 2 is 0 3 is 0 4 is -38 5 is 82 6 is -46 7 is 0 using JDBC v1.2 Timestamp from DB is: 2007-10-26 12:44:42.04 0 is 0 1 is 0 2 is -103 3 is -45 4 is 0 5 is -46 6 is 8 7 is 4 you can see first 4 elements values have been changed (with different order). can someone provide more information about this? Thanks. --TonyAnonymous
October 29, 2007
The comment has been removedAnonymous
October 29, 2007
The comment has been removedAnonymous
November 01, 2007
The comment has been removedAnonymous
November 02, 2007
we use SQL statement select getdate() from DB server to get DB server timestamps, then use getBytes() method for our persistence lay to do real work. I have a sample java program just to get a timestamp from a table and use getBytes() on SQLServerResultSet, you can see the result different: v1.2 result: 2007-10-22 10:04:32.623 0 is 0 1 is 0 2 is -103 3 is -49 4 is 0 5 is -90 6 is 10 7 is -5 v1.1 2007-10-22 10:04:32.623 0 is -49 1 is -103 2 is 0 3 is 0 4 is -5 5 is 10 6 is -90 7 is 0 first 4 elements order reverse which represents day and last 4 elements also reverse order which represents time.Anonymous
November 13, 2007
Hi Tony, Thank you for your patience. 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 v1.1. Basically, the byte order you observe in v1.1 disallows round tripping binary datetime values with the server. You should now be able to do this in v1.2. Hope this helps and thank you for your feedback, Yesim [MSFT]Anonymous
April 25, 2008
I see that in the 1.2 driver uniqueness constraint violations no longer cause an exception when the insert happens within a stored procedure. The violation is silently ignored, the insert is not done. Has anyone else seen this? -- Georg.Anonymous
June 12, 2008
Hi, I've found a strange performace with numeric(18,0) column (idPersona) in SQL Server 2000 when do a simple querie: select * from Persona where idPersona=?). IdPersona has a clustered index. The query ellapsed this time is it's used the next java type in preparedstatement (I use setObjet method):
- java.math.BigDecimal 148 ms
- java.util.Long 243
- java.util.Integer 4 ms. ¿Why is very faster use Integer Java Object instead BigDecimal, if JDBC SQL mapping is BigDecimal -> NUMERIC -> numeric?
Anonymous
June 18, 2008
The comment has been removedAnonymous
July 12, 2008
Whenever there is a upgrade or a new release or new version of any software it should have the backward compatibility. Here I am trying to connect MSSQL Server 2000 using MSSQL Server 2005 JDBC driver. Most of the functionalities are working (Hope so). But still there are some issues while trying access a stored procedure which intern talks to Oracle RDBMS thru Microsoft data transformation services, It throws some SQL exception say “This statement did not return any result sets. But the same code is working fine with MSSQL Server 2000 JDBC driver. This supposed to be fixed. -VinayAnonymous
October 12, 2008
I have an application run with SQL2000 originally, last month the database has been migrated to SQL2005, I've updated the jdbc driver to version 1.2 accordingly, but found the performance of the application is greatly downgrade, it take around 4 times as long as before for the same task. Anyone can guide me to fix such problem? Thanks in advance GrealeAnonymous
October 14, 2008
The comment has been removedAnonymous
October 14, 2008
The comment has been removedAnonymous
October 07, 2009
Hi we are using the Microsoft SQL Server 2005 JDBC in sap Application , and the legacy system has MS SQL 2000 JDBC driver Will these be compatible if we have diffeent versions of the Servers in the both ends. Please let me know if any one has solution for these. Thansk Praveen Will the Ms SQL 2005 is installedAnonymous
November 20, 2009
The getBytes() method is buggy. It throws an exception "com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to BINARY is unsupported." when I am trying to get a short variable and the getColumnTypeName() says its a "smallint" !! Please adviseAnonymous
April 29, 2014
I cannot find "Microsoft SQL Server 2005 JDBC Driver v1.2" in this link.