Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3A25EE190 for ; Tue, 25 Dec 2012 01:00:26 +0000 (UTC) Received: (qmail 19402 invoked by uid 500); 25 Dec 2012 01:00:19 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 19362 invoked by uid 500); 25 Dec 2012 01:00:18 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Delivered-To: moderator for derby-dev@db.apache.org Received: (qmail 75872 invoked by uid 99); 24 Dec 2012 06:08:59 -0000 X-ASF-Spam-Status: No, hits=2.9 required=5.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.250.139 is neither permitted nor denied by domain of jadhao.aniruddha@gmail.com) Date: Sun, 23 Dec 2012 22:08:33 -0800 (PST) From: aniderbian To: derby-dev@db.apache.org Message-ID: In-Reply-To: <50D7CA06.2090204@oracle.com> References: <1355822174819-125897.post@n7.nabble.com> <50D7CA06.2090204@oracle.com> Subject: Re: Exit value of ij tool on command prompr MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3826_21474028.1356329313331" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_3826_21474028.1356329313331 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit okay, thanks for reply, I will try to write off a JDBC app to see how I could achieve this. --Ani Pl Save the environment. Please don't print this email unless you really need to. On Mon, Dec 24, 2012 at 8:51 AM, Dag Wanvik [via Apache Database] < ml-node+s10148n126069h71@n7.nabble.com> wrote: > > On 18.12.2012 19:16, aniderbian wrote: > > > Hello, > > I am running a windows batch script in which I have a need to fire > below > > command > > *java -jar ..\db-derby-10.9.1.0-lib\lib\derbyrun.jar ij sql_file.txt *. > > > > Now after firing above command I want to check return exit status to > > capture the success/failure of it . > > > > Or if there is any alternative way to achieve this please suggest. > > > > Thanks > As far as I know, there is no such feature, the exit code is that of the > Java VM exiting, so it would normally be 0. > You probably want to know the success or failure of individual SQL > statements in the script. Presently there is no feature to easily > capturing those and relaying the results back to the OS invocation level > of ij. IJ scripting is very basic. > If you need such status codes, you'd probably be better off writing a > small JDBC application. > > Thanks, > Dag > > > > > -- > > View this message in context: > http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897.html > > Sent from the Apache Derby Developers mailing list archive at > Nabble.com. > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897p126069.html > To unsubscribe from Exit value of ij tool on command prompr, click here > . > NAML > -- View this message in context: http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897p126070.html Sent from the Apache Derby Developers mailing list archive at Nabble.com. ------=_Part_3826_21474028.1356329313331 Content-Type: text/html; charset=UTF8 Content-Transfer-Encoding: quoted-printable okay, thanks for reply, I will try to write off a JDBC app to see how I cou= ld=C2=A0achieve=C2=A0this.
--Ani
Pl Save the envir= onment. Please don't print this email unless you really need to.

=C2=A0


On Mon, Dec 24, 2012 at 8:51 AM, Dag Wan= vik [via Apache Database] <[hidden email]> wrote:
=09
On 18.12.2012 19:16, aniderbian wrote:

> Hello,
> I am running a windows batch =C2=A0script in which I have a need t= o fire =C2=A0below
> command
> *java -jar ..\db-derby-10.9.1.0-lib\lib\derbyrun.jar ij sql_file.t= xt *.=20
>
> Now after firing above command I want to check return exit status = =C2=A0to
> capture =C2=A0the success/failure of it .
>
> Or if there is any alternative =C2=A0way to achieve this please su= ggest.
>
> Thanks
As far as I know, there is no such feature, the exit code is that of = the
Java VM exiting, so it would normally be 0.
You probably want to know the success or failure of individual SQL
statements in the script. Presently there is no feature to easily
capturing those and relaying the results back to the OS invocation leve= l
of ij. IJ scripting is very basic.
If you need such status codes, you'd probably be better off writing= a
small JDBC application.

Thanks,
Dag

>
> --
> View this message in context: http://apache-database.1= 0148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897.html
> Sent from the Apache Derby Developers mailing list archive at Nabble.c= om.

=09 =09 =09 =09
=09
=09
=09 =09
=09=09 =09=09To unsubscribe from Exit value of ij tool on command prompr, click here.<= br> =09=09NAML =09

=09 =09 =09
View this message in context: Re: = Exit value of ij tool on command prompr
Sent from the Apache Derby Developers mailing list archive = at Nabble.com.
------=_Part_3826_21474028.1356329313331--