Return-Path: Delivered-To: apmail-db-jdo-dev-archive@www.apache.org Received: (qmail 25815 invoked from network); 4 Sep 2005 23:53:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Sep 2005 23:53:06 -0000 Received: (qmail 46652 invoked by uid 500); 4 Sep 2005 23:53:05 -0000 Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-dev@db.apache.org Received: (qmail 46639 invoked by uid 99); 4 Sep 2005 23:53:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Sep 2005 16:53:05 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of jta@bristowhill.com designates 66.75.162.135 as permitted sender) Received: from [66.75.162.135] (HELO ms-smtp-03-eri0.socal.rr.com) (66.75.162.135) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Sep 2005 16:53:18 -0700 Received: from [192.168.15.53] (cpe-204-210-23-212.san.res.rr.com [204.210.23.212]) by ms-smtp-03-eri0.socal.rr.com (8.12.10/8.12.7) with ESMTP id j84Nr1gQ026736 for ; Sun, 4 Sep 2005 16:53:01 -0700 (PDT) Message-ID: <431B88DC.7090307@bristowhill.com> Date: Sun, 04 Sep 2005 16:53:00 -0700 From: "Jean T. Anderson" User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: jdo-dev@db.apache.org Subject: Re: derby schema References: <431B6F58.4090006@gmail.com> <57343B1C-2C07-4A80-BE77-74B890AAC047@Sun.COM> In-Reply-To: <57343B1C-2C07-4A80-BE77-74B890AAC047@Sun.COM> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Craig Russell wrote: > Hi Karan, > > On Sep 4, 2005, at 3:04 PM, karan malhi wrote: > >> How can i view the derby schema? > > > I use vi. The schema files (there are ten of them) are in directory > test/sql/derby/{application}|{datastore}identity/schema*.sql If you don't have schema files readily available, the derby dblook tool dumps the schema for a given database. More info is at http://db.apache.org/derby/docs/10.1/tools/ctoolsdblook.html . Derby doesn't have any GUI tools, but a few that (seem to) work are documented at http://db.apache.org/derby/integrate/misc.html . In particular, I keep hearing really good things about SQuirreL SQL from http://squirrel-sql.sourceforge.net/ . If you decide to look at this, grab the new jar they made available that fixes a derby problem; see http://sourceforge.net/mailarchive/forum.php?thread_id=7611732&forum_id=3116 . -jean