ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Velagapudi, Murali" <murali.velagap...@citigroup.com>
Subject RE: SQL task and the delimiter and 1.6.2.
Date Thu, 30 Dec 2004 18:56:30 GMT
try with  delimiter="/" and replace ; with /
it works fine for me on oracle.

thanks,
Murali

-----Original Message-----
From: news [mailto:news@sea.gmane.org]On Behalf Of
galenboyerdev@hotpop.com
Sent: Thursday, December 30, 2004 1:52 PM
To: user@ant.apache.org
Subject: SQL task and the delimiter and 1.6.2.


I'm having trouble getting more than one statement withing a file to
execute successfully.  I'm pretty sure it has to do with the
delimiter.  I am using 1.6.2.

For my sql task, I have the delimiter attribute set to ";"

HERE I AM GOING AGAINST ORACLE:

<<FileToExec>>
create or replace view t1_v1
as 
   select * from t1
;

create or replace view t1_v3
as 
   select * from t1
;
<</FileToExec>>

I get the error:

BUILD FAILED
C:\fmer\dbmsbin\dbmsbin.xml:170: The following error occurred while executing this line:
C:\fmer\dbmsbin\dbmsbin.xml:166: The following error occurred while executing this line:
C:\fmer\dbmsbin\dbmsbin.xml:105: java.sql.SQLException: ORA-00911: invalid character

IF I CHANGE IT SO I HAVE ONLY ONE STATEMENT:

<<FileToExec>>
create or replace view t1_v1
as 
   select * from t1
<</FileToExec>>

I then get success.  

Notice that I also needed to remove the ";" within
even the file with only one SQL statement.

I have seen this work on other versions of ant, but seems to be giving
me fits with the 1.6.2 version.  Am I just missing something silly?

--
Galen Boyer


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message