JSP中很奇怪的一个查库错误,请帮忙!(非常之急)
peppi 2003-01-06 06:39:21 我在JSP中有一段:
<%
String s = null;
String sql = "select * from league where (Leagueid = 0)";
ResultSet rs = db.getResultSet(sql); //引用Bean内一个查询方法,此句报错
out.println("rs: " + rs);
%>
页面报错:
java.lang.NullPointerException
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.setupTempFiles(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.chainInServiceImplResultSets(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getNextResultSet(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at gatcherdata.DatabaseBean.executeQuery(DatabaseBean.java:66)
at gatcherdata.DatabaseBean.getResultSet(DatabaseBean.java:141)
根据我的一路追踪,最后发现问题在这:
try
{
System.out.println("ccccccccccccccccc");
stmt = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
System.out.println("ddddddddddddddddd");
System.out.println("sql: " + sql); //这以上都正常输出,下面那句就不
//输出,但不抛异常.最奇怪的是,我
//利用这个输出的sql在JB中测试,在
//SQL Server 2000中测试,都能正确
//数据结果,就JSP中不行
rs = stmt.executeQuery(sql); //到此执行停止,但不抛异常
System.out.println("rs: " + rs);
}
catch (SQLException e)
{
System.out.println("Error in DatabaeBean.execuQuery(): 查询数据发生错误: " + e.getMessage());
throw new SQLException();
}
另:我在JSP内用try输出e.getMessage(),它输出的是"null",各位,这错怎么出现的?