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.
