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


 

Forums >

comp.lang.ruby

What is the best way to interact with a JDBC database

Venks

12/3/2007 10:52:00 PM

Note: parts of this message were removed by the gateway to make it a legal Usenet post.

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
8 Answers

dan.macdaddy+ruby

12/3/2007 11:43:00 PM

0

Note: parts of this message were removed by the gateway to make it a legal Usenet post.

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 <venkatesh.mantha@gmail.com> 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
>

Venks

12/4/2007 12:57:00 AM

0

Note: parts of this message were removed by the gateway to make it a legal Usenet post.

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 <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.
>
>
> On Dec 4, 2007 9:21 AM, Venks <venkatesh.mantha@gmail.com> 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
> >
>

Thomas Enebo

12/4/2007 4:07:00 PM

0

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/Th...

Venks

12/4/2007 9:27:00 PM

0

Note: parts of this message were removed by the gateway to make it a legal Usenet post.

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/Th...
>
>
>

Thomas Enebo

12/4/2007 9:58:00 PM

0

Venks wrote:
> 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.
>
My main comment is that JRuby "is" Ruby in the sense that you can write
as much Ruby as you want and JRuby is capable of running it. So write
your app in Ruby and execute/run it in JRuby. We are meant to be a
drop-in alternative to Ruby.

So I would not think so much as things being a JRuby module or a Ruby
Module. The caveat to that last sentence is that in addition to being
able to run Ruby in JRuby you can also access/use Java classes from
within JRuby. So code in Ruby and bring in the Java classes you need
into your app (in this case JDBC) to do what you need in all your
databases. OR....

Install activerecord-JDBC gem and then use activerecord APIs to interact
with your databases. This does have one limitation that we only
support the more popular databases at this point. Less known ones will
not work (though we are looking for help in adding support to more
databases). The main benefit is that this will end up making your code
Java-free (behind the scenes our gem is using Java code, but it is
transparent to you).
> 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).
>

A question? When you say system calls to create data into files, do you
just mean using things like Ruby's File class? That is no problem if so.
> - 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.
>
I recommend just running your whole Ruby application in JRuby.
> - Once I am done with the Jruby module, I will continue further processing
> using regular Ruby modules.
>
> Does this makes sense?
>
> Thanks,
>
-Tom


--
Thomas E Enebo <thomas.enebo@sun.com>
JRuby Core Developer, http://www.bloglines.com/blog/Th...

Venks

12/4/2007 11:53:00 PM

0

Note: parts of this message were removed by the gateway to make it a legal Usenet post.

Hi,

- I am using the MySQL Driver which has one-to-one correspondence to "C"
API. I may need to have more control on how I access MySQL. It's my
understanding that Active record is based on DBI interface and has an
additional layer.
- The system calls I mentioned below are not File I/O. I am using the File
I/O class too. But the system calls I am referring is directly calling OS
commands as I use "sed, "gpg", "zip" and some other UNIX utilities.

Now here is question which I am sure you are not reading/listening for the
first time.

Are there any performance issues between Ruby and JRuby (I know this has
been asked many times but couldn't find any definitive answer/article)

Thanks,

On Dec 4, 2007 4:57 PM, Thomas Enebo <Thomas.Enebo@sun.com> wrote:

> Venks wrote:
> > 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.
> >
> My main comment is that JRuby "is" Ruby in the sense that you can write
> as much Ruby as you want and JRuby is capable of running it. So write
> your app in Ruby and execute/run it in JRuby. We are meant to be a
> drop-in alternative to Ruby.
>
> So I would not think so much as things being a JRuby module or a Ruby
> Module. The caveat to that last sentence is that in addition to being
> able to run Ruby in JRuby you can also access/use Java classes from
> within JRuby. So code in Ruby and bring in the Java classes you need
> into your app (in this case JDBC) to do what you need in all your
> databases. OR....
>
> Install activerecord-JDBC gem and then use activerecord APIs to interact
> with your databases. This does have one limitation that we only
> support the more popular databases at this point. Less known ones will
> not work (though we are looking for help in adding support to more
> databases). The main benefit is that this will end up making your code
> Java-free (behind the scenes our gem is using Java code, but it is
> transparent to you).
> > 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).
> >
>
> A question? When you say system calls to create data into files, do you
> just mean using things like Ruby's File class? That is no problem if so.
> > - 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.
> >
> I recommend just running your whole Ruby application in JRuby.
> > - Once I am done with the Jruby module, I will continue further
> processing
> > using regular Ruby modules.
> >
> > Does this makes sense?
> >
> > Thanks,
> >
> -Tom
>
>
> --
> Thomas E Enebo <thomas.enebo@sun.com>
> JRuby Core Developer, http://www.bloglines.com/blog/Th...
>
>
>

