Chinaunix

标题: JSP连接oracle查询问题,请高人指示 [打印本页]

作者: xhwwxnl 时间: 2007-07-01 20:20
标题: JSP连接oracle查询问题,请高人指示
本人初学JSP,环境win xp sp2,tomcat 5.5.23, jdk 1.5.0_12,eclipse 3.1.2,
oracle 816 client, jdbc-odbc 桥连到另外的oracle 7[on digital unix v4.0f],
主要做两个查询,开始的SQL语句内容较多,以为有误,实际在SQLPLUS下执行也正确,后为解决问题改为简单的;
部分代码如下:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"

;conn=DriverManager.getConnection("jdbc

dbc:zz","uu","pp"

;sqla="select count(*) from aa";sqlb="select count(*) from bb";Statement stmta=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); //加和不加参数都试过,都不成功Statement stmtb=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);ResultSet rsa=stmta.executeQuery(sqla);ResultSet rsb=stmtb.executeQuery(sqlb);rsa.absolute(1);int a=rsa.getInt(1);out.print(a);rsb.absolute(1);int a=rsa.getInt(1);out.print(b);rsa.close();stmta.close();rsb.close();stmtb.close();

报错如下:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0be3ea86, pid=1796, tid=2180
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_12-b04 mixed mode)
# Problematic frame:
# C [SQORA32.DLL+0x2ea86]
#
# An error report file with more information is saved as hs_err_pid1796.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
连接数据库肯定没问题,因为单独从库中查询表内容数据,能显示,
jdk 从1.4到1.5,tomcat从5.0.28到5.5.23,全试过,一样的错.
看报错原因与oracle有关,但连接本机的oracle816数据库时能执行两个查询,
是否与连接oracle7的版本低有关,若是此原因,用何种方法解决?
请高人指点......请详细一些[过分了.......!!!!!!]
十分感谢......

作者: lixiaocheng0451 时间: 2007-07-02 11:59
为什么要用桥连接呢？

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)