Jeremy is right. To create the table, yo cant do it if you are not in the same dir of geronimo, with the server shut down and including as well derby.jar. And to connect, using the command below.

It seems that connects in the way i said before, but not really... I dont know what happens, anyway, follow jeremy`s way and mine togheter :-)

bye bye

>From: Jeremy Boynes <jboynes@apache.org>
>Reply-To: user@geronimo.apache.org
>To: user@geronimo.apache.org
>Subject: Re: Connecting to SystemDatabase and create table
>Date: Sat, 16 Apr 2005 18:57:37 -0700
>You can also shut down the server and run ij pointing directly at
>the database by setting derby.system.home appropriately
>java -cp derbytools.jar;derby.jar -Dderby.system.home=var/derby
>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.
>Katia Aresti Gonzalez wrote:
>>  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:
>>  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
>>  -Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.user=system
>>  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:
>>  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.

Encuentra una aventura, un romance o al amor de tu vida. Date de alta gratis.