YAJB and JDBC?

Hi all,

I’m tinkering with Yet Another Java Bridge
(Software Error)
and a JDBC driver. I’m wondering if anyone has tried this and might
have a few examples laying around?

btw, YAJB works very nicely so far. :slight_smile:

Much thanks!

Jared
http://jaredrichardson.net

[email protected] wrote:

Jared
http://jaredrichardson.net

I’m getting there… here’s a working example.

require ‘yajb/jbridge’

JBRIDGE_OPTIONS = { :classpath =>
“/Users/jared/work/hypersonic/tinkering/lib/hsqldb.jar”}

include JavaBridge

jimport “java.sql."
jimport "org.hsqldb.

class_instance = jstatic Class
class_instance.forName(“org.hsqldb.jdbcDriver” )

driver_manager = jstatic :DriverManager
conn = driver_manager.getConnection(“jdbc:hsqldb:file:testdb”, “sa”,
“”)
statement = conn.createStatement

statement.executeUpdate(“CREATE TABLE child(c1 INTEGER, c2 VARCHAR)”)

On Sep 1, 2006, at 6:15 AM, [email protected] wrote:

I’m tinkering with Yet Another Java Bridge
(Software Error?
page=YAJB)
and a JDBC driver. I’m wondering if anyone has tried this and might
have a few examples laying around?

btw, YAJB works very nicely so far. :slight_smile:

Did you try rjb at all? I’d be interested to know how they compare.