geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dain Sundstrom <dsundst...@gluecode.com>
Subject Re: Connecting to SystemDatabase and create table
Date Wed, 20 Apr 2005 16:06:10 GMT
Just go here http://wiki.apache.org/geronimo, create an account, and  
then you can edit the wiki.  The wiki contains help information on how  
to add new pages, format pages, and so on.

-dain

--
Dain Sundstrom
Chief Architect
Gluecode Software

On Apr 19, 2005, at 12:32 PM, Katia Aresti Gonzalez wrote:

> I dont know how to do it :-(
>
> >From: Dain Sundstrom <dsundstrom@gluecode.com>
> >Reply-To: dev@geronimo.apache.org
> >To: dev@geronimo.apache.org
> >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. Introduce tu CV en MSN  
> Empleo. 

Mime
View raw message