Return-Path: 
 <ant-user-return-10655-apmail-jakarta-ant-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-ant-user-archive@jakarta.apache.org
Received: (qmail 77096 invoked by uid 500); 25 Jul 2001 16:46:40 -0000
Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Post: <mailto:ant-user@jakarta.apache.org>
List-Help: <mailto:ant-user-help@jakarta.apache.org>
List-Unsubscribe: <mailto:ant-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:ant-user-subscribe@jakarta.apache.org>
Reply-To: ant-user@jakarta.apache.org
Delivered-To: mailing list ant-user@jakarta.apache.org
Received: (qmail 77075 invoked from network); 25 Jul 2001 16:46:39 -0000
Message-Id: <5.1.0.14.0.20010725124008.00ad0af0@imap.nyu.edu>
X-Sender: eg344@imap.nyu.edu
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Wed, 25 Jul 2001 12:46:24 -0400
To: ant-user@jakarta.apache.org
From: eg344@HOMEMAIL.nyu.edu
Subject: <SQL /> and property as query 
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Hello, i'm trying to build a target to execute arbitrary sql statements, 
and it looks like this:
   <target name="sql">
      <echo message="Executing '${sql.query}' on ${sql.url} as 
${sql.userid}" />
      <sql
          driver="${sql.driver}"
          url="${sql.url}"
          userid="${sql.userid}"
          password="${sql.password}"
          print="yes"
          output="${sql.output}"
      >
          ${sql.query}

      </sql>
   </target>


${sql.query} is select count(*) from schema.table, that's all!!

All the ${} are gotten from a property file, and all work fine except for 
the actual  ${sql.query}, where i get:
BUILD FAILED

Path:\build.xml:75: java.sql.SQLException: Non supported SQL92 token at positio
n: 5: sql
--- Nested Exception ---
java.sql.SQLException: Non supported SQL92 token at position: 5: sql
         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
         at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829)
         at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:152)
         at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:112)
         at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:64)
         at 
oracle.jdbc.driver.OracleConnection.nativeSQL(OracleConnection.java:766)
         at 
oracle.jdbc.driver.OracleStatement.expandSqlEscapes(OracleStatement.java:4790)
         at 
oracle.jdbc.driver.OracleStatement.parseSqlKind(OracleStatement.java:4779)
         at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1847)
         at 
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
         at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:506)
         at 
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:448)
         at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:607)
         at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:592)
         at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:377)
         at org.apache.tools.ant.Target.execute(Target.java:153)
         at org.apache.tools.ant.Project.runTarget(Project.java:898)
         at org.apache.tools.ant.Project.executeTarget(Project.java:536)
         at org.apache.tools.ant.Project.executeTargets(Project.java:510)
         at org.apache.tools.ant.Main.runBuild(Main.java:421)
         at org.apache.tools.ant.Main.main(Main.java:149)

Total time: 1 second

if i replace ${sql.query} with ${blah.query} i get the same as above:
Non supported SQL92 token at position: 5: blah

if i replace the ${sql.query} with the actual query, it works perfectly 
fine. Please help

thanx

eg