[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Ruby & Oracle 10g

Anders Engström

10/28/2004 9:09:00 PM

Hi.

I'll be starting a new project in a month or two, and the DB will be
Oracle 10g. The project is a strict Java-hack, but I'll want to write
some utility scripts in Ruby to interact with the DB.

I've been scanning the web for information on how to connect to an
Oracle 10g DB, but so far I haven't found anything useful.

Is there any work in progress for a Ruby/DBI (or similar) for Oracle 10g
(or, 9.2 for that matter)?

//Anders

--
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Anders Engström aengstrom@gnejs.net
http://www... PGP-Key: ED010E7F
[Your mind is like an umbrella. It doesn't work unless you open it.]




6 Answers

Alexey Verkhovsky

10/28/2004 9:14:00 PM

0

On Fri, 2004-10-29 at 00:08, Anders Engström wrote:
> Is there any work in progress for a Ruby/DBI (or similar) for Oracle 10g
> (or, 9.2 for that matter)?

DBI comes with Oracle driver that can work with 9.2 at least.

Alex

Anders Engström

10/28/2004 9:31:00 PM

0

On Fri, Oct 29, 2004 at 06:14:13AM +0900, Alexey Verkhovsky wrote:
> On Fri, 2004-10-29 at 00:08, Anders Engström wrote:
> > Is there any work in progress for a Ruby/DBI (or similar) for Oracle 10g
> > (or, 9.2 for that matter)?
>
> DBI comes with Oracle driver that can work with 9.2 at least.
>

Thanks. Would that be the Ruby9i driver (by Jim Cain)?

Afaik the dbd_oracle driver supports "old" Oracle DBs (<=8) and the
dbd_oci8 is only verified for 9.0.1 (according to the webpage).

This would allow me to access Oracle 9.2, but I'm still looking for a
way to connect to 10g :)

Best Regards //Anders

--
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Anders Engström aengstrom@gnejs.net
http://www... PGP-Key: ED010E7F
[Your mind is like an umbrella. It doesn't work unless you open it.]




Alexey Verkhovsky

10/28/2004 9:49:00 PM

0

On Fri, 2004-10-29 at 00:30, Anders Engström wrote:

> Thanks. Would that be the Ruby9i driver (by Jim Cain)?
I think what I use is dbd_oci8. Don't remember exactly, I'm not in the
office right now. At least, I do have something that I installed few
months ago and that allows me to talk to Oracle 9.2 via DBI :)

> This would allow me to access Oracle 9.2, but I'm still looking for a
> way to connect to 10g :)
Is it not backwards-compatible as far as clients are concerned?

Alex

Anders Engström

10/28/2004 11:35:00 PM

0

On Fri, Oct 29, 2004 at 06:49:09AM +0900, Alexey Verkhovsky wrote:
> On Fri, 2004-10-29 at 00:30, Anders Engström wrote:
>
> > Thanks. Would that be the Ruby9i driver (by Jim Cain)?

> I think what I use is dbd_oci8. Don't remember exactly, I'm not in the
> office right now. At least, I do have something that I installed few
> months ago and that allows me to talk to Oracle 9.2 via DBI :)

Coo.. I'll have to give the oci8 driver a try :)


> > This would allow me to access Oracle 9.2, but I'm still looking for a
> > way to connect to 10g :)

> Is it not backwards-compatible as far as clients are concerned?

Not sure... I guess I'll have to check that. But - if the API is
anything similar to the API the JDBC-drivers (thin and oci) uses then
it's *not* backwards-compatible in any way :/

Any practical experience with Oracle 10g and Ruby out there?

//Anders


--
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Anders Engström aengstrom@gnejs.net
http://www... PGP-Key: ED010E7F
[Your mind is like an umbrella. It doesn't work unless you open it.]




Ollivier Robert

10/29/2004 7:51:00 AM

0

On Fri, 29 Oct 2004 09:35:23 +0900, Anders Engström wrote:
> Coo.. I'll have to give the oci8 driver a try :)

I use 10g and Ruby/dbi/oci8 everyday on my MacOSX so I can guarantee it
works fine :-)

> Any practical experience with Oracle 10g and Ruby out there?

No problem.

Anders Engström

10/29/2004 9:45:00 AM

0

On Fri, Oct 29, 2004 at 04:54:08PM +0900, Ollivier Robert wrote:
> On Fri, 29 Oct 2004 09:35:23 +0900, Anders Engström wrote:
> > Coo.. I'll have to give the oci8 driver a try :)
>
> I use 10g and Ruby/dbi/oci8 everyday on my MacOSX so I can guarantee it
> works fine :-)
>

That's great news! I suppose that means that the information on
http://ruby-dbi.source... and
http://www.jiubao.org/ruby-oci8/ind... should be updated to
include support for 10g as well ('case the authors of those pages are
reading this :).

Best Regards //Anders

--
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Anders Engström aengstrom@gnejs.net
http://www... PGP-Key: ED010E7F
[Your mind is like an umbrella. It doesn't work unless you open it.]