JRuby

Fatal error on opening WIN32OLE.new('ADODB.Recordset')

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: JRuby 1.7.0.pre1
  • Fix Version/s: None
  • Component/s: Application Error, win32ole, Windows
  • Environment:
    jruby 1.7.0.preview1 (ruby-1.9.3-p203) (2012-05-19 00c8c98) (Java HotSpot(TM) 64-Bit Server VM 1.6.0_23) [Windows Server 2008 R2-amd64-java]
  • Number of attachments :
    2

Description

Firstly, thanks for the awesome app. JRuby rocks.

I am getting a fatal error when running the following code on Windows 64-bit.

require 'win32ole'

begin
  conn_string = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Apps\rubyfuse\lmsdata.accdb;Persist Security Info=False;'
  conn = WIN32OLE.new('ADODB.Connection')
  conn.Open(conn_string)
  recordset = WIN32OLE.new('ADODB.Recordset')
  sql = 'SELECT * FROM Clients;'
  recordset.Open(sql, conn)  # Fatal error here.
ensure
  recordset.Close
  conn.Close
end

Seems to be a problem with the ADODB.Recordset. The error looks something like this.

#
# A fatal error has been detected by the Java Runtime Environment:
#
#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000007fee27b6b2b, pid=9420, tid=6592
#
# JRE version: 6.0_23-b05
# Java VM: Java HotSpot(TM) 64-Bit Server VM (19.0-b09 mixed mode windows-amd64compressed oops)
# Problematic frame:
# C  [racob-x64.dll+0x6b2b]
#
# An error report file with more information is saved as:
# C:\Apps\rubyfuse\hs_err_pid9420.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#

I've attached a copy of the log file. HTH, Thanks.

  1. Text File
    hs_err_pid17556.log
    30/Jun/12 8:16 PM
    46 kB
    David Irvine
  2. Text File
    hs_err_pid9420.log
    30/Jun/12 8:05 PM
    46 kB
    David Irvine

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
David Irvine added a comment -

Just tested, and I'm getting the same issue on 1.6.7.2 (jruby 1.6.7.2 (ruby-1.8.7-p357) (2012-05-01 26e08ba) (Java HotSpot(TM) 64-Bit Server VM 1.6.0_23) [Windows Server 2008 R2-amd64-java])

Show
David Irvine added a comment - Just tested, and I'm getting the same issue on 1.6.7.2 (jruby 1.6.7.2 (ruby-1.8.7-p357) (2012-05-01 26e08ba) (Java HotSpot(TM) 64-Bit Server VM 1.6.0_23) [Windows Server 2008 R2-amd64-java] )
Hide
Permalink
David Irvine added a comment -

jruby 1.6.7.2 error log.

Show
David Irvine added a comment - jruby 1.6.7.2 error log.
Hide
Permalink
Charles Oliver Nutter added a comment -

Thanks for the logs! Are you able to access any other services? Can you point out exactly which line causes the crash?

Show
Charles Oliver Nutter added a comment - Thanks for the logs! Are you able to access any other services? Can you point out exactly which line causes the crash?
Hide
Permalink
David Irvine added a comment -

Hi, yes, I can work with other WIN32OLE objects, such as Excel.Application, it's just the ADODB.Recordset that causes the crash. I did point out in my code, that it's the recordset.Open(sql, conn) line that crashes, thanks

Show
David Irvine added a comment - Hi, yes, I can work with other WIN32OLE objects, such as Excel.Application , it's just the ADODB.Recordset that causes the crash. I did point out in my code, that it's the recordset.Open(sql, conn) line that crashes, thanks
Hide
Permalink
Charles Oliver Nutter added a comment -

Oh, indeed you did! Thanks!

I've got to get my Windows VM set up today. One suggestion to try, to help us explore the problem, would be to install a 32-bit JVM and see if you have the same issues there. Also, do you have the most recent jruby-win32ole gem installed? Perhaps the one we shipped is out of date.

Show
Charles Oliver Nutter added a comment - Oh, indeed you did! Thanks! I've got to get my Windows VM set up today. One suggestion to try, to help us explore the problem, would be to install a 32-bit JVM and see if you have the same issues there. Also, do you have the most recent jruby-win32ole gem installed? Perhaps the one we shipped is out of date.
Hide
Permalink
David Irvine added a comment -