Ken Bloom

12/5/2007 5:46:00 AM

0

On Mon, 03 Dec 2007 17:51:59 -0500, Venks wrote:

> Note: parts of this message were removed by the gateway to make it a
> legal Usenet post.
>
> 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.

Well, if you're going to have Ruby call a Java program and you can't port
the whole thing over to JRuby, you should consider running a DRb server
in JRuby to access the database, and access that from a native ruby DRb
client. I think (hope) you should be able to expose the JDBC objects you
need having to code any special wrappers for them.

--Ken
(I have never programmed this kind of arrangement before, so I don't know
what JRuby can or can't do. This is just speculation.)

--
Ken (Chanoch) Bloom. PhD candidate. Linguistic Cognition Laboratory.
Department of Computer Science. Illinois Institute of Technology.
http://www.iit.edu...

Thomas Enebo

12/5/2007 5:36:00 PM

0

Venks wrote:
> Hi,
>
> - I am using the MySQL Driver which has one-to-one correspondence to "C"
> API. I may need to have more control on how I access MySQL. It's my
> understanding that Active record is based on DBI interface and has an
> additional layer.
>
Well the issue with using the MySQL Driver is that it requires a native
C extension to work. Currently, JRuby does not support C extensions.
Your code will either have to use the pure Ruby MySQL driver (not very
fast) or start using JDBC directly. So this unfortunately will require
extra work.
> - The system calls I mentioned below are not File I/O. I am using the File
> I/O class too. But the system calls I am referring is directly calling OS
> commands as I use "sed, "gpg", "zip" and some other UNIX utilities.
>
We can call out using system and friends. I think there is a couple of
bugs with bi-directional communication using popen, but I suspect things
will work for you here.
> Now here is question which I am sure you are not reading/listening for the
> first time.
>
> Are there any performance issues between Ruby and JRuby (I know this has
> been asked many times but couldn't find any definitive answer/article)
>
No real performance issues. We have a few bottlenecks which could
surface, but we are faster in many areas and slower in some others. All
in all our performance is looking really good.

-Tom
> Thanks,
>
> On Dec 4, 2007 4:57 PM, Thomas Enebo <Thomas.Enebo@sun.com> wrote:
>
>
>> Venks wrote:
>>
>>> 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.
>>>
>>>
>> My main comment is that JRuby "is" Ruby in the sense that you can write
>> as much Ruby as you want and JRuby is capable of running it. So write
>> your app in Ruby and execute/run it in JRuby. We are meant to be a
>> drop-in alternative to Ruby.
>>
>> So I would not think so much as things being a JRuby module or a Ruby
>> Module. The caveat to that last sentence is that in addition to being
>> able to run Ruby in JRuby you can also access/use Java classes from
>> within JRuby. So code in Ruby and bring in the Java classes you need
>> into your app (in this case JDBC) to do what you need in all your
>> databases. OR....
>>
>> Install activerecord-JDBC gem and then use activerecord APIs to interact
>> with your databases. This does have one limitation that we only
>> support the more popular databases at this point. Less known ones will
>> not work (though we are looking for help in adding support to more
>> databases). The main benefit is that this will end up making your code
>> Java-free (behind the scenes our gem is using Java code, but it is
>> transparent to you).
>>
>>> 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).
>>>
>>>
>> A question? When you say system calls to create data into files, do you
>> just mean using things like Ruby's File class? That is no problem if so.
>>
>>> - 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.
>>>
>>>
>> I recommend just running your whole Ruby application in JRuby.
>>
>>> - Once I am done with the Jruby module, I will continue further
>>>
>> processing
>>
>>> using regular Ruby modules.
>>>
>>> Does this makes sense?
>>>
>>> Thanks,
>>>
>>>
>> -Tom
>>
>>
>> --
>> Thomas E Enebo <thomas.enebo@sun.com>
>> JRuby Core Developer, http://www.bloglines.com/blog/Th...
>>
>>
>>
>>
>
>


--
--
Thomas E Enebo <thomas.enebo@sun.com>
JRuby Core Developer, http://www.bloglines.com/blog/Th...