Thursday, July 31, 2008

Apache derby-client ij from a windows batch file

To connect ij to a derby-database from a windows batch script seems to be not too well documented, but it turns out to be extremely easy : you can set environment variables in advance. (I wanted to use the provided batch files for setting the classpath etc.)

@echo off

set DERBY_OPTS=-Dij.user=XXXXX -Dij.password=YYYYY -Dij.database=jdbc:derby://localhost/DATABASENAME

set DERBY_HOME=c:\Program Files\Sun\JavaDB\

"c:\Program Files\Sun\JavaDB\bin\ij.bat"

Labels: