Re: What is the best way to interact with a JDBC database



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

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@xxxxxxxxx> 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




.



Relevant Pages

  • Re: What is the best way to interact with a JDBC database
    ... Use JRuby with JDBC driver. ... Venks wrote: Hi, ... I have a database that has only JDBC connectivity but I need to interact ... I looked at JRuby and didn't feel that's the right answer. ...
    (comp.lang.ruby)
  • Re: Error when binding value to prepared statement with SQL Server 2005
    ... Database version is 9.0.1399 ... > Arto Basmadjian wrote: ... >> I'm using the latest jdbc driver to connect to an Sql Express ...
    (microsoft.public.sqlserver.jdbcdriver)
  • applet + database
    ... I'm planning to write a simple applet to display database records. ... Am I correct in guessing I need to dl the J2SE 1.4.2 package? ... It seems that I need a JDBC driver for whichever database I ... The JDBC code is copied to the client ...
    (comp.lang.java.programmer)
  • Callablestatement.execute() and clearParameter() causing exception
    ... With SQL 2005 jdbc driver i connect to 2005 database using parameter ... A server cursor cannot be ... The same code when run against a MSSQL 2000 database, ... on a remote stored procedure or stored procedure with more than one SELECT ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: PreparedStatement
    ... It actually depends upon what JDBC driver ... But the "generic database access" class I am using to insert data to the ... to insert Strings into numeric fields (as long as the Strings are numbers, ...
    (comp.lang.java.help)