You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by "Jean T. Anderson" <jt...@bristowhill.com> on 2005/02/18 21:37:53 UTC

jython + derby

Bob Gibson wrote a developerWorks article that shows how to connect to 
derby from jython:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0502gibson/

regards,

 -jean

Re: jython + derby AND DESCRIBE

Posted by Daniel John Debrunner <dj...@debrunners.com>.

Jean T. Anderson wrote:

> Bob Gibson wrote a developerWorks article that shows how to connect to
> derby from jython:
> 
> http://www.ibm.com/developerworks/db2/library/techarticle/dm-0502gibson/

Jython's zxJDBC package provides functionality similar to the DESCRIBE
requested on this list for ij.

|| cursor.tables(qualifier,owner,table,type)

|| Same as DatabaseMetaData.getTables

And there a number of commands that map to DatabaseMetaData methods.

http://www.jython.org/docs/zxjdbc.html

Possibly if Jython has existed when Cloudscape started, it would have
been picked at the SQL scripting tool. It would be interesting to see if
someone could add a jython test type to the Derby harness (or does it
exist in Junit?) and write Derby tests in Jython. Of course I don't know
if the Jython licence is compatible with the Apache licence.

Dan.