db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag Wanvik <dag.wan...@oracle.com>
Subject Re: Exit value of ij tool on command prompr
Date Thu, 27 Dec 2012 00:45:29 GMT

On 26.12.2012 18:54, aniderbian wrote:
> thanks for replying,  I dont see  StatementFinder.java class in
> attachment. where will I get this java file?

It's part of "tools.jar":  org.apache.derby.impl.tools.ij.StatementFinder

Thanks,
Dag


> --Ani
> Pl Save the environment. Please don't print this email unless you
> really need to.
>
>
>  
>
>
> On Mon, Dec 24, 2012 at 8:08 PM, Rick Hillegas-3 [via Apache Database]
> <[hidden email] </user/SendEmail.jtp?type=node&node=126076&i=0>>
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
>     <http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
>
>
>
> ------------------------------------------------------------------------
> View this message in context: Re: Exit value of ij tool on command
> prompr
> <http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897p126076.html>
> Sent from the Apache Derby Developers mailing list archive
> <http://apache-database.10148.n7.nabble.com/Apache-Derby-Developers-f4.html>
> at Nabble.com.


Mime
View raw message