You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by aniderbian <ja...@gmail.com> on 2012/12/18 10:16:15 UTC
Exit value of ij tool on command prompr
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
--
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.
Re: Exit value of ij tool on command prompr
Posted by aniderbian <ja...@gmail.com>.
okay, thanks for reply, I will try to write off a JDBC app to see how I
could achieve this.
--Ani
Pl Save the environment. Please don't print this email unless you really
need to.
On Mon, Dec 24, 2012 at 8:51 AM, Dag Wanvik [via Apache Database] <
ml-node+s10148n126069h71@n7.nabble.com> 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
>
> >
> > --
> > 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-tp125897p126069.html
> To unsubscribe from Exit value of ij tool on command prompr, click here<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=125897&code=amFkaGFvLmFuaXJ1ZGRoYUBnbWFpbC5jb218MTI1ODk3fC0xMTM1MDU4NjQ=>
> .
> 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: http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897p126070.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Exit value of ij tool on command prompr
Posted by aniderbian <ja...@gmail.com>.
It worked thanks so much . Just would like to add that , type of
(embedded/client) derby-jdbc driver before should be
loaded DriverManager.getConnection (_connectionURL).
--Ani
Pl Save the environment. Please don't print this email unless you really
need to.
On Thu, Dec 27, 2012 at 10:18 PM, Rick Hillegas-3 [via Apache Database] <
ml-node+s10148n126104h56@n7.nabble.com> wrote:
> 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.
>
>
>
> ------------------------------
> 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-tp125897p126104.html
> To unsubscribe from Exit value of ij tool on command prompr, click here<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=125897&code=amFkaGFvLmFuaXJ1ZGRoYUBnbWFpbC5jb218MTI1ODk3fC0xMTM1MDU4NjQ=>
> .
> 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: http://apache-database.10148.n7.nabble.com/Exit-value-of-ij-tool-on-command-prompr-tp125897p126114.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Exit value of ij tool on command prompr
Posted by Rick Hillegas <ri...@oracle.com>.
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.
Re: Exit value of ij tool on command prompr
Posted by aniderbian <ja...@gmail.com>.
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] <
ml-node+s10148n126081h43@n7.nabble.com> 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<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=125897&code=amFkaGFvLmFuaXJ1ZGRoYUBnbWFpbC5jb218MTI1ODk3fC0xMTM1MDU4NjQ=>
> .
> 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: 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 at Nabble.com.
Re: Exit value of ij tool on command prompr
Posted by Dag Wanvik <da...@oracle.com>.
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.
Re: Exit value of ij tool on command prompr
Posted by aniderbian <ja...@gmail.com>.
thanks for replying, I dont see StatementFinder.java class in attachment.
where will I get this java file?
--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] <
ml-node+s10148n126072h64@n7.nabble.com> 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<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=125897&code=amFkaGFvLmFuaXJ1ZGRoYUBnbWFpbC5jb218MTI1ODk3fC0xMTM1MDU4NjQ=>
> .
> 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: 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 at Nabble.com.
Re: Exit value of ij tool on command prompr
Posted by Rick Hillegas <ri...@oracle.com>.
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.
>
Re: Exit value of ij tool on command prompr
Posted by Dag Wanvik <da...@oracle.com>.
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
>
> --
> 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.