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