Re: Problems using Ant sql task

Hi Marcel,

can you run a build and check the Tomcat logs to see if maybe there is some 
input required at that point of time? Also make sure that you are running the 
Anthill instance with the same user as before.

Regards,
Varban

On Friday 31 March 2006 06:10, Marcel Stör wrote:
> 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
>
> _______________________________________________
> Anthill mailing list
> Anthill-IWHQxnLZ/[email protected]
> http://lists.urbancode.com/mailman/listinfo/anthill