Title: Access violation in VM with HSQLDB 1.7.2 RC 6b
The error messages aren't very helpful. It obviously gets thrown on your getString(). The type of the column in question is not CHAR or VARCHAR, so a conversion takes place. What is the column type? Are you running in-process or client-server? What happens if you use Database Manager and issue a query such as SELECT MAX(COLUMN_IN_QUESTION) FROM ARP ?
 
Fred
----- Original Message -----
Sent: 07 June 2004 19:43
Subject: [Hsqldb-developers] Access violation in VM with HSQLDB 1.7.2 RC 6b

I'm running the test again, but the following code crashed with a VM EXCEPTION_ACCESS_VIOLATION:

ResultSet r = statement.executeQuery("Select * from ARP order by IFPHYSADDRESS");
boolean bContinue = r.next();

while (bContinue) {
    String currentMac = r.getString(4);
    pw.println("Mac Address " + currentMac + " belongs to " + r.getString(5));

    do {
        pw.println("Seen By: + r.getString(2) + " on Interface " + r.getInt(3));
//                             ^ This field gets printed to the log file, but the rest of the line is incomplete.
        bContinue = r.next();
    }
    while (bContinue && currentMac.equalsIgnoreCase(r.getString(4)));
}
r.close();

The code runs with a large data file (1.5GB), and I get about 8MB of output from the printlns until the crash.
From the source, I don't see anything that would cause this, but perhaps someone else has a better understanding of the code.

Thank you for your time.

Stephen Chen,   Product Developer
Visionael Corporation


An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x330031
Function=[Unknown.]
Library=(N/A)

NOTE: We are unable to locate the function name symbol for the error
      just occurred. Please refer to release documentation for possible
      reason and solutions.


Current Java thread:
        at org.hsqldb.Column.convertObject(Unknown Source)
        at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
        at org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
        at com.visionael.DataCollection.Discovery.SnmpDisc.SnmpDisc.createArpReport(SnmpDisc.java:2246)
        at com.visionael.DataCollection.Discovery.SnmpDisc.SnmpDisc.discover(SnmpDisc.java:2463)
        at com.visionael.DataCollection.Discovery.SnmpDisc.SnmpDisc.main(SnmpDisc.java:720)

Dynamic libraries:
0x00400000 - 0x0041E000         C:\Program Files\VisionaelNetworkAudit\DataCollection\VisSnmpDisc.exe
0x77F80000 - 0x77FFD000         C:\WINNT\system32\ntdll.dll
0x77E10000 - 0x77E75000         C:\WINNT\system32\USER32.dll
0x7C570000 - 0x7C628000         C:\WINNT\system32\KERNEL32.DLL
0x77F40000 - 0x77F7E000         C:\WINNT\system32\GDI32.DLL
0x6D340000 - 0x6D46B000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\client\jvm.dll
0x7C2D0000 - 0x7C332000         C:\WINNT\system32\ADVAPI32.dll
0x77D30000 - 0x77DA1000         C:\WINNT\system32\RPCRT4.DLL
0x77570000 - 0x775A0000         C:\WINNT\system32\WINMM.dll
0x78000000 - 0x78045000         C:\WINNT\system32\MSVCRT.dll
0x6D1E0000 - 0x6D1E7000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\hpi.dll
0x6D310000 - 0x6D31E000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\verify.dll
0x6D220000 - 0x6D239000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\java.dll
0x6D330000 - 0x6D33D000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\zip.dll
0x6D000000 - 0x6D105000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\awt.dll
0x77800000 - 0x7781E000         C:\WINNT\system32\WINSPOOL.DRV
0x76620000 - 0x76630000         C:\WINNT\system32\MPR.DLL
0x75E60000 - 0x75E7A000         C:\WINNT\system32\IMM32.dll
0x77A50000 - 0x77B3F000         C:\WINNT\system32\ole32.dll
0x6D2E0000 - 0x6D2EE000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\net.dll
0x75050000 - 0x75058000         C:\WINNT\system32\WSOCK32.dll
0x75030000 - 0x75044000         C:\WINNT\system32\WS2_32.DLL
0x75020000 - 0x75028000         C:\WINNT\system32\WS2HELP.DLL
0x6D2F0000 - 0x6D2F8000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\nio.dll
0x782C0000 - 0x782CC000         C:\WINNT\System32\rnr20.dll
0x77980000 - 0x779A4000         C:\WINNT\system32\DNSAPI.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
0x751C0000 - 0x751C6000         C:\WINNT\system32\NETRAP.DLL
0x77950000 - 0x7797A000         C:\WINNT\system32\WLDAP32.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 - 0x70AD5000         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
0x1FFB0000 - 0x1FFBE000         C:\Program Files\VisionaelNetworkAudit\DataCollection\IcmpLib.dll
0x74FD0000 - 0x74FEE000         C:\WINNT\system32\msafd.dll
0x75010000 - 0x75017000         C:\WINNT\System32\wshtcpip.dll
0x6D190000 - 0x6D1E0000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\fontmanager.dll
0x51000000 - 0x51047000         C:\WINNT\system32\ddraw.dll
0x728A0000 - 0x728A6000         C:\WINNT\system32\DCIMAN32.dll
0x5C000000 - 0x5C0C8000         C:\WINNT\system32\D3DIM700.DLL
0x6D140000 - 0x6D162000         C:\Program Files\VisionaelNetworkAudit\DataCollection\jre\bin\dcpr.dll
0x77920000 - 0x77943000         C:\WINNT\system32\imagehlp.dll
0x72A00000 - 0x72A2D000         C:\WINNT\system32\DBGHELP.dll
0x690A0000 - 0x690AB000         C:\WINNT\system32\PSAPI.DLL

Local Time = Fri Jun 04 20:24:46 2004
Elapsed Time = 23383
#
# 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)
#

Reply via email to