Problems using Ant sql task

Marcel Stör <[email protected]> Fri, 31 Mar 2006 13:10:20 +0200
Newsgroups gmane.comp.java.anthill
Message-ID <[email protected]>
Hi all,

After moving from Anthill 1.5.something to Anthill 1.8.1.303 we experience a
problem with Ant's sql task. Our Ant scripts haven't changed in the
meantime, though.

[Ant script excerpt]
<echo message="Using the following parameters: ${driver}, ${url}, ${userid},
${password}" />
<sql driver="${driver}" url="${url}" userid="${userid}"
password="${password}" print="yes" output="${output}" autocommit="false">
 <classpath>
  <pathelement location="${oraclejar.location}" />
 </classpath>
 <![CDATA[
   statement1;
   ...

When executing the above script with Anthill, the last output in the log I
see is my echo message:
[echo] Using the following parameters: oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@debie.akbnet.be:1521:eahvb, myuser, mypasswordAfter that,
nothing happens; no error, no nothing. It looks as if Anthill was waiting
for something or...If I execute the Ant script manually from the commandline
using the exact same parameters as Anthill (taken from log) everything works
as expected:[echo] Using the following parameters:
oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@debie.akbnet.be:1521:eahvb, myuser, mypassword [sql]
Executing commands [sql] 21 of 21 SQL statements executed successfully
I'd be happy if you could help me out. I'm totally clueless.

--
Marcel Stör
http://www.frightanic.com -> free Sudoku mailing service