ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anderson, Rob (Global Trade)" <Rob.Ander...@nike.com>
Subject RE: SQL task and the delimiter and 1.6.2.
Date Thu, 30 Dec 2004 20:44:09 GMT
Send the relevant portion of your build.xml.

-Rob A

> -----Original Message-----
> From: galenboyerdev@hotpop.com [mailto:galenboyerdev@hotpop.com]
> Sent: Thursday, December 30, 2004 12:39 PM
> To: Ant Users List
> Subject: Re: SQL task and the delimiter and 1.6.2.
> 
> 
> "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com> writes:
> 
>    > In this case your delimiter is "go".
> 
> That is my issue.  I use go as my delimiter but multiple statements
> still fail.
> 
>     > -Rob Anderson
>     > 
>     > > -----Original Message-----
>     > > From: galenboyerdev@hotpop.com 
> [mailto:galenboyerdev@hotpop.com]
>     > > Sent: Thursday, December 30, 2004 11:57 AM
>     > > To: Ant Users List
>     > > Subject: Re: SQL task and the delimiter and 1.6.2.
>     > > 
>     > > 
>     > > Okay,
>     > > 
>     > > I'm having the same type of issue with SQLServer.  
> I've mucked around
>     > > with different combinations of delimiters but two 
> statements in the
>     > > same file being executed against SQLServer seem to fail.
>     > > 
>     > > <FILE1:Which is successful>
>     > > create view dbo.t1_v1
>     > > as 
>     > >    select * from t1
>     > > go
>     > > </FILE1>
>     > > 
>     > > <FILE2:Which is unsuccessful>
>     > > create view dbo.t1_v2
>     > > as 
>     > >    select * from t1
>     > > go
>     > > 
>     > > create view dbo.t1_v3
>     > > as 
>     > >    select * from t1
>     > > go
>     > > </FILE2>
>     > > 
>     > > HERE IS A COPY OF THE RELEVANT OUTPUT:
>     > > 
>     > >       [sql] Executing file: 
>     > > C:\fmer\dbms_proto\sqlserver\reportplace\views\t1_v1.sql
>     > >       [sql] 0 rows affected
>     > >       [sql] Executing file: 
>     > > C:\fmer\dbms_proto\sqlserver\reportplace\views\t1_v2.sql
>     > >       [sql] Failed to execute: 
>     > >       [sql] create view dbo.t1_v2
>     > >       [sql] as 
>     > >       [sql]    select * from t1
>     > >       [sql] go
>     > >       [sql] 
>     > >       [sql] create view dbo.t1_v3
>     > >       [sql] as 
>     > >       [sql]    select * from t1
>     > >       [sql] go
>     > > 
>     > > 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: 
>     > > [Microsoft][SQLServer 2000 Driver for 
>     > > JDBC][SQLServer]Incorrect syntax near the keyword 'create'.
>     > > 
>     > > Also, notice that I left the SQLServer style delimiter of 
>     > > "go" inside the files.
>     > > 
>     > > Is there something I'm missing from the SQLServer end?
>     > > 
>     > > Thanks.
>     > > 
>     > > -- 
>     > > Galen Boyer
>     > > 
>     > > 
>     > >     "Velagapudi, Murali" 
> <murali.velagapudi@citigroup.com> writes:
>     > > 
>     > >     > 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?
>     > > 
>     > > 
>     > > 
>     > > 
> ---------------------------------------------------------------------
>     > > 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
> 
> 
> 
> ---------------------------------------------------------------------
> 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