com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not suppo
来源:互联网 发布:对外经贸金融专硕 知乎 编辑:程序博客网 时间:2024/06/07 05:13
问题描述
此问题一直搁置,源文件也不见了,今天发现就拿了上来....解决方案未亲测。放在这里做个记号。
解决方案
已经有人出现过了,so...http://www.skill-guru.com/blog/2010/04/05/jboss-4-server-configuration-for-sql-server-2008/
他的意思是驱动版本低了,改换就可以了,
JDK5 – use sqljdbc.jar
JDK6 – use sqljdbc4.jar
- com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server2000 or later.
- at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
- at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
- at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
- at java.sql.DriverManager.getConnection(DriverManager.java:582)
- at java.sql.DriverManager.getConnection(DriverManager.java:185)
- at com.zuxia.util.DBUtil.getConn(DBUtil.java:40)
- at com.zuxia.dao.GoodsTypeDao.getAllGoodType(GoodsTypeDao.java:25)
- at org.apache.jsp.index_jsp._jspService(index_jsp.java:186)
com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)at java.sql.DriverManager.getConnection(DriverManager.java:582)at java.sql.DriverManager.getConnection(DriverManager.java:185)at com.zuxia.util.DBUtil.getConn(DBUtil.java:40)at com.zuxia.dao.GoodsTypeDao.getAllGoodType(GoodsTypeDao.java:25)at org.apache.jsp.index_jsp._jspService(index_jsp.java:186)
此问题一直搁置,源文件也不见了,今天发现就拿了上来....解决方案未亲测。放在这里做个记号。
解决方案
已经有人出现过了,so...http://www.skill-guru.com/blog/2010/04/05/jboss-4-server-configuration-for-sql-server-2008/
- After spending some time , I found that this issue will normally occur when you are using a older verison of JDBC driver to connect to sql server2008. So make sure you are using sql server 2008 JDBC driver and you do not have sqlserver2005 JDBC drivers in the classpath or in server/default/lib folder.
- When you download the SQlserver 2008 JDBC driver from the Microsoft website, you will get two jar files: sqljdbc4.jar and sqljdbc.jar.
- For JDK5 – use sqljdbc.jar
- for JDK6 – use sqljdbc4.jar
- When you JDK1.5 and trying to load sqljdbc4.jar, you might get the below exception.So use sqljdbc.jar[2008]
- Exceptionjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
After spending some time , I found that this issue will normally occur when you are using a older verison of JDBC driver to connect to sql server 2008. So make sure you are using sql server 2008 JDBC driver and you do not have sqlserver 2005 JDBC drivers in the classpath or in server/default/lib folder.When you download the SQlserver 2008 JDBC driver from the Microsoft website, you will get two jar files: sqljdbc4.jar and sqljdbc.jar.For JDK5 – use sqljdbc.jarfor JDK6 – use sqljdbc4.jarWhen you JDK1.5 and trying to load sqljdbc4.jar, you might get the below exception.So use sqljdbc.jar[2008]Exceptionjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
他的意思是驱动版本低了,改换就可以了,
JDK5 – use sqljdbc.jar
JDK6 – use sqljdbc4.jar
- com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not suppo
- com.microsoft.sqlserver.jdbc.SQLServerException
- com.microsoft.sqlserver.jdbc.SQLServerException: socket closed
- com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost/SQLEXPR
- SQL Server 2008连接com.microsoft.sqlserver.jdbc.SQLServerException: 到主机
- java sql server 存储过程 com.microsoft.sqlserver.jdbc.SQLServerException: 该语句没有返回结果集。
- 【sql server】解决 com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
- sql server 2008 com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机
- com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ‘xxx' 无效
- JSP com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
- com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ‘xxx' 无效
- com.microsoft.sqlserver.jdbc.SQLServerException:对象名 ‘xx’ 无效
- com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭
- com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭
- java com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
- com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭
- com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
- jsp com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭
- chapter 2: 字符和字符串处理
- struts2 出问题 2.25
- jsp 获取项目路径,java获取项目路经
- (转)SCJP 认证考试指南
- oracle性能调优公式
- com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not suppo
- Android 仿微信之二--主页面实现篇
- 对面向服务架构的一些体会
- 判断两个链表是否相交
- Android多媒体学习:调用android自带的播放器播放Audio
- Android 仿微信之界面导航篇
- 用 WEKA 进行数据挖掘 (From IBM)
- jqgrid不能显示数据
- Android ListView从网络获取图片及文字显示