I dont know how to do it :-(
>From: Dain Sundstrom <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: Connecting to SystemDatabase and create table
>Date: Mon, 18 Apr 2005 08:57:12 -0700
>
>Katia,
>
>This is great information. Can you add it to the wiki so others
>can find it easily?
>
>Thanks,
>
>-dain
>
>--
>Dain Sundstrom
>Chief Architect
>Gluecode Software
>On Apr 16, 2005, at 5:50 PM, 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.
Recibe ofertas de empleo adaptadas a tu perfil.
