db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Exit value of ij tool on command prompr
Date Mon, 24 Dec 2012 14:38:00 GMT
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.
>


Mime
View raw message