Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of j.whitt@insightbb.com
 designates 74.128.0.75 as permitted sender)
Subject: Re: Derby Files
From: john <j.whitt@insightbb.com>
Reply-To: j.whitt@insightbb.com
To: Camilla.Haase@Sun.COM
Cc: Derby Discussion <derby-user@db.apache.org>
In-Reply-To: <4769439A.5060101@Sun.COM>
References: <855367e60712161455t24e3a26flcafa97a961d5affa@mail.gmail.com>
	 <x1o3lk7t64jf.fsf@sun.com>
	 <fa14d5020712170921o749b10bfl6ebc78164c53f788@mail.gmail.com>
	 <1198028247.10932.6.camel@localhost.localdomain> <4769439A.5060101@Sun.COM>
Content-Type: text/plain
Organization: HOME
Date: Wed, 19 Dec 2007 23:16:21 -0500
Message-Id: <1198124181.10932.15.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

Thanks. Just what I needed.
I had tried to use the information on the Sun Website but it did not
work.

I have already created the tutorial database but could not find exactly
how it is done.

In the Ant script.


On Wed, 2007-12-19 at 11:15 -0500, Kim Haase wrote:
> Hi,
> 
> If you're using NetBeans, the home directory for all the databases is 
> your .netbeans-derby directory, which is in your home directory (the 
> location of which varies depending if you're on Windows or a UNIX system).
> 
> If you're not using NetBeans, the databases are created in the 
> Application Server's databases directory -- c:\Sun\AppServer\databases, 
> $HOME/SUNWappserver/databases, etc. The location for DERBY_HOME would be 
> $HOME/SUNWappserver/javadb or the equivalent, and the Derby/Java DB jars 
> would be in $HOME/SUNWappserver/javadb/lib or the equivalent.
> 
> The name of the database for all the Java EE Tutorial examples is 
> sun-appserv-samples. To learn the table names, see the file 
> javaeetutorial5/examples/common/sql/javadb/tutorial.sql.
> 
> For example, to see the bookstore database after you've run "ant 
> create-tables", you could do the following (on a UNIX system):
> 
> java -jar $DERBY_HOME/lib/derbyrun.jar ij
> ij version 10.3
> ij> connect 'jdbc:derby://localhost:1527/sun-appserv-samples';
> ij> select * from WEB_BOOKSTORE_BOOKS;
> BOOKID  |SURNAME                 |FIRSTNAME               |TITLE 
>  
>              |PRICE                 |ONSALE|CALENDAR_Y&|DESCRIPTION 
>                |INVENTORY
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 201     |Duke                    |                        |My Early 
> Years: Growing up on *7 
>                 |30.75                 |0     |1995       |What a cool 
> book.             |20
> 202     |Jeeves                  |                        |Web Servers 
> for Fun and Profit 
>              |40.75                 |1     |2000       |What a cool 
> book.             |20
> 203     |Masterson               |Webster                 |Web 
> Components for Web Developers 
>                      |27.75                 |0     |2000       |What a 
> cool book.             |20
> 205     |Novation                |Kevin                   |From Oak to 
> Java: The Revolution of a Language 
>              |10.75                 |1     |1998       |What a cool 
> book.             |20
> 206     |Gosling                 |James                   |Java 
> Intermediate Bytecodes 
>                     |30.95                 |1     |2000       |What a 
> cool book.             |20
> 207     |Thrilled                |Ben                     |The Green 
> Project: Programming for Consumer Devices 
>                |30.0                  |1     |1998       |What a cool 
> book              |20
> 208     |Tru                     |Itzal                   |Duke: A 
> Biography of the Java Evangelist 
>                  |45.0                  |0     |2001       |What a cool 
> book.             |20
> 
> 7 rows selected
> ij>
> 
> Hope this helps.
> 
> Kim Haase
> 
> john wrote:
> > I ran the Duke Bookstore bookstore1 example. Where, etc in which folder,
> > does Derby Store the data files for this example..
> > 
> > I have figured out how to run the ij utility. What is the name of the
> > Derby database I need to connect to to query to tables?
> >