• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem with JDBC-ODBC Driver

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic