SQLServer 2000 异常

来源：互联网发布：云计算对个人的影响编辑：程序博客网时间：2024/05/22 02:11

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.

开始使用的驱动是

<bean id="***"        class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName">            <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>        </property>        <property name="url">            <value>jdbc:sqlserver://********;DatabaseName=*****;</value>        </property>        <property name="username">            <value>*****</value>        </property>        <property name="password">            <value>******</value>        </property></bean>

改为:

<bean id="***"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>net.sourceforge.jtds.jdbc.Driver</value></property><property name="url"><value>jdbc:jtds:sqlserver://***/**;</value></property><property name="username"><value>***</value></property><property name="password"><value>**</value></property></bean>

0 0