Do I need to use JRuby to access an remote oracle DB with JDBC ? : RUBY

Application Development · #1 11-15-2007, 11:21 AM

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'

Application Development · #2 11-15-2007, 12:03 PM

2007/11/15, wbsurfver@yahoo.com <wbsurfver@gmail.com>:
> 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

--
use.inject do |as, often| as.you_can - without end

Application Development · #3 11-15-2007, 12:12 PM

On Nov 15, 2007, at 5:25 PM, wbsurfver@yahoo.com 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Oracle Mix, powered by JRuby	usenet	RUBY	1	11-20-2007 04:11 PM
JDBC & Access \ Oracle	usenet	JDBC JAVA	2	01-15-2007 03:13 AM
Access Oracle with JDBC through OCI	usenet	JDBC JAVA	2	05-31-2006 04:25 PM
JDBC access with Oracle	usenet	JDBC JAVA	2	01-30-2006 01:47 AM
OrindaBuild Oracle JDBC Tool Now Supports Oracle 10G and JDeveloper	usenet	Java	0	04-15-2004 05:17 AM

Do I need to use JRuby to access an remote oracle DB with JDBC ? : RUBY

Similar Threads