# ant-user mailing list archives

##### Site index · List index
Message view
Top
From "Anderson, Rob (Global Trade)" <Rob.Ander...@nike.com>
Subject RE: SQL task and the delimiter and 1.6.2.
Date Mon, 03 Jan 2005 19:45:38 GMT
```Don't worry about it. Everyone makes mistakes. Glad to hear you have it working now.

-Rob Anderson

> -----Original Message-----
> From: news [mailto:news@sea.gmane.org]On Behalf Of
> galenboyerdev@hotpop.com
> Sent: Monday, January 03, 2005 6:11 AM
> To: user@ant.apache.org
> Subject: Re: SQL task and the delimiter and 1.6.2.
>
>
> "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com> writes:
>
>   > Send the relevant portion of your build.xml.
>
> BLUSH,
>
> Thank you for the suggestion.  In gathering up the relevant pieces of
> my build.xml I happened upon my error.  I'm profusely sorry to the
> group for having a locally unidentified bug prompting me to ask this
> group for help.
>
> --
> Galen
>
>   >
>   > > -----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
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org