db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mayuresh Nirhali <Mayuresh.Nirh...@Sun.COM>
Subject Re: IJ always returns 0 with sql script as argument
Date Mon, 24 Mar 2008 14:16:17 GMT
I think I got confused here.

IJ need not report the status on exit if there are any sql errors from 
the input sql file. The IJ session exit status will always be zero.

Sorry for the noise!
Mayuresh

Mayuresh Nirhali wrote:
> Rick,
>
> Honestly, I assumed that this should be the behavior. I did not look 
> for any description in the docs. I looked through the code after 
> writing to the group and figured the same thing as you mention. The 
> errors observed when the script is run do not imply a different exit 
> status.
>
> Basically, I am working with some shell scripts that invoke IJ with 
> sql schema scripts and the shell scripts got me confused when I saw 
> that the return status is not a non-zero number on error. any 
> workaround here ?
>
> Mayuresh
>
> Rick Hillegas wrote:
>> Mayuresh Nirhali wrote:
>>> Hello,
>>>
>>> I tried following simple command with ij and it seems IJ always 
>>> returns 0.
>>>
>>> % java -cp $CLASSPATH -Dij.protocol=jdbc:derby: 
>>> org.apache.derby.tools.ij test_create.sql           ij version 10.5
>>> ij> -- 
>>> *********************************************************************
>>>
>>> CREATE TABLE my_schema (
>>>    version VARCHAR(32)
>>> );
>>> IJ ERROR: Unable to establish connection
>>> ij> % echo $?
>>> 0
>>> %
>>>
>>> Isnt this a bug ?
>>> Or I must be missing something really basic here ? :-p
>>>
>>> Mayuresh
>> Hi Mayuresh,
>>
>> The Tools Guide doesn't say what ij's behavior here should be. At 
>> least, I can't find any description. The description of the "exit" 
>> command doesn't mention this issue. Neither does the "Running ij 
>> scripts" section. The "exit" command itself doesn't take a status 
>> code argument. Have you found some text in the Tools Guide which 
>> indicates that this behavior is defined?
>>
>> Thanks,
>> -Rick
>


Mime
View raw message