急：请教jsp用jdbcodbc桥连接sql server数据库不能使用int i=getInt(1)的问题

显示全部楼层 · 2004-8-4 13:33:00

请教jsp用jdbcodbc桥连接sql server数据库不能使用int i=getInt(1)的问题。单独打印getInt(1)可以使用，就是不能赋值给变量；也不能使用String t＝getString(1)。我主要实现random = 1+(long)( rs.getInt(2) * Math.random());请问是jdbcodbc的驱动的问题吗？如何解决？谢谢。
附录：报错信息
Error: 500
Location: /main1.jsp
Internal Servlet Error:
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:384)

at _0002fmain_00031_0002ejspmain1_jsp_42._jspService(_0002fmain_00031_0002ejspmain1_jsp_42.java:138)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:172)

at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:259)

at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:367)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:390)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:523)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:146)

at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:334)

at java.lang.Thread.run(Unknown Source)
Root cause:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引

at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)

at _0002fmain_00031_0002ejspmain1_jsp_42._jspService(_0002fmain_00031_0002ejspmain1_jsp_42.java:122)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:172)

at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:259)

at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:367)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:390)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:523)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:146)

at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:334)

at java.lang.Thread.run(Unknown Source