search

awferreira / c5-db-migration

Automatically exported from code.google.com/p/c5-db-migration
0 stars 0 forks source link

DatabaseUtils issue with MS SQL Server driver #3

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The MS SQL Server driver that DatabaseUtils is using is outdated. The
driver that it resolves jdbc url to is
'com.microsoft.jdbc.sqlserver.SQLServerDriver' which is for MS SQL Server 2000.

Instead is should match ':sqlserver:' to
'com.microsoft.sqlserver.jdbc.SQLServerDriver' which is for MS SQL Server
2005 and ':microsoft:sqlserver:' to
'com.microsoft.jdbc.sqlserver.SQLServerDriver'.

There is a blog entry from the Microsoft JDBC Driver Team which describes
the difference in drivers and jdbc urls for MS SQL Server here:
http://blogs.msdn.com/jdbcteam/archive/2007/06/15/java-lang-classnotfoundexcepti
on-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx

This was tested on the latest 0.9.2-SNAPSHOT release.

Original issue reported on code.google.com by llin...@gmail.com on 9 Sep 2008 at 8:29

GoogleCodeExporter commented 8 years ago

Original comment by christia...@gmail.com on 9 Sep 2008 at 8:44

GoogleCodeExporter commented 8 years ago 
Fixed in the latest snapshot (-3).

Original comment by christia...@gmail.com on 9 Sep 2008 at 8:50