File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem with JDBC-ODBC Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with JDBC-ODBC Driver" Watch "Problem with JDBC-ODBC Driver" New topic

Problem with JDBC-ODBC Driver

zephyr lee

Joined: Sep 18, 2006
Posts: 4
Hi folks out there

I'm running a java/spring program that uses the JDBC-ODBC driver to connect to Interbase to transfer data. After running for a while, it crashes with the following error. Sometimes it ran fine without any errors. Suspecting it has something to do with JDBC-ODBC driver. Any ideas/solutions? Any help appreciated. Thanks

An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x40543EF7

Current Java thread:
at sun.jdbc.odbc.JdbcOdbc.driverConnect(Native Method)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(
at sun.jdbc.odbc.JdbcOdbcDriver.connect(
- locked <0x105658b0> (a sun.jdbc.odbc.JdbcOdbcDriver)
at java.sql.DriverManager.getConnection(
- locked <0x1431ac90> (a java.lang.Class)
at java.sql.DriverManager.getConnection(
- locked <0x1431ac90> (a java.lang.Class)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(
at org.springframework.jdbc.core.JdbcTemplate.execute(
at org.springframework.jdbc.core.JdbcTemplate.query(
at org.springframework.jdbc.core.JdbcTemplate.query(
at org.springframework.jdbc.core.JdbcTemplate.query(
at org.springframework.jdbc.core.JdbcTemplate.query(
at org.springframework.jdbc.core.JdbcTemplate.query(
at com.sim.datamigration.dao.StudentInterbaseDAO.getStudent(
at com.sim.datamigration.activity.BatchStudentActivity.execute(
at org.iocworkflow.SequenceProcessor.doActivities(
at com.sim.datamigration.manager.BatchStudentMigrationManager.execute(
at com.sim.datamigration.command.InterfaceMain.main(

Dynamic libraries:
0x00400000 - 0x0040B000 C:\j2sdk1.4.2_05\jre\bin\java.exe
0x77F80000 - 0x77FFD000 C:\WINNT\system32\ntdll.dll
0x7C2D0000 - 0x7C332000 C:\WINNT\system32\ADVAPI32.dll
0x7C570000 - 0x7C623000 C:\WINNT\system32\KERNEL32.DLL
0x77D30000 - 0x77DA1000 C:\WINNT\system32\RPCRT4.DLL
0x78000000 - 0x78045000 C:\WINNT\system32\MSVCRT.dll
0x08000000 - 0x08139000 C:\j2sdk1.4.2_05\jre\bin\client\jvm.dll
0x77E10000 - 0x77E6F000 C:\WINNT\system32\USER32.dll
0x77F40000 - 0x77F7B000 C:\WINNT\system32\GDI32.dll
0x77570000 - 0x775A0000 C:\WINNT\system32\WINMM.dll
0x75E60000 - 0x75E7A000 C:\WINNT\system32\IMM32.DLL
0x10000000 - 0x10011000 C:\WINNT\system32\AMInit.dll
0x007C0000 - 0x007C7000 C:\j2sdk1.4.2_05\jre\bin\hpi.dll
0x007E0000 - 0x007EE000 C:\j2sdk1.4.2_05\jre\bin\verify.dll
0x007F0000 - 0x00809000 C:\j2sdk1.4.2_05\jre\bin\java.dll
0x00810000 - 0x0081D000 C:\j2sdk1.4.2_05\jre\bin\zip.dll
0x18440000 - 0x1844F000 C:\j2sdk1.4.2_05\jre\bin\net.dll
0x75030000 - 0x75044000 C:\WINNT\system32\WS2_32.dll
0x75020000 - 0x75028000 C:\WINNT\system32\WS2HELP.DLL
0x782C0000 - 0x782CC000 C:\WINNT\System32\rnr20.dll
0x77980000 - 0x779A4000 C:\WINNT\system32\DNSAPI.DLL
0x75050000 - 0x75058000 C:\WINNT\system32\WSOCK32.DLL
0x77340000 - 0x77353000 C:\WINNT\system32\iphlpapi.dll
0x77520000 - 0x77525000 C:\WINNT\system32\ICMP.DLL
0x77320000 - 0x77337000 C:\WINNT\system32\MPRAPI.DLL
0x75150000 - 0x7515F000 C:\WINNT\system32\SAMLIB.DLL
0x75170000 - 0x751BF000 C:\WINNT\system32\NETAPI32.DLL
0x7C340000 - 0x7C34F000 C:\WINNT\system32\Secur32.dll
0x77BF0000 - 0x77C01000 C:\WINNT\system32\NTDSAPI.dll
0x77950000 - 0x7797A000 C:\WINNT\system32\WLDAP32.DLL
0x751C0000 - 0x751C6000 C:\WINNT\system32\NETRAP.dll
0x77A50000 - 0x77B3F000 C:\WINNT\system32\OLE32.DLL
0x779B0000 - 0x77A4B000 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.DLL
0x77530000 - 0x77552000 C:\WINNT\system32\TAPI32.DLL
0x71710000 - 0x71794000 C:\WINNT\system32\COMCTL32.DLL
0x70A70000 - 0x70AD6000 C:\WINNT\system32\SHLWAPI.DLL
0x77360000 - 0x77379000 C:\WINNT\system32\DHCPCSVC.DLL
0x777E0000 - 0x777E8000 C:\WINNT\System32\winrnr.dll
0x777F0000 - 0x777F5000 C:\WINNT\system32\rasadhlp.dll
0x74FD0000 - 0x74FEE000 C:\WINNT\system32\msafd.dll
0x75010000 - 0x75017000 C:\WINNT\System32\wshtcpip.dll
0x18D80000 - 0x18D8C000 C:\j2sdk1.4.2_05\jre\bin\JdbcOdbc.dll
0x1F7F0000 - 0x1F825000 C:\WINNT\system32\ODBC32.dll
0x76B30000 - 0x76B6E000 C:\WINNT\system32\comdlg32.dll
0x782F0000 - 0x78535000 C:\WINNT\system32\SHELL32.DLL
0x1F8E0000 - 0x1F8F6000 C:\WINNT\system32\odbcint.dll
0x28720000 - 0x28744000 C:\WINNT\system32\IBINT13.DLL
0x02A70000 - 0x02ABE000 C:\WINNT\system32\ibutl13.dll
0x28050000 - 0x280A0000 C:\WINNT\system32\ibbas13.dll
0x40530000 - 0x4058B000 C:\WINNT\system32\gds32.dll
0x76620000 - 0x76630000 C:\WINNT\system32\MPR.dll
0x1F840000 - 0x1F85A000 C:\WINNT\system32\odbccp32.dll
0x77820000 - 0x77827000 C:\WINNT\system32\VERSION.dll
0x759B0000 - 0x759B6000 C:\WINNT\system32\LZ32.DLL
0x77920000 - 0x77943000 C:\WINNT\system32\imagehlp.dll
0x72A00000 - 0x72A2D000 C:\WINNT\system32\DBGHELP.dll
0x690A0000 - 0x690AB000 C:\WINNT\system32\PSAPI.DLL

Heap at VM Abort:
def new generation total 576K, used 373K [0x10020000, 0x100c0000, 0x10500000)
eden space 512K, 65% used [0x10020000, 0x10073e90, 0x100a0000)
from space 64K, 59% used [0x100a0000, 0x100a97e8, 0x100b0000)
to space 64K, 0% used [0x100b0000, 0x100b0000, 0x100c0000)
tenured generation total 6428K, used 4077K [0x10500000, 0x10b47000, 0x14020000)
the space 6428K, 63% used [0x10500000, 0x108fb558, 0x108fb600, 0x10b47000)
compacting perm gen total 6656K, used 6583K [0x14020000, 0x146a0000, 0x18020000)
the space 6656K, 98% used [0x14020000, 0x1468df50, 0x1468e000, 0x146a0000)

Local Time = Fri Sep 08 13:42:59 2006
Elapsed Time = 2411
# The exception above was detected in native code outside the VM
# Java VM: Java HotSpot(TM) Client VM (1.4.2_05-b04 mixed mode)

Dan Howard
Ranch Hand

Joined: Feb 22, 2004
Posts: 47
Not sure if anyone can help you with this here.

do a goole search for "firebird jdbc" or "interbase jdbc" and you'll find many hits.
Rajesh Agarwal
Ranch Hand

Joined: Aug 01, 2005
Posts: 79
This is not a JDBC or a driver problem. This more looks like a JNI problem. I have seen some people having the same issue accessing code outside JVM which is a non-JDBC code.
zephyr lee

Joined: Sep 18, 2006
Posts: 4
thanks folks i did tried search on net but to no avail...

found someting on this page:

probably the interbase version using is 5.5 (too old) but there is no intention to upgrade the newer version of interbase has jdbc driver that comes with it... sigh.... any other suggestions? or anyone write driver for interbase before? maybe can give me some pointers. Thanks
I agree. Here's the link:
subject: Problem with JDBC-ODBC Driver
It's not a secret anymore!