ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Woehr <>
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(
             at com.sybase.jdbc2.tds.Tds.nextResult(
             at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(
             at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(
             at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(
             at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(
             at SybStoredProc.doSQL(
             at SybStoredProc.dropAddProcedure(
             at SybStoredProc.do_it(
             at SybStoredProc.main(

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 #  upon motionless wing; everywhere brooded stillness, #  serenity, and the peace of God." - Mark Twain

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message