db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Using Derby with ISQL-Viewer
Date Fri, 03 Dec 2004 20:31:36 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I'm having trouble to set up a Derby service in ISQL viewer, has someone
> already done that and could explain me how to do it?
>
> thanks
>
> Wellington Bengtson

I've been running iSQL-Viewer 2.1.8 with the proposed release for Derby
successfully.

It's a really nice tool, the meta-date browsing is powerful and the
query window
with results work well. The data editor seems to have problems with
Derby due to
Derby not supporting updateable result sets.

To get it working with embedded Derby, you must put the derby.jar file
in the system classpath of the JVM that is running iSQL-Viewer. I'd
installed on windows and to set this up I edited the iSQL-Viewer.lax
file, adding the Derby jar file to the lax.class.path property.

E.g.

lax.class.path=bsf.jar;jpython1.1.jar;isql-core.jar;mozilla-rhino.jar;lax.jar;c:/cs/incubating-derby-10.0.2.1-lib/lib/derby.jar

Then start up iSQL-Viewer and hit F3 to go to the services manager.
Click the third icon 'Create new isql service'
Enter
	some useful name for 'Connection name'
	org.apache.derby.jdbc.EmbeddedDriver as the driver name
	jdbc:derby:dbname as the JDBC URL, replace dbname with path to your
database, or use a new database name and include ;create=true

Set up the authentication to match your database

Do not add anything in the resources tab

Click test to see if a connection can be made.

Click Save/apply and then ok.

Then in the main view click 'services' and select the service just
created. In the bottom window you should see messages indicating a
successful connection.

It should be now ready to use.

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBsM0oIv0S4qsbfuQRAkZiAKCWBx34ozsRQmg4rGjWiAP/To6ZhwCgpKLy
OKd5i41KiDCasVWI+tRVNp0=
=2dJm
-----END PGP SIGNATURE-----


Mime
View raw message