sharath_kulal
asked on
updating blob(long raw) thru Oracle 8.1.7(OCI Driver) crashes server.
We are using Oracle 8.1.7 and OCI Driver for Java.
when we're trying to update a bunch of records containing long raw columns thru prepared statement we get this error and the server gets crashed. what could be the problem. the stack trace is given below.
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x60236A81
Function=vsnupr+0x3331
Library=E:\oracle\ora81\bi n\oracommo n8.dll
Current Java thread:
at oracle.jdbc.oci8.OCIDBAcce ss.do_exec ute(Native Method)
at oracle.jdbc.oci8.OCIDBAcce ss.execute Fetch(OCID BAccess.ja va:1208)
- locked <0332E868> (a oracle.jdbc.oci8.OCIDBAcce ss)
at oracle.jdbc.oci8.OCIDBAcce ss.parseEx ecuteFetch (OCIDBAcce ss.java:13 21)
- locked <0332E868> (a oracle.jdbc.oci8.OCIDBAcce ss)
at oracle.jdbc.driver.OracleS tatement.e xecuteNonQ uery(Oracl eStatement .java:1446 )
at oracle.jdbc.driver.OracleS tatement.d oExecuteOt her(Oracle Statement. java:1371)
at oracle.jdbc.driver.OracleS tatement.d oExecuteWi thTimeout( OracleStat ement.java :1900)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteUpdate (OraclePre paredState ment.java: 363)
- locked <029F0C48> (a oracle.jdbc.driver.OracleP reparedSta tement)
at org.apache.commons.dbcp.De legatingPr eparedStat ement.exec uteUpdate( Delegating PreparedSt atement.ja va:233)
at edu.mit.coeus.utils.dbengi ne.DBEngin eImpl.inse rtPdfBlob( DBEngineIm pl.java:15 73)
at edu.mit.coeus.propdev.bean .ProposalD evelopment UpdateTxnB ean.update ProposalPe rsonPDFBlo bs(Proposa lDevelopme ntUpdateTx nBean.java :2067)
at edu.mit.coeus.propdev.bean .ProposalD evelopment UpdateTxnB ean.copyPr oposalPers onBiograph yBlobs(Pro posalDevel opmentUpda teTxnBean. java:2008)
at edu.mit.coeus.propdev.bean .ProposalD evelopment UpdateTxnB ean.copyPr oposal(Pro posalDevel opmentUpda teTxnBean. java:1864)
at edu.mit.coeus.servlet.Prop osalMainte nanceServl et.doPost( ProposalMa intenanceS ervlet.jav a:342)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 760)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:247 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:1 93)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:243)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:190)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.valves .Certifica tesValve.i nvoke(Cert ificatesVa lve.java:2 46)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.core.S tandardCon text.invok e(Standard Context.ja va:2343)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:180 )
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.valves .ErrorDisp atcherValv e.invoke(E rrorDispat cherValve. java:170)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:170 )
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.valves .AccessLog Valve.invo ke(AccessL ogValve.ja va:468)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :174)
at org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.connec tor.http.H ttpProcess or.process (HttpProce ssor.java: 1012)
at org.apache.catalina.connec tor.http.H ttpProcess or.run(Htt pProcessor .java:1107 )
at java.lang.Thread.run(Threa d.java:536 )
Dynamic libraries:
0x00400000 - 0x00406000 C:\j2sdk1.4.1_03\bin\java. exe
0x77F80000 - 0x77FFB000 C:\WINNT\system32\ntdll.dl l
0x7C2D0000 - 0x7C332000 C:\WINNT\system32\ADVAPI32 .dll
0x7C570000 - 0x7C623000 C:\WINNT\system32\KERNEL32 .DLL
0x77D30000 - 0x77D9E000 C:\WINNT\system32\RPCRT4.D LL
0x78000000 - 0x78045000 C:\WINNT\system32\MSVCRT.d ll
0x6D340000 - 0x6D46B000 C:\j2sdk1.4.1_03\jre\bin\c lient\jvm. dll
0x77E10000 - 0x77E6F000 C:\WINNT\system32\USER32.d ll
0x77F40000 - 0x77F79000 C:\WINNT\system32\GDI32.dl l
0x77570000 - 0x775A0000 C:\WINNT\system32\WINMM.dl l
0x6D1E0000 - 0x6D1E7000 C:\j2sdk1.4.1_03\jre\bin\h pi.dll
0x6D310000 - 0x6D31E000 C:\j2sdk1.4.1_03\jre\bin\v erify.dll
0x6D220000 - 0x6D239000 C:\j2sdk1.4.1_03\jre\bin\j ava.dll
0x6D330000 - 0x6D33D000 C:\j2sdk1.4.1_03\jre\bin\z ip.dll
0x6D270000 - 0x6D28C000 C:\j2sdk1.4.1_03\jre\bin\j dwp.dll
0x6D180000 - 0x6D185000 C:\j2sdk1.4.1_03\jre\bin\d t_socket.d ll
0x75030000 - 0x75044000 C:\WINNT\system32\ws2_32.d ll
0x75020000 - 0x75028000 C:\WINNT\system32\WS2HELP. DLL
0x55600000 - 0x5561D000 C:\Program Files\Microsoft Firewall Client\wspwsp.dll
0x77340000 - 0x77353000 C:\WINNT\system32\iphlpapi .dll
0x77520000 - 0x77525000 C:\WINNT\system32\ICMP.DLL
0x77320000 - 0x77337000 C:\WINNT\system32\MPRAPI.D LL
0x75150000 - 0x7515F000 C:\WINNT\system32\SAMLIB.D LL
0x75170000 - 0x751BF000 C:\WINNT\system32\NETAPI32 .DLL
0x7C340000 - 0x7C34F000 C:\WINNT\system32\SECUR32. DLL
0x751C0000 - 0x751C6000 C:\WINNT\system32\NETRAP.D LL
0x77950000 - 0x7797A000 C:\WINNT\system32\WLDAP32. DLL
0x77980000 - 0x779A4000 C:\WINNT\system32\DNSAPI.D LL
0x75050000 - 0x75058000 C:\WINNT\system32\WSOCK32. DLL
0x77A50000 - 0x77B3C000 C:\WINNT\system32\OLE32.DL L
0x77120000 - 0x771AB000 C:\WINNT\system32\OLEAUT32 .DLL
0x773B0000 - 0x773DF000 C:\WINNT\system32\ACTIVEDS .DLL
0x77380000 - 0x773A3000 C:\WINNT\system32\ADSLDPC. DLL
0x77830000 - 0x7783E000 C:\WINNT\system32\RTUTILS. DLL
0x77880000 - 0x7790E000 C:\WINNT\system32\SETUPAPI .DLL
0x7C0F0000 - 0x7C151000 C:\WINNT\system32\USERENV. DLL
0x774E0000 - 0x77513000 C:\WINNT\system32\RASAPI32 .DLL
0x774C0000 - 0x774D1000 C:\WINNT\system32\RASMAN.D LL
0x77530000 - 0x77552000 C:\WINNT\system32\TAPI32.D LL
0x71710000 - 0x71794000 C:\WINNT\system32\COMCTL32 .DLL
0x70A70000 - 0x70AD5000 C:\WINNT\system32\SHLWAPI. DLL
0x77360000 - 0x77379000 C:\WINNT\system32\DHCPCSVC .DLL
0x74FD0000 - 0x74FEE000 C:\WINNT\system32\msafd.dl l
0x75010000 - 0x75017000 C:\WINNT\System32\wshtcpip .dll
0x6D2E0000 - 0x6D2EE000 C:\j2sdk1.4.1_03\jre\bin\n et.dll
0x60000000 - 0x6000C000 E:\oracle\ora81\bin\ocijdb c8.dll
0x60600000 - 0x60686000 E:\oracle\ora81\bin\oracor e8.dll
0x60800000 - 0x6084D000 E:\oracle\ora81\bin\oranls 8.dll
0x60400000 - 0x60506000 E:\oracle\ora81\bin\oracli ent8.dll
0x10150000 - 0x10156000 E:\oracle\ora81\bin\oravsn 8.dll
0x60200000 - 0x60265000 E:\oracle\ora81\bin\oracom mon8.dll
0x10160000 - 0x10282000 E:\oracle\ora81\bin\oragen eric8.dll
0x60A00000 - 0x60A2B000 E:\oracle\ora81\bin\oranl8 .dll
0x60B00000 - 0x60BA9000 E:\oracle\ora81\bin\oran8. dll
0x60E00000 - 0x60E10000 E:\oracle\ora81\bin\orancr ypt8.dll
0x61100000 - 0x61137000 E:\oracle\ora81\bin\oranro 8.dll
0x10290000 - 0x102F1000 E:\oracle\ora81\bin\orannz sbb8.dll
0x61500000 - 0x6150E000 E:\oracle\ora81\bin\oranld ap8.dll
0x61700000 - 0x61720000 E:\oracle\ora81\bin\oralda pclnt8.dll
0x61900000 - 0x61906000 E:\oracle\ora81\bin\oranho st8.dll
0x62100000 - 0x62106000 E:\oracle\ora81\bin\oranon ame8.dll
0x10300000 - 0x10306000 E:\oracle\ora81\bin\orancd s8.dll
0x62300000 - 0x62306000 E:\oracle\ora81\bin\orantn s8.dll
0x62500000 - 0x62508000 E:\oracle\ora81\bin\orannd s8.dll
0x10310000 - 0x10317000 E:\oracle\ora81\bin\oranms .dll
0x10320000 - 0x10331000 E:\oracle\ora81\bin\oranms p.dll
0x62700000 - 0x62740000 E:\oracle\ora81\bin\ORATRA CE8.dll
0x62900000 - 0x62B23000 E:\oracle\ora81\bin\orapls 8.dll
0x63100000 - 0x63108000 E:\oracle\ora81\bin\orasla x8.dll
0x60350000 - 0x60356000 E:\oracle\ora81\bin\orawtc 8.dll
0x63200000 - 0x63273000 E:\oracle\ora81\bin\orasql 8.dll
0x64700000 - 0x6470B000 E:\oracle\ora81\bin\orantc p8.dll
0x77920000 - 0x77943000 C:\WINNT\system32\imagehlp .dll
0x72A00000 - 0x72A2D000 C:\WINNT\system32\DBGHELP. dll
0x690A0000 - 0x690AB000 C:\WINNT\system32\PSAPI.DL L
Local Time = Wed Apr 07 12:50:54 2004
Elapsed Time = 94
#
# The exception above was detected in native code outside the VM
#
# Java VM: Java HotSpot(TM) Client VM (1.4.1_03-b02 mixed mode)
#
when we're trying to update a bunch of records containing long raw columns thru prepared statement we get this error and the server gets crashed. what could be the problem. the stack trace is given below.
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : EXCEPTION_ACCESS_VIOLATION
Function=vsnupr+0x3331
Library=E:\oracle\ora81\bi
Current Java thread:
at oracle.jdbc.oci8.OCIDBAcce
at oracle.jdbc.oci8.OCIDBAcce
- locked <0332E868> (a oracle.jdbc.oci8.OCIDBAcce
at oracle.jdbc.oci8.OCIDBAcce
- locked <0332E868> (a oracle.jdbc.oci8.OCIDBAcce
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleP
- locked <029F0C48> (a oracle.jdbc.driver.OracleP
at org.apache.commons.dbcp.De
at edu.mit.coeus.utils.dbengi
at edu.mit.coeus.propdev.bean
at edu.mit.coeus.propdev.bean
at edu.mit.coeus.propdev.bean
at edu.mit.coeus.servlet.Prop
at javax.servlet.http.HttpSer
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.connec
at org.apache.catalina.connec
at java.lang.Thread.run(Threa
Dynamic libraries:
0x00400000 - 0x00406000 C:\j2sdk1.4.1_03\bin\java.
0x77F80000 - 0x77FFB000 C:\WINNT\system32\ntdll.dl
0x7C2D0000 - 0x7C332000 C:\WINNT\system32\ADVAPI32
0x7C570000 - 0x7C623000 C:\WINNT\system32\KERNEL32
0x77D30000 - 0x77D9E000 C:\WINNT\system32\RPCRT4.D
0x78000000 - 0x78045000 C:\WINNT\system32\MSVCRT.d
0x6D340000 - 0x6D46B000 C:\j2sdk1.4.1_03\jre\bin\c
0x77E10000 - 0x77E6F000 C:\WINNT\system32\USER32.d
0x77F40000 - 0x77F79000 C:\WINNT\system32\GDI32.dl
0x77570000 - 0x775A0000 C:\WINNT\system32\WINMM.dl
0x6D1E0000 - 0x6D1E7000 C:\j2sdk1.4.1_03\jre\bin\h
0x6D310000 - 0x6D31E000 C:\j2sdk1.4.1_03\jre\bin\v
0x6D220000 - 0x6D239000 C:\j2sdk1.4.1_03\jre\bin\j
0x6D330000 - 0x6D33D000 C:\j2sdk1.4.1_03\jre\bin\z
0x6D270000 - 0x6D28C000 C:\j2sdk1.4.1_03\jre\bin\j
0x6D180000 - 0x6D185000 C:\j2sdk1.4.1_03\jre\bin\d
0x75030000 - 0x75044000 C:\WINNT\system32\ws2_32.d
0x75020000 - 0x75028000 C:\WINNT\system32\WS2HELP.
0x55600000 - 0x5561D000 C:\Program Files\Microsoft Firewall Client\wspwsp.dll
0x77340000 - 0x77353000 C:\WINNT\system32\iphlpapi
0x77520000 - 0x77525000 C:\WINNT\system32\ICMP.DLL
0x77320000 - 0x77337000 C:\WINNT\system32\MPRAPI.D
0x75150000 - 0x7515F000 C:\WINNT\system32\SAMLIB.D
0x75170000 - 0x751BF000 C:\WINNT\system32\NETAPI32
0x7C340000 - 0x7C34F000 C:\WINNT\system32\SECUR32.
0x751C0000 - 0x751C6000 C:\WINNT\system32\NETRAP.D
0x77950000 - 0x7797A000 C:\WINNT\system32\WLDAP32.
0x77980000 - 0x779A4000 C:\WINNT\system32\DNSAPI.D
0x75050000 - 0x75058000 C:\WINNT\system32\WSOCK32.
0x77A50000 - 0x77B3C000 C:\WINNT\system32\OLE32.DL
0x77120000 - 0x771AB000 C:\WINNT\system32\OLEAUT32
0x773B0000 - 0x773DF000 C:\WINNT\system32\ACTIVEDS
0x77380000 - 0x773A3000 C:\WINNT\system32\ADSLDPC.
0x77830000 - 0x7783E000 C:\WINNT\system32\RTUTILS.
0x77880000 - 0x7790E000 C:\WINNT\system32\SETUPAPI
0x7C0F0000 - 0x7C151000 C:\WINNT\system32\USERENV.
0x774E0000 - 0x77513000 C:\WINNT\system32\RASAPI32
0x774C0000 - 0x774D1000 C:\WINNT\system32\RASMAN.D
0x77530000 - 0x77552000 C:\WINNT\system32\TAPI32.D
0x71710000 - 0x71794000 C:\WINNT\system32\COMCTL32
0x70A70000 - 0x70AD5000 C:\WINNT\system32\SHLWAPI.
0x77360000 - 0x77379000 C:\WINNT\system32\DHCPCSVC
0x74FD0000 - 0x74FEE000 C:\WINNT\system32\msafd.dl
0x75010000 - 0x75017000 C:\WINNT\System32\wshtcpip
0x6D2E0000 - 0x6D2EE000 C:\j2sdk1.4.1_03\jre\bin\n
0x60000000 - 0x6000C000 E:\oracle\ora81\bin\ocijdb
0x60600000 - 0x60686000 E:\oracle\ora81\bin\oracor
0x60800000 - 0x6084D000 E:\oracle\ora81\bin\oranls
0x60400000 - 0x60506000 E:\oracle\ora81\bin\oracli
0x10150000 - 0x10156000 E:\oracle\ora81\bin\oravsn
0x60200000 - 0x60265000 E:\oracle\ora81\bin\oracom
0x10160000 - 0x10282000 E:\oracle\ora81\bin\oragen
0x60A00000 - 0x60A2B000 E:\oracle\ora81\bin\oranl8
0x60B00000 - 0x60BA9000 E:\oracle\ora81\bin\oran8.
0x60E00000 - 0x60E10000 E:\oracle\ora81\bin\orancr
0x61100000 - 0x61137000 E:\oracle\ora81\bin\oranro
0x10290000 - 0x102F1000 E:\oracle\ora81\bin\orannz
0x61500000 - 0x6150E000 E:\oracle\ora81\bin\oranld
0x61700000 - 0x61720000 E:\oracle\ora81\bin\oralda
0x61900000 - 0x61906000 E:\oracle\ora81\bin\oranho
0x62100000 - 0x62106000 E:\oracle\ora81\bin\oranon
0x10300000 - 0x10306000 E:\oracle\ora81\bin\orancd
0x62300000 - 0x62306000 E:\oracle\ora81\bin\orantn
0x62500000 - 0x62508000 E:\oracle\ora81\bin\orannd
0x10310000 - 0x10317000 E:\oracle\ora81\bin\oranms
0x10320000 - 0x10331000 E:\oracle\ora81\bin\oranms
0x62700000 - 0x62740000 E:\oracle\ora81\bin\ORATRA
0x62900000 - 0x62B23000 E:\oracle\ora81\bin\orapls
0x63100000 - 0x63108000 E:\oracle\ora81\bin\orasla
0x60350000 - 0x60356000 E:\oracle\ora81\bin\orawtc
0x63200000 - 0x63273000 E:\oracle\ora81\bin\orasql
0x64700000 - 0x6470B000 E:\oracle\ora81\bin\orantc
0x77920000 - 0x77943000 C:\WINNT\system32\imagehlp
0x72A00000 - 0x72A2D000 C:\WINNT\system32\DBGHELP.
0x690A0000 - 0x690AB000 C:\WINNT\system32\PSAPI.DL
Local Time = Wed Apr 07 12:50:54 2004
Elapsed Time = 94
#
# The exception above was detected in native code outside the VM
#
# Java VM: Java HotSpot(TM) Client VM (1.4.1_03-b02 mixed mode)
#
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try using the executeBatch () method of Statement and see if that helps.
That's a native code error, and i'd guess it's caused by having an incorrect binary
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please proceed with that recommendation.