HTTP状态500-此驱动程序不支持Java Runtime Environment(JRE)版本1.7 [英] HTTP Status 500 - Java Runtime Environment (JRE) version 1.7 is not supported by this driver

问题描述

我正在尝试从servlet文件访问MS SQL Server 2005.我正在使用JDBC 4.0驱动程序. 我已经将JAR文件sqljdbc.jar和sqljdbc4.jar文件添加到了Tomcat /lib文件夹中.

I am trying to access MS SQL server 2005 from a servlet file. I am using JDBC 4.0 driver. I have already added the JAR files sqljdbc.jar and sqljdbc4.jar files to my Tomcat /lib folder.

但是在运行代码时出现错误

But while running code I am getting an error

HTTP状态500-该驱动程序不支持Java运行时环境(JRE)1.7版.使用sqljdbc4.jar类库，该库提供对JDBC 4.0的支持.

HTTP Status 500 - Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

这是怎么引起的，我该如何解决?

How is this caused and how can I solve it?

我的代码是:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = conn =   DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=school;user=sa;password=123");
PrintWriter pwOut = res.getWriter();
pwOut.println("Connected");
Statement st = conn.createStatement();
String searchCriteria = req.getParameter("txtSearch");
ResultSet rs = st.executeQuery("select * from student");
res.setContentType("text/html");

推荐答案

错误消息非常清楚. Tomcat使用了错误的驱动程序.

The error message is pretty clear. Tomcat is using the wrong driver.

您声明已将sqljdbc.jar 和和sqljdbc4.jar复制到Tomcat lib文件夹中.这很可能是您遇到问题的原因.

You state that you copied sqljdbc.jar and sqljdbc4.jar into the Tomcat lib folder. That is most probably the reason for your problem.

您仅只需要sqljdbc4.jar，否则Tomcat会选择错误的.

You only need sqljdbc4.jar otherwise Tomcat picks up the wrong one.

尝试从Tomcat lib文件夹中删除sqljdbc.jar

Try to delete sqljdbc.jar from the Tomcat lib folder

这篇关于HTTP状态500-此驱动程序不支持Java Runtime Environment(JRE)版本1.7的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！