On Mon, Dec 24, 2012 at 8:08 PM, Rick Hillegas-3 [via Apache Database] <[hidden email]> wrote:

On 12/23/12 7:20 PM, Dag Wanvik 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

You may be able to use the StatementReader program attached to
https://issues.apache.org/jira/browse/DERBY-5690. This program parses an
ij script into individual statements so that you can run them
individually and track their status.

Hope this helps,
-Rick

>> --
>> 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-tp125897p126072.html

To unsubscribe from Exit value of ij tool on command prompr, click here.
NAML