在tomcat里提示如下错误:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.jav
5702)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:35 at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:41 at org.apache.jsp.bookshop.index_jsp._jspService(index_jsp.java:132)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapp
.java:311)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java
01)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap
icationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio
ilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe
alve.java:257)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa
eContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:567)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standa
ContextValve.java:245)
.........................
.........................
.........................
.........................
.........................
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.jav
5702)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:35 at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:41 at org.apache.jsp.bookshop.index_jsp._jspService(index_jsp.java:132)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapp
.java:311)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java
01)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap
icationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio
ilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe
alve.java:257)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa
eContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:567)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standa
ContextValve.java:245)
.........................
.........................
.........................
.........................
.........................
解决方案 »
- 一条sql语句在mysql中执行报错
- window.location.href和window.location.url的区别
- ssh中级联的表中记录怎么也删除不了
- 系统提供webservice时,如何获取调用方的真实IP地址
- 如何实现csdn帖子里面点击收藏的功能
- 如果sql语句中有: compute sum(XXX),sum(YYY) by id 汇总统计的语法,jdbc中怎样读取出来?(急!!)
- JSP弹出框
- request.setAttribute()是做什么用的?
- 这个servlet如何做?
- jsp可以中文,但是servlet就不行?!
- 为什么con=DriverManager.getConnection("jdbc:odbc:shop","","");连接数据库会出现异常?
- 用jspSmartUpload下载中文名称的文件.....
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=book","sa","sa");
一点问题都没有,可用这种JDBC-ODBC桥连接数据库设数据源就出现如上错误
有经验的同志们快帮帮我啊,谢谢了