ant-user mailing list archives

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