From: "wbsurfver@..." <wbsurfver@...>
Date: 2007-11-16T01:25:03+09:00
Subject: Do I need to use JRuby to access an remote oracle DB with JDBC ?

When I try to connect to a remote oracle DB using activerecord oci8, I
get the error below.

I can connect with dbvisualizer tool using a JDBC connection. I'm not
on an officialy sanctioned project and can't really bug the sys admins
or anyone to configure me something on the remote server. If I want to
try to connect in ruby using JDBC, I'm guessing I may have to use
JRuby otherwise it won't work ?


C:\rb-play>ar_connect_ss.rb
env.c:257:in oci8lib.so: ORA-12514: TNS:listener does not currently
know of serv
ice requested in connect descriptor (OCIError)
        from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:228:in
`initialize'
        from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_recor
d/connection_adapters/oracle_adapter.rb:585:in `new'