Forum: Ruby on Rails Getting at DBI connection via ActiveRecord connection

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Wes G. (Guest)
on 2008-12-01 19:58
I have a standalone batch program that is going to move data between two
databases.

I am taking advantage of the AR connection semantics in database.yml to
get connections to these two DBs.  But I want to do all of my DB access
at the DBI/DBD level for performance reasons.

I am having trouble getting access to the underlying DBI handle so that
I can prepare SQL statements, execute them etc.

From a connection retrieve via AR::Base.retrieve_connection, how can I
get at the DBI handle?

Is it possible that I've misunderstood that AR DB access is built on top
of DBI?

Thanks,
Wes
Wes G. (Guest)
on 2008-12-01 20:58
Upon further inspection, I see that AR doesn't depend on DBI.  I wonder
why not...

As it turns out, I'm in a JRuby environment, so I can just do prepared
statements via that method.

Thanks,
Wes
This topic is locked and can not be replied to.