Spring和SQLServer2005不得不说的那点事儿

今天要从SQLServerl中取些数据，不曾想有段时间没有操纵SQLServer了，竟然被SQLServer戏耍了一回，

java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sqlserver007 at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:283) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:271) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:255) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:236)

 org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not load JDBC driver class [com.microsoft.jdbc.sqlserver.SQLServerDriver]; nested exception is java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not load JDBC driver class [com.microsoft.jdbc.sqlserver.SQLServerDriver]; nested exception is java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

 

原因如下：

1、SQLServerl2000和SQLServerl2005的JDBC驱动居然不能通用-_-!

 

2、SQLServerl2000和SQLServerl2005的驱动Class名居然也不一样！！

2000：  <property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>

2005：  <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>

 

3、SQLServerl2000和SQLServerl2005的URL的写法居然还不一样！！！

2000：  <property name="url" value="jdbc:microsoft:sqlserver://......."/>

2005：  <property name="url" value="jdbc:sqlserver://......."/>