Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 85034 invoked from network); 4 Jan 2010 17:03:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Jan 2010 17:03:14 -0000 Received: (qmail 77461 invoked by uid 500); 4 Jan 2010 17:03:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 77381 invoked by uid 500); 4 Jan 2010 17:03:13 -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 77368 invoked by uid 99); 4 Jan 2010 17:03:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jan 2010 17:03:13 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jan 2010 17:03:07 +0000 Received: from [127.0.0.1] (bpendleton-desk.edgility.com [10.10.12.128]) by red.amberpoint.com (8.13.8/8.13.8) with ESMTP id o04H2jKO031229 for ; Mon, 4 Jan 2010 09:02:46 -0800 Message-ID: <4B421F35.4040908@amberpoint.com> Date: Mon, 04 Jan 2010 09:02:45 -0800 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: Derby Discussion Subject: Re: How to execute statements from textfile? References: <4B421DD4.80700@cip.ifi.lmu.de> In-Reply-To: <4B421DD4.80700@cip.ifi.lmu.de> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit > is there an easy way to execute multiple queries from a textfile using Java? You might find the ij.runScript method helpful: http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String) thanks, bryan