Re: [tcljava-dev] Jacl and JDBC

[Christian K. <chr...@so...>]

Hello,

> Before I start working from scratch on a JDBC interface in Jacl, has anyone
> done any work on something like this already? I couldn't find anything...

I once did.

But then I noticed that TclJava gives you everything at hand,
what you need to use JDBC in Tcl. No need for an extra interface.
You can access all and everything of JDBC almost as easy as from
inside Java. I hope the following lines will be a proof of this.

    package require java
    java::import -package java.sql DriverManager
    java::call Class forName "de.sag.jdbc.adabasd.ADriver"
    set logon [java::call DriverManager getConnection \
                    "jdbc:adabasd://$servernode/$serverdb" \
                    $account $password]
    set stmt [$logon createStatement]
    set res  [$stmt executeQuery "select date datum, user benutzer from dual"]
    $res next
    set out1 [$res {getString int} 1]
    set out2 [$res {getString int} 2]


Greetings, Krischan
-- 
Christian Krone