Quick start to acessing Oracle`

[Ross Parker]

I am looking at replacing Perl with Ruby. I like to use Perl for a lot of
db stuff and am most interested in get Ruby to talk to an Oracle database.
I have been poking around on the net looking for a quick start guide to
installing a Ruby lib for Oracle and have come up short.

Can anyone direct me to a quick start resource for accessing Oracle with
Ruby?

Thanks

 

[Jason Sweat]

I am looking at replacing Perl with Ruby. I like to use Perl for a lot of
db stuff and am most interested in get Ruby to talk to an Oracle database.
I have been poking around on the net looking for a quick start guide to
installing a Ruby lib for Oracle and have come up short.

Can anyone direct me to a quick start resource for accessing Oracle with
Ruby?

Hi Ross,

I have used this:
http://www.jiubao.org/ruby-oci8/
sucessfully to talk to Oracle 8.1.7 and 7.3.4 databases.

Regards,
Jason
http://blog.casey-sweat.us/

 

[Ross Parker]

Hi Ross,

I have used this:
http://www.jiubao.org/ruby-oci8/
sucessfully to talk to Oracle 8.1.7 and 7.3.4 databases.

Regards,
Jason
http://blog.casey-sweat.us/

Thanks! I found and installed the RubyBI module and am able to talk to
an Oracle database.

 

[Dan Janowski]

A word of caution, the OCI8 package is more capable than the older one.
It can be used direct or with its DBI. Among other things it handles
async calls to Oracle which coordinate with Ruby's threads very well.
Dan

 

[Jason Sweat]

Does anybody know how to make Ruby talk to Oracle on HPUX?

My Linux compiled Ruby talks to Oracle running on HPUX fine, but I
know that is not the question you are asking.

I have not yet deployed any application running Ruby, so I have not
yet tortured our Unix admin into compiling Ruby yet

Regards,
Jason
http://blog.casey-sweat.us/

 

[Pit Capitain]

A word of caution, the OCI8 package is more capable than the older one.
It can be used direct or with its DBI. Among other things it handles
async calls to Oracle which coordinate with Ruby's threads very well.

This interests me. What do you exactly mean by "async" calls?

Regards,
Pit

 

[Dan Janowski]

This interests me. What do you exactly mean by "async" calls?

Regards,
Pit

The OCI8 library can exec to Oracle in polling mode, i.e. the OCI call
does not block in the oracle layer. The ruby interface uses polling to
allow other ruby green threads to run. The only restriction is one
polled exec per connection to the database. For multiple query threads,
you must open a connection session for each query.

Dan

 

[Pit Capitain]

The OCI8 library can exec to Oracle in polling mode, i.e. the OCI call
does not block in the oracle layer. The ruby interface uses polling to
allow other ruby green threads to run. The only restriction is one
polled exec per connection to the database. For multiple query threads,
you must open a connection session for each query.

Thanks Dan, I had never heard of the polling mode. When reading about it
in the Oracle docs I also found a publish / subscribe mechanism, where
the client can be asynchronously notified of server events. Interesting
stuff! I wish it would be available in JDBC too, but it doesn't seem so.

Regards,
Pit