ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Woehr <...@purematrix.com>
Subject Re: Sql Task -- quote marks
Date Fri, 09 Apr 2004 19:55:06 GMT
Stefan Bodewig wrote:

> Try running the statement in a very simplistic JDBC setup via
> Statement#execute but without Ant.

Okay, I coded an example using the problematic line

     select @querystring = \"alter table \" +  @tmptablename + \" drop constraint \" + @constraintname
"

and I get a jdbc error for the same SQL that works interpretively:

     com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ' drop constraint '.

             at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)
             at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)
             at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
             at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1683)
             at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1666)
             at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:430)
             at SybStoredProc.doSQL(SybStoredProc.java:107)
             at SybStoredProc.dropAddProcedure(SybStoredProc.java:125)
             at SybStoredProc.do_it(SybStoredProc.java:152)
             at SybStoredProc.main(SybStoredProc.java:181)

This is exactly what Ant was reporting. So Ant is innocent in my Sql task problem and the
ball is in Sybase's court.
I've reported this as a driver bug.

--
Jack J. Woehr            # "[F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax #  upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com #  serenity, and the peace of God." - Mark Twain



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


Mime
View raw message