Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 97984 invoked from network); 21 Mar 2005 15:13:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Mar 2005 15:13:39 -0000 Received: (qmail 80459 invoked by uid 500); 21 Mar 2005 15:13:38 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 80438 invoked by uid 500); 21 Mar 2005 15:13:38 -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 80425 invoked by uid 99); 21 Mar 2005 15:13:38 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of denials@gmail.com designates 64.233.170.202 as permitted sender) Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.202) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 21 Mar 2005 07:13:38 -0800 Received: by rproxy.gmail.com with SMTP id z35so1094158rne for ; Mon, 21 Mar 2005 07:13:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=VN+5ZXerKmlqEqPZCHpwl2z+1O4r8mAdtd65oPTh28DBnpvQZqKaWqsx3ujSE/iZ3/+mFvGu5MKpMuTKnVmItP2XTASeyA0dl+lgwqq7A3Ia8ueEIDkfw3G1BK1YOdOcNW98964znxTBSkU7xkraS00VFlKNN1HWEEYUExjvrxs= Received: by 10.38.101.66 with SMTP id y66mr5322490rnb; Mon, 21 Mar 2005 07:13:31 -0800 (PST) Received: by 10.38.65.30 with HTTP; Mon, 21 Mar 2005 07:13:31 -0800 (PST) Message-ID: Date: Mon, 21 Mar 2005 10:13:31 -0500 From: Dan Scott Reply-To: Dan Scott To: Derby Discussion Subject: Re: Executing multiple SQL statements withing a single Statement In-Reply-To: <20050321141340.75182.qmail@web51805.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050321141340.75182.qmail@web51805.mail.yahoo.com> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N J2SE documentation says that Statement.execute(): "Executes the given SQL statement" (http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html) It sounds like you're relying on non-standard behavior in your other JDBC driver. You might want to look into the executeBatch() method for a standardized (but optionally implemented) means of achieving the same goals. Dan On Mon, 21 Mar 2005 06:13:40 -0800 (PST), Arunanthisivam Vimalathithen wrote: > Hi, > > Derby does not seem to be supporting multiple SQL statetments that can be > passed as a single string to one Statement as in other databases (eg :- > Statement.execute(CREATE table A(test VARCHAR(64));CREATE table B(test > VARCHAR(64));)). (Derby seems to error out in the semicolon after the first > CREATE statement) Is there a way around this, or must we invoke the ij tool > within the program to run the script to invoke an sql script file? > > Thanks in advance, > > V. > > ________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > >