This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB CONN. - EXCEPTION_ACCESS_VIOLATION Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB CONN. - EXCEPTION_ACCESS_VIOLATION" Watch "DB CONN. - EXCEPTION_ACCESS_VIOLATION" New topic
Author

DB CONN. - EXCEPTION_ACCESS_VIOLATION

Morrison Julia
Greenhorn

Joined: Sep 04, 2006
Posts: 3
I've developed a "batch process" which uses three different databases(two sql servers and one oracle). The application uses two different connection pools ; one for sql server and another one for oracle. The remaining sql server I've to connect using Data Source Name(DSN) defined in the data source. I am using sun's odbc-jdbc bridge mechanism/tool/driver to get connection and I am not using connection pool. Whenever need connection, the application will pass the dsn, user and password, and a new connection will be created. the application creates and uses 3 connections per minute in an average.

I am getting this error after sometimes 609th, 1222th, or 1069th connections for the same database. As soon the application gets this error, the JVM is killed.

PLEASE HELP ME and if you need more info. pl. let me know

Thanks,
Julia


#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c901010, pid=176, tid=3652
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_08-b03 mixed mode)
# Problematic frame:
# C [ntdll.dll+0x1010]
#

--------------- T H R E A D ---------------

Current thread (0x0aa98e10): JavaThread "Timer-2" [_thread_in_native, id=3652]

siginfo: ExceptionCode=0xc0000005, reading address 0x00000018

Registers:
EAX=0x00000004, EBX=0x0b28f674, ECX=0x7ffa9000, EDX=0x00000004
ESP=0x0b28f610, EBP=0x0b28f628, ESI=0x00000000, EDI=0x0b0d12a0
EIP=0x7c901010, EFLAGS=0x00000297

Top of Stack: (sp=0x0b28f610)
0x0b28f610: 74355a16 00000004 0b0d12c4 7432139f
0x0b28f620: 0b0d12c4 00000000 0b28f640 7432a244
0x0b28f630: 0b0d12c4 74350000 0aa98ed0 00000000
0x0b28f640: 0b28f654 7432a653 0abeafe0 0aa98ed0
0x0b28f650: 0728b200 0b28f66c 6d371157 0b0d12a0
0x0b28f660: 0b28f674 0aa98e10 0728b200 0b28f6a4
0x0b28f670: 0085832f 00000000 0b28f6c0 0b0d12a0
0x0b28f680: 00000000 0b28f6b4 0b28f688 00000000

Instructions: (pc=0x7c901010)
0x7c901000: 90 90 90 90 90 64 8b 0d 18 00 00 00 8b 54 24 04
0x7c901010: 83 7a 14 00 75 4f f0 ff 42 04 75 19 8b 41 24 89


