64位的JDK和JDBC

Question

64位系统 用MyEclipse 9   JDK是1.6.0_27  数据库是sql  但是连接数据的时候 一直说驱动不符合 下了最新版本的JDBC也没效果

Answer 1

严重: 此驱动程序不支持 Java Runtime Environment (JRE) 1.6 版。请使用支持 JDBC 4.0 的 sqljdbc4.jar 类库。
java.lang.UnsupportedOperationException: 此驱动程序不支持 Java Runtime Environment (JRE) 1.6 版。请使用支持 JDBC 4.0 的 sqljdbc4.jar 类库。
at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:840)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at sqlserverdal.BaseDAO.getCon(BaseDAO.java:25)
at sqlserverdal.BaseDAO.runUpdate(BaseDAO.java:110)
at org.apache.jsp.doreg_jsp._jspService(doreg_jsp.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:662)
java.lang.NullPointerException
at sqlserverdal.BaseDAO.runUpdate(BaseDAO.java:111)
at org.apache.jsp.doreg_jsp._jspService(doreg_jsp.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:662)
java.lang.NullPointerException
at sqlserverdal.BaseDAO.runUpdate(BaseDAO.java:124)
at org.apache.jsp.doreg_jsp._jspService(doreg_jsp.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:662)

Answer 2

用的是sql 2008    jdbc下载了3.0 也参照把jar加载和放在tomcat里面  也没有用  话说是不是jdk1.6.0_27和jdbc也不兼容(29也不兼容什么的)

Answer 3

64的要安装六十四位的JDK吧，否则不支持的

Answer 4

提示是sqlserver驱动版本的问题

Answer 5

绝对是64位的  jdk1.6.0_27   在http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u27-download-440405.html 下载的

Answer 6

驱动程序不支持 Java Runtime Environment (JRE) 1.6 版。请使用支持 JDBC 4.0 的 sqljdbc4.jar 
是驱动程序不符合吧，楼主用什么数据库啊？！
oracle的话用classes12.jar或ojdbc14.jar
目录如：D:\oracle\product\10.2.0\db_1\jdbc\lib

Answer 7

 有把    我就知道下载JDK的时候 可以选64 32  安装之后 它自己就给安上JAR了  应该也是64位

Answer 8

不是说的很明白了 你的jdbc包不对...
这关64位什么事情
自己看sqljdbc包是什么版本的

Answer 9

如果想知道64位有没影响 随便搞个程序跑跑 没问题肯定不关64位的问题
 这里更多的要关注类库更新问题 
 但是你如果下载新版的jdk 也会默认安装jre 这个类库应该不会出多大问题

Answer 10

下载的是Microsoft SQL Server JDBC Driver 3.0   使用里面的sqljdbc4.jar 文件 无误

Answer 11

jdbc3.0的包是这个名字sqljdbc_3.0.1301.101_chs.exe
解压出来目录下有2个文件
一个是sqljdbc.jar
一个是sqljdbc4.jar你自己看下引用路径,是不是重复引用了

Answer 12

我就引用了一个   sqljdbc4.jar    

Answer 13

http://msdn.microsoft.com/zh-cn/library/ms378422.aspx
这个是ms的说明怀疑你引用路径上多半是有另外的包
tomcat?看看公共库里是不是引用了

Answer 14

sqljdbc4.jar 塞到tomcat里面了       tomcat版本 6.0.33