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 Thu, 27 Dec 2012 16:47:34 GMT
Hi Ani,

I have attached a SQLRunner program to 
https://issues.apache.org/jira/browse/DERBY-5690. This is a program 
which uses StatementReader to loop through a batch of statements, 
exiting if an error occurs. Hopefully this demonstrates how to use 
StatementReader.

Hope this helps,
-Rick

On 12/27/12 4:37 AM, aniderbian wrote:
> i have got success in parsing the script using StatementReader. Now I 
> can get each statement separately of the script file but I doubt if it 
> serves my purpose.
>
> My script file is
> ----
> connect 'jdbc:derby:../../target/sample;create=false';
>
> CREATE  TABLE app_version (
>   app_version VARCHAR(45) NOT NULL ,
>   script_no VARCHAR(45) DEFAULT NULL ,
>   script_status VARCHAR(45) DEFAULT NULL
>   );
> insert into app_version values('2.0','1','SUCCESS');
> -----
> My purpose is to check the status of the above script whether it runs 
> or fails . How will I achieve this using the StatementReader class. 
> How will I execute an individual statement using IJ in java? If you 
> would be having an handy sample code , would really help .
>
> Thanks
> --Ani
> Pl Save the environment. Please don't print this email unless you 
> really need to.
>
>
>
>
>
> On Thu, Dec 27, 2012 at 6:16 AM, Dag Wanvik [via Apache Database] 
> <[hidden email] </user/SendEmail.jtp?type=node&node=126093&i=0>>
wrote:
>
>
>     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]
>>     <http://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.
>
>
>
>     ------------------------------------------------------------------------
>     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-tp125897p126081.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-tp125897p126093.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