geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <>
Subject [Geronimo Wiki] Update of "Database Configuration" by JohnSisson
Date Wed, 20 Apr 2005 02:32:18 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Geronimo Wiki" for change notification.

The following page has been changed by JohnSisson:

The comment on the change is:
info on obtaining the derby tools.jar file

  java -jar bin/deployer.jar deploy mydatabase-plan.xml \
+ Note: The `repository/geronimo/rars/geronimo-derby-connector-1.0-SNAPSHOT.rar` file did
not exist in the M3 build.
  Sample database plan file:
@@ -71, +73 @@

  The following DB2 Universal Driver JARs need to be on your classpath:
    * db2jcc.jar
    * db2jcc_license_c.jar
+ Currently Geronimo doesn't include the derbytools JAR file that contains the `ij` utility
[].  So download the file []
into the `geronimo/repository/incubator-derby/jars` directory.
- To create a database using Derby's ij tool do something like the following (example for
+ Assuming you are in the `geronimo` root directory, create a database using Derby's ij tool
(UNIX example):
- java -cp derby.jar;derbynet.jar;derbytools.jar;db2jcc.jar;db2jcc_license_c.jar
-Dij.user=MYAPP -Dij.password=myappPassword -Dij.protocol=jdbc:derby:net://localhost:1527/
+ java -cp db2jcc.jar:db2jcc_license_c.jar:\
+          repository/incubator-derby/jars/derby-\
+          repository/incubator-derby/jars/derbynet-
+          repository/incubator-derby/jars/derbytools- \
+ -Dij.user=MYAPP \ 
+      -Dij.password=myappPassword -Dij.protocol=jdbc:derby:net://localhost:1527/
  ij version 10.0 (C) Copyright IBM Corp. 1997, 2004.
  ij> connect 'MYDB;create=true';
  ij> CREATE TABLE products(name CHAR(30), price INTEGER);

View raw message