Return-Path: Delivered-To: apmail-geronimo-dev-archive@www.apache.org Received: (qmail 33011 invoked from network); 18 Apr 2005 15:57:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Apr 2005 15:57:28 -0000 Received: (qmail 39659 invoked by uid 500); 18 Apr 2005 15:57:20 -0000 Delivered-To: apmail-geronimo-dev-archive@geronimo.apache.org Received: (qmail 39631 invoked by uid 500); 18 Apr 2005 15:57:19 -0000 Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: dev@geronimo.apache.org Delivered-To: mailing list dev@geronimo.apache.org Received: (qmail 39616 invoked by uid 99); 18 Apr 2005 15:57:19 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO mgd.gluecode.com) (64.14.202.141) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 18 Apr 2005 08:57:18 -0700 Received: from [192.168.17.100] ([192.168.17.100]) (authenticated bits=0) by mgd.gluecode.com (8.12.10/8.12.10) with ESMTP id j3IFv6CW025159 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NO) for ; Mon, 18 Apr 2005 08:57:07 -0700 Mime-Version: 1.0 (Apple Message framework v622) In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable From: Dain Sundstrom Subject: Re: Connecting to SystemDatabase and create table Date: Mon, 18 Apr 2005 08:57:12 -0700 To: dev@geronimo.apache.org X-Mailer: Apple Mail (2.622) X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Katia, This is great information. Can you add it to the wiki so others can=20 find it easily? Thanks, -dain -- Dain Sundstrom Chief Architect Gluecode Software On Apr 16, 2005, at 5:50 PM, Katia Aresti Gonzalez wrote: > Hello! > =A0 > To connect to the SystemDatabase, and be able to continue with the cmp=20= > deployment, just follow these steps: (Windows) > =A0 > 1=BA STEP =A0a folder with these 3=A0jars=A0inside: > =A0 > 1. db2jcc.jar > 2. db2jcc_license_c.jar > =A0 > you download from IBM site: > Derby does not currently provide a network JDBC driver, therefore you=20= > must download the IBM DB2 Universal Driver: > http://www-106.ibm.com/developerworks/db2/downloads/jcc/ > =A0 > 3. derbytools.jar > you get it from the=20 > http://incubator.apache.org/derby/derby_downloads.html. Just download=20= > derby, unzip, and there is the tool!!! > =A0 > 2=BA STEP: Create a derby.bat: > =A0 > set classpath=3D%the folder where you have the 3 jars% > java -cp=20 > derby.jar;derbynet.jar;derbytools.jar;db2jcc.jar;db2jcc_license_c.jar=A0= =20 > -Dij.driver=3Dcom.ibm.db2.jcc.DB2Driver -Dij.user=3Dsystem=20 > -Dij.password=3Dmanager -Dij.protocol=3Djdbc:derby:net://localhost:1527/= =20 > org.apache.derby.tools.ij > pause > =A0 > This derby.bat goes in the same folder where you have the jars. > =A0 > 3=BASTEP > =A0 > run the derby.bat, and if everything is ok, you will get in your=20 > command line: > ij> > =A0 > To connect to the SystemDatabase, Geronimo must be running!!! just=20 > type: > =A0 > ij> CONNECT 'jdbc:derby:net://localhost:1527/SystemDatabase'; > ij> create table gente (nombre varchar(50)); > 0 rows inserted/updated/deleted > thats all!!! > =A0 > thanks!! > =A0 > Katia > > Acepta el reto MSN Premium: Env=EDa hasta 500 megas diarios de fotos=20= > desde Hotmail. Desc=E1rgalo y pru=E9balo 2 meses gratis.=20=