geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Katia Aresti Gonzalez" <kaare...@hotmail.com>
Subject Re: Connecting to SystemDatabase and create table
Date Tue, 19 Apr 2005 19:32:06 GMT
<html><div style='background-color:'><DIV class=RTE>
<P>I dont know how to do it :-(<BR><BR></P></DIV>
<DIV></DIV>&gt;From: Dain Sundstrom &lt;dsundstrom@gluecode.com&gt;
<DIV></DIV>&gt;Reply-To: dev@geronimo.apache.org
<DIV></DIV>&gt;To: dev@geronimo.apache.org
<DIV></DIV>&gt;Subject: Re: Connecting to SystemDatabase and create table
<DIV></DIV>&gt;Date: Mon, 18 Apr 2005 08:57:12 -0700
<DIV></DIV>&gt;
<DIV></DIV>&gt;Katia,
<DIV></DIV>&gt;
<DIV></DIV>&gt;This is great information.&nbsp;&nbsp; Can you add
it to the wiki so others
<DIV></DIV>&gt;can find it easily?
<DIV></DIV>&gt;
<DIV></DIV>&gt;Thanks,
<DIV></DIV>&gt;
<DIV></DIV>&gt;-dain
<DIV></DIV>&gt;
<DIV></DIV>&gt;--
<DIV></DIV>&gt;Dain Sundstrom
<DIV></DIV>&gt;Chief Architect
<DIV></DIV>&gt;Gluecode Software
<DIV></DIV>&gt;On Apr 16, 2005, at 5:50 PM, Katia Aresti Gonzalez wrote:
<DIV></DIV>&gt;
<DIV></DIV>&gt;&gt;Hello!
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;To connect to the SystemDatabase, and be able to continue
with the
<DIV></DIV>&gt;&gt;cmp deployment, just follow these steps: (Windows)
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;1º STEP &nbsp;a folder with these 3&nbsp;jars&nbsp;inside:
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;1. db2jcc.jar
<DIV></DIV>&gt;&gt;2. db2jcc_license_c.jar
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;you download from IBM site:
<DIV></DIV>&gt;&gt;Derby does not currently provide a network JDBC driver,
therefore
<DIV></DIV>&gt;&gt;you must download the IBM DB2 Universal Driver:
<DIV></DIV>&gt;&gt;http://www-106.ibm.com/developerworks/db2/downloads/jcc/
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;3. derbytools.jar
<DIV></DIV>&gt;&gt;you get it from the
<DIV></DIV>&gt;&gt;http://incubator.apache.org/derby/derby_downloads.html.
Just
<DIV></DIV>&gt;&gt;download derby, unzip, and there is the tool!!!
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;2º STEP: Create a derby.bat:
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;set classpath=%the folder where you have the 3 jars%
<DIV></DIV>&gt;&gt;java -cp
<DIV></DIV>&gt;&gt;derby.jar;derbynet.jar;derbytools.jar;db2jcc.jar;db2jcc_license_c.jar&nbsp;
<DIV></DIV>&gt;&gt;-Dij.driver=com.ibm.db2.jcc.DB2Driver -Dij.user=system
<DIV></DIV>&gt;&gt;-Dij.password=manager
<DIV></DIV>&gt;&gt;-Dij.protocol=jdbc:derby:net://localhost:1527/
<DIV></DIV>&gt;&gt;org.apache.derby.tools.ij
<DIV></DIV>&gt;&gt;pause
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;This derby.bat goes in the same folder where you have
the jars.
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;3ºSTEP
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;run the derby.bat, and if everything is ok, you will
get in your
<DIV></DIV>&gt;&gt;command line:
<DIV></DIV>&gt;&gt;ij&gt;
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;To connect to the SystemDatabase, Geronimo must be
running!!! just
<DIV></DIV>&gt;&gt;type:
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;ij&gt; CONNECT 'jdbc:derby:net://localhost:1527/SystemDatabase';
<DIV></DIV>&gt;&gt;ij&gt; create table gente (nombre varchar(50));
<DIV></DIV>&gt;&gt;0 rows inserted/updated/deleted
<DIV></DIV>&gt;&gt;thats all!!!
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;thanks!!
<DIV></DIV>&gt;&gt;&nbsp;
<DIV></DIV>&gt;&gt;Katia
<DIV></DIV>&gt;&gt;
<DIV></DIV>&gt;&gt;Acepta el reto MSN Premium: Envía hasta 500 megas
diarios de fotos
<DIV></DIV>&gt;&gt;desde Hotmail. Descárgalo y pruébalo 2 meses gratis.
<DIV></DIV></div><br clear=all><hr>Recibe ofertas de empleo
adaptadas a tu perfil. <a href="http://g.msn.com/8HMAESES/2752??PS=47575" target="_top">Introduce
tu CV en MSN Empleo.</a> </html>


Mime
View raw message