This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC 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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with JDBC-ODBC Driver" Watch "Problem with JDBC-ODBC Driver" New topic
Author

Problem with JDBC-ODBC Driver

zephyr lee
Greenhorn

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
Function=gds__thread_start+0x257
Library=C:\WINNT\system32\gds32.dll

Current Java thread:
at sun.jdbc.odbc.JdbcOdbc.driverConnect(Native Method)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3068)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
- locked <0x105658b0> (a sun.jdbc.odbc.JdbcOdbcDriver)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
- locked <0x1431ac90> (a java.lang.Class)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
- locked <0x1431ac90> (a java.lang.Class)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:290)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:276)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:258)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:240)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:107)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:506)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:545)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:563)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:593)
at com.sim.datamigration.dao.StudentInterbaseDAO.getStudent(StudentInterbaseDAO.java:188)
at com.sim.datamigration.services.StudentServices.getStudentIfExists(StudentServices.java:108)
at com.sim.datamigration.activity.BatchStudentActivity.execute(BatchStudentActivity.java:141)
at org.iocworkflow.SequenceProcessor.doActivities(SequenceProcessor.java:63)
at com.sim.datamigration.manager.BatchStudentMigrationManager.execute(BatchStudentMigrationManager.java:70)
at com.sim.datamigration.command.InterfaceMain.main(InterfaceMain.java:143)

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:
Heap
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)
#


Cheers
Zephyr
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
Greenhorn

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

found someting on this page:
http://forum.java.sun.com/thread.jspa?threadID=570583&messageID=2990728

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: http://aspose.com/file-tools
 
subject: Problem with JDBC-ODBC Driver