java -cp derbytools.jar;derby.jar -Dderby.system.home=var/derby org.apache.derby.tools.ij
ij> connect 'jdbc:derby:SystemDatabase';
FWIW IBM just donated the client side driver to Apache so I would anticipate it being included in the next release.
-- Jeremy
Katia Aresti Gonzalez wrote:
Hello!
To connect to the SystemDatabase, and be able to continue with the cmp deployment, just follow these steps: (Windows)
1º STEP a folder with these 3 jars inside:
1. db2jcc.jar
2. db2jcc_license_c.jar
you download from IBM site:
Derby does not currently provide a network JDBC driver, therefore you must download the IBM DB2 Universal Driver:
http://www-106.ibm.com/developerworks/db2/downloads/jcc/
3. derbytools.jar
you get it from the http://incubator.apache.org/derby/derby_downloads.html. Just download derby, unzip, and there is the tool!!!
2º STEP: Create a derby.bat:
set classpath=%the folder where you have the 3 jars%
java -cp derby.jar;derbynet.jar;derbytools.jar;db2jcc.jar;db2jcc_license_c.jar -Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.user=system -Dij.password=manager -Dij.protocol=jdbc:derby:net://localhost:1527/ org.apache.derby.tools.ij
pause
This derby.bat goes in the same folder where you have the jars.
3ºSTEP
run the derby.bat, and if everything is ok, you will get in your command line:
ij>
To connect to the SystemDatabase, Geronimo must be running!!! just type:
ij> CONNECT 'jdbc:derby:net://localhost:1527/SystemDatabase';
ij> create table gente (nombre varchar(50));
0 rows inserted/updated/deleted
thats all!!!
thanks!!
Katia
--------------------------------------------------------------------------------
Acepta el reto MSN Premium: Envía hasta 500 megas diarios de fotos desde Hotmail. Descárgalo y pruébalo 2 meses gratis. <http://g.msn.com/8HMAESES/2743??PS=47575>
