From: Venks <venkatesh.mantha@...>
Date: 2007-12-05T06:26:51+09:00
Subject: Re: What is the best way to interact with a JDBC database

------=_Part_13089_12024645.1196803594174
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I don't know if any classes are missing. I was just reading the
documentation that suggested that all the classes may not be
available. Also, I have not used JRuby yet (As a matter of fact I am new to
Ruby let alone developing in a OO language environment)

Thanks for all the feedback. I was thinking whether SOAP may be an option,
but could be over kill just for bridging the gap between Ruby and Java.

I will try to use Jruby to access the JDBC database. Please allow me to
specify in few steps to describe the overall picture of my batch job:

- I have a bunch of Ruby modules that access many MySQL databases across
several machines.
- I also have lot of System calls to create data into files which I then I
transfer between different databases (not just MySQL).
- Somewhere in this process I need to invoke a method from a module that's
developed using JRuby.
- When I invoke the JRuby module, I except the Java environment to be
active, otherwise I don't need JVM.
- Once I am done with the Jruby module, I will continue further processing
using regular Ruby modules.

Does this makes sense?

Thanks,


On Dec 4, 2007 11:07 AM, Thomas Enebo <Thomas.Enebo@sun.com> wrote:

> Venks wrote:
> > Actually, I haven't tried Jruby except reading about it. I am using Ruby
> as
> > a glue to put together all the tasks I need including Database access,
> File
> > I/O and all the stuff that comes with a heavy duty batch programming.
> It's
> > my understanding that JRuby doesn't provide all the classes and I would
> like
> > to avoid using JRuby just for this requirement of accessing a JDBC
> database.
> >
> >
> Out of personal interest...Which classes are missing for you in JRuby?
> We have an interest in filling in gaps in our implementation.
>
> -Tom
>
> > On Dec 3, 2007 6:43 PM, Dan <dan.macdaddy+ruby@gmail.com> wrote:
> >
> >
> >> Just out of interest, what was your problem with JRuby?
> >>
> >> I had a similar issue with an Oracle RDB database running on VMS that
> only
> >> has .NET (beta) and JDBC drivers. So I went with JRuby using
> >> activerecord-jdbc and it has been working rather well for me. A few
> minor
> >> issues here and there, but nothing major.
> >>
> >>
> >>
> --
> Thomas E Enebo <thomas.enebo@sun.com>
> JRuby Core Developer, http://www.bloglines.com/blog/ThomasEEnebo
>
>
>

------=_Part_13089_12024645.1196803594174--