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