Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of dag.wanvik@oracle.com
 designates 141.146.126.69 as permitted sender)
Message-ID: <50D7CA06.2090204@oracle.com>
Date: Mon, 24 Dec 2012 13:20:38 +1000
From: Dag Wanvik <dag.wanvik@oracle.com>
Organization: Oracle Corporation
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: Exit value of ij tool on command prompr
References: <1355822174819-125897.post@n7.nabble.com>
In-Reply-To: <1355822174819-125897.post@n7.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


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.