geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Katia Aresti Gonzalez" <kaare...@hotmail.com>
Subject Connecting to SystemDatabase and create table
Date Sun, 17 Apr 2005 00:50:26 GMT
<html><div style='background-color:'><DIV class=RTE>Hello!</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>To connect to the SystemDatabase, and be able to continue with the cmp
deployment, just follow these steps: (Windows)</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>1º STEP &nbsp;a folder with these 3&nbsp;jars&nbsp;inside:</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>1. db2jcc.jar<BR>2. db2jcc_license_c.jar</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>you download from IBM site:</DIV>
<DIV class=RTE>Derby does not currently provide a network JDBC driver, therefore you
must download the IBM DB2 Universal Driver:<BR><A href="http://www-106.ibm.com/developerworks/db2/downloads/jcc/">http://www-106.ibm.com/developerworks/db2/downloads/jcc/</A></DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>
<DIV class=RTE>3. derbytools.jar</DIV>
<DIV class=RTE>you get it from the <A href="http://incubator.apache.org/derby/derby_downloads.html">http://incubator.apache.org/derby/derby_downloads.html</A>.
Just download derby, unzip, and there is the tool!!!</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>2º STEP: Create a derby.bat:</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>set classpath=%the folder where you have the 3 jars%</DIV>
<DIV class=RTE>java -cp derby.jar;derbynet.jar;derbytools.jar;db2jcc.jar;db2jcc_license_c.jar&nbsp;
-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</DIV>
<DIV class=RTE>pause</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>This derby.bat goes in the same folder where you have the jars.</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>3ºSTEP</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>run the derby.bat, and if everything is ok, you will get in your command
line:</DIV>
<DIV class=RTE>ij&gt;</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>To connect to the SystemDatabase, Geronimo must be running!!! just type:</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>ij&gt; CONNECT 'jdbc:derby:net://localhost:1527/SystemDatabase';<BR>ij&gt;
create table gente (nombre varchar(50));<BR>0 rows inserted/updated/deleted<BR></DIV>
<DIV class=RTE>thats all!!!</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>thanks!!</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Katia</DIV></DIV></div><br clear=all><hr>Acepta
el reto MSN Premium: Envía hasta 500 megas diarios de fotos desde Hotmail. <a href="http://g.msn.com/8HMAESES/2743??PS=47575"
target="_top">Descárgalo y pruébalo 2 meses gratis.</a> </html>


Mime
View raw message