sqljdbc : JDBC driver sqljdbc.jar Vs sqljdbc4.jar
I have a query regarding the jars sqljdbc.jar and sqljdbc4.jar which are used to connect to MS SQL Server 2005 for the systems where the JDK version 1.5 & 1.6 respectively. Now I would like to know, how these jars interpret the column whose datatype is 'XML' in one of the DB table in MS SQL Server 2005, when trying to access from both the systems where the JDK versions are 1.5 & 1.6 using sqljdbc.jar & sqljdbc4.jar respectively?
Is there any difference in interpreting the XML data type using sqljdbc.jar and sqljdbc4.jar?
Thank you very much in advance,
Regards, Laaksha
Answer
From http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/8c1721c1-781f-4ad0-b656-a2494f3c3978: "These two class libraries are used to support different scenarios. The sqljdbc.jar class library provides support for JDBC 3.0 and the sqljdbc4.jar class library provides support for JDBC 4.0."