Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 69433 invoked from network); 25 Sep 2006 11:53:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Sep 2006 11:53:36 -0000 Received: (qmail 33381 invoked by uid 500); 25 Sep 2006 11:53:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 33355 invoked by uid 500); 25 Sep 2006 11:53:33 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 33344 invoked by uid 99); 25 Sep 2006 11:53:33 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Sep 2006 04:53:33 -0700 Authentication-Results: idunn.apache.osuosl.org smtp.mail=John.Embretsen@Sun.COM; spf=permerror X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests= Received-SPF: error (idunn.apache.osuosl.org: domain Sun.COM from 192.18.1.36 cause and error) Received: from [192.18.1.36] ([192.18.1.36:1363] helo=gmp-ea-fw-1.sun.com) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id F6/84-13750-F23C7154 for ; Mon, 25 Sep 2006 04:53:20 -0700 Received: from d1-emea-09.sun.com ([192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k8PBrG62018742 for ; Mon, 25 Sep 2006 12:53:16 +0100 (BST) Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0J6500B01CV3ZD00@d1-emea-09.sun.com> (original mail from John.Embretsen@Sun.COM) for derby-user@db.apache.org; Mon, 25 Sep 2006 12:53:16 +0100 (BST) Received: from [129.159.112.236] by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0J6500DK7D0RE9XB@d1-emea-09.sun.com> for derby-user@db.apache.org; Mon, 25 Sep 2006 12:53:16 +0100 (BST) Date: Mon, 25 Sep 2006 13:51:53 +0200 From: John Embretsen Subject: Re: How to recover from the DB not existing In-reply-to: <1e11c6d0609241557s2280dad1i18aa92cff3d5ad3a@mail.gmail.com> Sender: John.Embretsen@Sun.COM To: Derby Discussion Reply-to: Derby Discussion Message-id: <4517C2D9.4080507@Sun.COM> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <44F3FBF6.4090802@sun.com> <7921d3e40608291747yde840ban75bcad8c3ac4f8a0@mail.gmail.com> <4515A405.3020707@gmail.com> <45163D2A.1010600@gmail.com> <1e11c6d0609241557s2280dad1i18aa92cff3d5ad3a@mail.gmail.com> User-Agent: Thunderbird 1.5.0.5 (X11/20060730) X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Nicholas Negulescu wrote: [...] > My problem is that I'm trying to figure out how to load it from an SQL > file. Sure, I can do it on the command line like so: > > java -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver > org.apache.derby.tools.ij > > but I was wondering which tool/class to use when you've alread got the > driver loaded and you're executing withing the VM already. [...] You might want to check out the new ij method called runScript(...), which was added in Derby 10.2 (soon to be released). JavaDoc (for 10.2 runScript method) is here: http://db.apache.org/derby/docs/10.2/publishedapi/jdbc3/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String) -- John