# Do I need to use JRuby to access an remote oracle DB with JDBC? **URL:** \ **Category:** Ruby\ **Created:** [November 15, 2007, 5:25pm UTC](https://www.ruby-forum.com/t/do-i-need-to-use-jruby-to-access-an-remote-oracle-db-with-jdbc/120302 "2007-11-15T17:25:35Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [November 15, 2007, 5:25pm UTC](https://www.ruby-forum.com/t/do-i-need-to-use-jruby-to-access-an-remote-oracle-db-with-jdbc/120302/1 "2007-11-15T17:25:35Z")
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’ ---
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [November 15, 2007, 6:04pm UTC](https://www.ruby-forum.com/t/do-i-need-to-use-jruby-to-access-an-remote-oracle-db-with-jdbc/120302/2 "2007-11-15T18:04:28Z")
2007/11/15, removed\_email\_address@domain.invalid [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > 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 ? Well, if you want to use JDBC you must be on a JVM. As you probably know there are several options (aka programming languages) that will work - including but not limited to Java. 🙂 > 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’ This might as well be an issue with your local connection configuration. Do you have ORACLE\_HOME set appropriately and do you have your tnsnames.ora properly edited? Cheers robert ---
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [November 15, 2007, 6:13pm UTC](https://www.ruby-forum.com/t/do-i-need-to-use-jruby-to-access-an-remote-oracle-db-with-jdbc/120302/3 "2007-11-15T18:13:16Z")
On Nov 15, 2007, at 5:25 PM, removed\_email\_address@domain.invalid wrote: > 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 ? Probably the Java application is using the thin driver. If you have the Oracle client installed you need to configure it properly (ORACLE\_HOME, tnsnames.ora). Otherwise JRuby + driver thin is an option, yes. – fxn