From: Deepak Vohra <dvohra09@...>
Date: 2007-12-04T10:56:19+09:00
Subject: Re: What is the best way to interact with a JDBC database

--0-400952326-1196733382=:36874
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Instead of the MySQL JDBC driver use the MonetDB JDBC driver.
  http://monetdb.cwi.nl/projects/monetdb//XQuery/Documentation/The-JDBC-Library.html
http://rubylearning.com/blog/2007/05/05/connect-jruby-to-mysql-using-jdbc/
  
Venks <venkatesh.mantha@gmail.com> 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.


On Dec 3, 2007 6:43 PM, Dan 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.
>
>
> On Dec 4, 2007 9:21 AM, Venks wrote:
>
> > Hi,
> >
> > I have a database that has only JDBC connectivity but I need to interact
> > to
> > this database from Ruby. What's the best way to do so? All ideas and
> > suggestions are welcome.
> >
> > My initial thought is to create a Java program that accepts connection
> > information and a SQL statement and execute the SQL against the
> database.
> > Assuming that I have this program, what's the best way to call this Java
> > program from Ruby?
> >
> > I looked at JRuby and didn't feel that's the right answer.
> >
> > Regards,
> >
> > -Venks
> >
>


--0-400952326-1196733382=:36874--