- 論壇徽章:
- 0
|
本人初學(xué)JSP,環(huán)境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],
主要做兩個(gè)查詢,開(kāi)始的SQL語(yǔ)句內(nèi)容較多,以為有誤,實(shí)際在SQLPLUS下執(zhí)行也正確,后為解決問(wèn)題改為簡(jiǎn)單的;
部分代碼如下:
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); //加和不加參數(shù)都試過(guò),都不成功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();
報(bào)錯(cuò)如下:
#
# 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
#
連接數(shù)據(jù)庫(kù)肯定沒(méi)問(wèn)題,因?yàn)閱为?dú)從庫(kù)中查詢表內(nèi)容數(shù)據(jù),能顯示,
jdk 從1.4到1.5,tomcat從5.0.28到5.5.23,全試過(guò),一樣的錯(cuò).
看報(bào)錯(cuò)原因與oracle有關(guān),但連接本機(jī)的oracle816數(shù)據(jù)庫(kù)時(shí)能執(zhí)行兩個(gè)查詢,
是否與連接oracle7的版本低有關(guān),若是此原因,用何種方法解決?
請(qǐng)高人指點(diǎn)......請(qǐng)?jiān)敿?xì)一些[過(guò)分了.......!!!!!!]
十分感謝...... |
|