DriverManager Connection Object

Ruby JRuby
1

Hi,

I’m using JRuby+Rails for a reporting application. The underlying
reporting engine is Japer Report. I’m also using
jdbc+activerecord+oracle adapter.

To fill-out the Jasper Report I need to pass Jasper ‘fill-manager’ a
sql.DriverManager.Connection object among other things.

How can I get the sql.DriverManager.Connection from ActiveRecord::Base

Thanks
Yesh

2

Hi,

Was able to get the java.sql.Connection by doing this in my program. Not
sure if it’s the right way.

ActiveRecord::Base.connection.instance_eval(“def get_connection j_c = nil;@connection.with_connection_retry_guard do |c|; j_c = c; end; j_c;end”)
=> nil

Report.connection.get_connection.getMetaData
=> #<Java::OracleJdbcDriver::OracleDatabaseMetaData:0x16c50af
@java_object=oracle.jdbc.driver.OracleDatabaseMetaData@15e54e8>

Hope it helps someone. Maybe someone with more knowledge in the ar/jdbc
internals can help.

Thanks
Yesh