Stack: [0x0b250000,0x0b290000), sp=0x0b28f610, free space=253k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
C [ntdll.dll+0x1010]
C [ODBC32.dll+0xa244]
C [ODBC32.dll+0xa653]
C [JdbcOdbc.dll+0x1157]
j sun.jdbc.odbc.JdbcOdbc.allocConnect(J[B)J+0
j sun.jdbc.odbc.JdbcOdbc.SQLAllocConnect(J)J+30
j sun.jdbc.odbc.JdbcOdbcDriver.allocConnection(J)J+6
j sun.jdbc.odbc.JdbcOdbcConnection.initialize(Ljava/lang/String;Ljava/util/Properties;I)V+37
j sun.jdbc.odbc.JdbcOdbcDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+129
J java.sql.DriverManager.getConnection(Ljava/lang/String;Ljava/util/Properties;Ljava/lang/ClassLoader;)Ljava/sql/Connection;
j java.sql.DriverManager.getConnection(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+41
j com.realm.connect.conndbresources.FADatabaseResourceManager.getConnection()Ljava/sql/Connection;+59
j com.realm.connect.conndbresources.FADatabaseResourceManager.getListOfVersionsInDYNANotInJDE(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/HashMap;)Ljava/util/ArrayList;+245
J com.realm.connect.process.PopulateReXMLLeaseData.createLeaseData(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Lcom/realm/connect/jaxb/rexml/PropertyDataType$RetailSalesType;Lcom/realm/connect/jaxb/rexml/PropertyDataType$ReportCategoriesType;Ljava/util/HashMap;Ljava/lang/String;Lcom/realm/connect/jaxb/rexml/LeaseDataType;)Lcom/realm/connect/jaxb/rexml/LeaseDataType;
v ~RuntimeStub::alignment_frame_return Runtime1 stub
j com.realm.connect.process.BuildSelectionCriteriaReXML.createReXML(Ljava/lang/String;Ljava/lang/String;Ljava/util/Hashtable;Ljava/lang/String;)V+1115
j com.realm.connect.process.BuildSelectionCriteriaReXML.RunBuildSelectionCriteriaReXML(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Ljava/lang/String;)V+1394
j com.realm.connect.process.BuildSelectionCriteriaReXML.<init>(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V+249
j com.realm.connect.process.BatchScheduleWeekly.run()V+334
j java.util.TimerThread.mainLoop()V+221
j java.util.TimerThread.run()V+1
v ~StubRoutines::call_stub
V [jvm.dll+0x86e84]
V [jvm.dll+0xddead]
V [jvm.dll+0x86d55]
V [jvm.dll+0x86ab2]
V [jvm.dll+0xa16b2]
V [jvm.dll+0x10f4ac]
V [jvm.dll+0x10f47a]
C [MSVCRT.dll+0x2a3b0]
C [kernel32.dll+0xb683]

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
j sun.jdbc.odbc.JdbcOdbc.allocConnect(J[B)J+0
j sun.jdbc.odbc.JdbcOdbc.SQLAllocConnect(J)J+30
j sun.jdbc.odbc.JdbcOdbcDriver.allocConnection(J)J+6
j sun.jdbc.odbc.JdbcOdbcConnection.initialize(Ljava/lang/String;Ljava/util/Properties;I)V+37
j sun.jdbc.odbc.JdbcOdbcDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+129
J java.sql.DriverManager.getConnection(Ljava/lang/String;Ljava/util/Properties;Ljava/lang/ClassLoader;)Ljava/sql/Connection;
j java.sql.DriverManager.getConnection(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+41
j com.realm.connect.conndbresources.FADatabaseResourceManager.getConnection()Ljava/sql/Connection;+59
j com.realm.connect.conndbresources.FADatabaseResourceManager.getListOfVersionsInDYNANotInJDE(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/HashMap;)Ljava/util/ArrayList;+245
J com.realm.connect.process.PopulateReXMLLeaseData.createLeaseData(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Lcom/realm/connect/jaxb/rexml/PropertyDataType$RetailSalesType;Lcom/realm/connect/jaxb/rexml/PropertyDataType$ReportCategoriesType;Ljava/util/HashMap;Ljava/lang/String;Lcom/realm/connect/jaxb/rexml/LeaseDataType;)Lcom/realm/connect/jaxb/rexml/LeaseDataType;
v ~RuntimeStub::alignment_frame_return Runtime1 stub
j com.realm.connect.process.BuildSelectionCriteriaReXML.createReXML(Ljava/lang/String;Ljava/lang/String;Ljava/util/Hashtable;Ljava/lang/String;)V+1115
j com.realm.connect.process.BuildSelectionCriteriaReXML.RunBuildSelectionCriteriaReXML(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Ljava/lang/String;)V+1394
j com.realm.connect.process.BuildSelectionCriteriaReXML.<init>(Lcom/realm/connect/jaxb/sc/ConnSelectCriteria;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V+249
j com.realm.connect.process.BatchScheduleWeekly.run()V+334
j java.util.TimerThread.mainLoop()V+221
j java.util.TimerThread.run()V+1
v ~StubRoutines::call_stub

--------------- P R O C E S S ---------------

Java Threads: ( => current thread )
=>0x0aa98e10 JavaThread "Timer-2" [_thread_in_native, id=3652]
0x0ae6b410 JavaThread "Timer-1" [_thread_in_native, id=2808]
0x0aa3ea10 JavaThread "Thread-2" [_thread_blocked, id=2796]
0x0aa7cb60 JavaThread "Thread-1" [_thread_blocked, id=2912]
0x0adf4a60 JavaThread "Timer-0" [_thread_blocked, id=360]
0x000388b0 JavaThread "DestroyJavaVM" [_thread_blocked, id=3188]
0x0aaf5b80 JavaThread "Wrapper-Connection" daemon [_thread_in_native, id=1492]
0x0aa409e8 JavaThread "Wrapper-Control-Event-Monitor" daemon [_thread_blocked, id=3124]
0x00816d18 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2532]
0x00815988 JavaThread "CompilerThread0" daemon [_thread_blocked, id=660]
0x00814e28 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=3536]
0x0080bbc8 JavaThread "Finalizer" daemon [_thread_blocked, id=2720]
0x0080a798 JavaThread "Reference Handler" daemon [_thread_blocked, id=2676]

Other Threads:
0x00806558 VMThread [id=3956]
0x00812e18 WatcherThread [id=856]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

Heap
def new generation total 1792K, used 840K [0x02850000, 0x02a40000, 0x02d30000)
eden space 1600K, 46% used [0x02850000, 0x0290a6c8, 0x029e0000)
from space 192K, 49% used [0x02a10000, 0x02a27d28, 0x02a40000)
to space 192K, 0% used [0x029e0000, 0x029e0000, 0x02a10000)
tenured generation total 23176K, used 16150K [0x02d30000, 0x043d2000, 0x06850000)
the space 23176K, 69% used [0x02d30000, 0x03cf5b08, 0x03cf5c00, 0x043d2000)
compacting perm gen total 12288K, used 12128K [0x06850000, 0x07450000, 0x0a850000)
the space 12288K, 98% used [0x06850000, 0x074280c0, 0x07428200, 0x07450000)
No shared spaces configured.

Dynamic libraries:
0x00400000 - 0x0040d000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\java.exe
0x7c900000 - 0x7c9b0000 C:\WINDOWS\system32\ntdll.dll
0x7c800000 - 0x7c8f4000 C:\WINDOWS\system32\kernel32.dll
0x77dd0000 - 0x77e6b000 C:\WINDOWS\system32\ADVAPI32.dll
0x77e70000 - 0x77f01000 C:\WINDOWS\system32\RPCRT4.dll
0x77c10000 - 0x77c68000 C:\WINDOWS\system32\MSVCRT.dll
0x6d6c0000 - 0x6d85b000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\client\jvm.dll
0x77d40000 - 0x77dd0000 C:\WINDOWS\system32\USER32.dll
0x77f10000 - 0x77f57000 C:\WINDOWS\system32\GDI32.dll
0x76b40000 - 0x76b6d000 C:\WINDOWS\system32\WINMM.dll
0x5dac0000 - 0x5dac8000 C:\WINDOWS\system32\rdpsnd.dll
0x76360000 - 0x76370000 C:\WINDOWS\system32\WINSTA.dll
0x5b860000 - 0x5b8b4000 C:\WINDOWS\system32\NETAPI32.dll
0x76bf0000 - 0x76bfb000 C:\WINDOWS\system32\PSAPI.DLL
0x6d280000 - 0x6d288000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\hpi.dll
0x77fe0000 - 0x77ff1000 C:\WINDOWS\system32\Secur32.dll
0x6d690000 - 0x6d69c000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\verify.dll
0x6d300000 - 0x6d31d000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\java.dll
0x6d6b0000 - 0x6d6bf000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\zip.dll
0x10000000 - 0x10013000 C:\wrapper\lib\wrapper-windows-x86-32.dll
0x6d4c0000 - 0x6d4d3000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\net.dll
0x71ab0000 - 0x71ac7000 C:\WINDOWS\system32\WS2_32.dll
0x71aa0000 - 0x71aa8000 C:\WINDOWS\system32\WS2HELP.dll
0x71a50000 - 0x71a8f000 C:\WINDOWS\system32\mswsock.dll
0x662b0000 - 0x66308000 C:\WINDOWS\system32\hnetcfg.dll
0x71a90000 - 0x71a98000 C:\WINDOWS\System32\wshtcpip.dll
0x76f20000 - 0x76f47000 C:\WINDOWS\system32\DNSAPI.dll
0x76fb0000 - 0x76fb8000 C:\WINDOWS\System32\winrnr.dll
0x76f60000 - 0x76f8c000 C:\WINDOWS\system32\WLDAP32.dll
0x76fc0000 - 0x76fc6000 C:\WINDOWS\system32\rasadhlp.dll
0x6d370000 - 0x6d37d000 C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin\JdbcOdbc.dll
0x74320000 - 0x7435d000 C:\WINDOWS\system32\ODBC32.dll
0x5d090000 - 0x5d12a000 C:\WINDOWS\system32\COMCTL32.dll
0x7c9c0000 - 0x7d1d5000 C:\WINDOWS\system32\SHELL32.dll
0x77f60000 - 0x77fd6000 C:\WINDOWS\system32\SHLWAPI.dll
0x763b0000 - 0x763f9000 C:\WINDOWS\system32\comdlg32.dll
0x773d0000 - 0x774d3000 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03\comctl32.dll
0x20000000 - 0x20017000 C:\WINDOWS\system32\odbcint.dll
0x77c00000 - 0x77c08000 C:\WINDOWS\system32\VERSION.dll
0x774e0000 - 0x7761d000 C:\WINDOWS\system32\ole32.dll
0x5fe80000 - 0x5fe9b000 C:\WINDOWS\system32\odbccp32.dll
0x77c70000 - 0x77c93000 C:\WINDOWS\system32\msv1_0.dll
0x76d60000 - 0x76d79000 C:\WINDOWS\system32\iphlpapi.dll

VM Arguments:
jvm_args: -Djava.library.path=../lib -Dwrapper.key=hJ4ROjr9dlwjBqsE -Dwrapper.port=32000 -Dwrapper.jvm.port.min=31000 -Dwrapper.jvm.port.max=31999 -Dwrapper.pid=2196 -Dwrapper.version=3.2.1 -Dwrapper.native_library=wrapper -Dwrapper.service=TRUE -Dwrapper.cpu.timeout=10 -Dwrapper.jvmid=5
java_command: org.tanukisoftware.wrapper.WrapperSimpleApp com.realm.connect.process.BatchProcessStart C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\CONNECT\
Launcher Type: SUN_STANDARD

Environment Variables:
PATH=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\MyEclipse Enterprise Workbench 5.1.0 GA\jre\bin;C:\Sun\SDK\jdk\bin;
OS=Windows_NT
PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 8, GenuineIntel



--------------- S Y S T E M ---------------

OS: Windows XP Build 2600 Service Pack 2

CPU:total 1 (cores per cpu 1, threads per core 2) family 15 model 4 stepping 1, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ht

Memory: 4k page, physical 523760k(118812k free), swap 2029640k(1564992k free)

vm_info: Java HotSpot(TM) Client VM (1.5.0_08-b03) for windows-x86, built on Jul 26 2006 01:10:50 by "java_re" with MS VC++ 6.0
[ April 23, 2007: Message edited by: Bear Bibeault ]
Gaurav Chikara
Ranch Hand

Joined: Jun 09, 2000
Posts: 410
Generally this exception comes when heap memory exceeeds to that what JVM can handle
You must try setting heap memory to greater value using xmx ,xms variables in your Environment file


SCJP,SCWCD,SCBCD<br />If Opportunity doesn't knock then build the door
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB CONN. - EXCEPTION_ACCESS_VIOLATION
 
Similar Threads
crash
JAI error :EXCEPTION_FLT_DIVIDE_BY_ZERO
An unexpected error has been detected by HotSpot Virtual Machine:
EXCEPTION_ACCESS_VIOLATION & MSAccess
An unexpected error has been detected by HotSpot Virtual Machine