The server I was running that code on is a production server, so unfortunately I can't easily mess with the JVM for fear of breaking other apps. I will see if I can get a 64-bit test server set up though, to try this out on. I'll also give a shot at updating the gems and let you know if it helps.

Show
David Irvine added a comment - The server I was running that code on is a production server, so unfortunately I can't easily mess with the JVM for fear of breaking other apps. I will see if I can get a 64-bit test server set up though, to try this out on. I'll also give a shot at updating the gems and let you know if it helps.
Hide
Permalink
David Irvine added a comment -

I just realised something. 64-bit JRuby can't run on a 32-bit JVM right? Then this won't work, since I need to have access to the 64-bit COM objects, because that installation of Microsoft Office is 64-bit. Otherwise, it will just throw "Provider cannot be found." errors on opening the ADODB.Connection, same as when running this code from MRI.

Show
David Irvine added a comment - I just realised something. 64-bit JRuby can't run on a 32-bit JVM right? Then this won't work, since I need to have access to the 64-bit COM objects, because that installation of Microsoft Office is 64-bit. Otherwise, it will just throw "Provider cannot be found." errors on opening the ADODB.Connection, same as when running this code from MRI.
Hide
Permalink
David Irvine added a comment -

Also, gem appears to be the latest version: jruby-win32ole (0.8.5).

Show
David Irvine added a comment - Also, gem appears to be the latest version: jruby-win32ole (0.8.5) .
Hide
Permalink
David Irvine added a comment -

Okay, so I found a workaround to my problem, running queries using WIN32OLE.new('Access.Application') instead. Out of interest, here is my new code (not using the broken ADODB.Recordset):

require 'win32ole'

acc = WIN32OLE.new('Access.Application') # acc.Visible = 1
acc.OpenCurrentDatabase('C:\Apps\rubyfuse\lmsdata.accdb')

sql = 'SELECT * FROM Clients;'
recordset = acc.CurrentDb.OpenRecordset(sql)
data = []
begin
  data << row while row = recordset.GetRows
rescue
  # Last record, will throw a Java::OrgRacobCom::ComFailException (JRuby) or WIN32OLERuntimeError (MRI)
  # "DAO.Recordset: No current record."
end
puts data.inspect

On MRI, I get rows that look something like:

row = recordset.GetRows
# => [[1], ["First National Bank"]]
row.transpose
# => [[1, "First National Bank"]]

Whereas on JRuby, it looks something like:

row = recordset.GetRows
# => [#<Java::OrgRacobCom::Variant:0x1e4218cb>, #<Java::OrgRacobCom::Variant:0x569c6f2>]
row.map{ |field| field.to_s }
# => ["1", "First National Bank"]

So perhaps these Java::OrgRacobCom::Variant data types might have something to do with it? I wouldn't know. Anyways, just to let you know, this isn't too urgent. I've wrapped up my code using new approach.

Show
David Irvine added a comment - Okay, so I found a workaround to my problem, running queries using WIN32OLE.new('Access.Application') instead. Out of interest, here is my new code (not using the broken ADODB.Recordset): require 'win32ole' acc = WIN32OLE.new('Access.Application') # acc.Visible = 1 acc.OpenCurrentDatabase('C:\Apps\rubyfuse\lmsdata.accdb') sql = 'SELECT * FROM Clients;' recordset = acc.CurrentDb.OpenRecordset(sql) data = [] begin data << row while row = recordset.GetRows rescue # Last record, will throw a Java::OrgRacobCom::ComFailException (JRuby) or WIN32OLERuntimeError (MRI) # "DAO.Recordset: No current record." end puts data.inspect On MRI, I get rows that look something like: row = recordset.GetRows # => [[1], ["First National Bank"]] row.transpose # => [[1, "First National Bank"]] Whereas on JRuby, it looks something like: row = recordset.GetRows # => [#<Java::OrgRacobCom::Variant:0x1e4218cb>, #<Java::OrgRacobCom::Variant:0x569c6f2>] row.map{ |field| field.to_s } # => ["1", "First National Bank"] So perhaps these Java::OrgRacobCom::Variant data types might have something to do with it? I wouldn't know. Anyways, just to let you know, this isn't too urgent. I've wrapped up my code using new approach.

People

  • Assignee:
    Unassigned
    Reporter:
    David Irvine
Vote (0)
Watch (3)

Dates

  • Created:
    Updated: