Re: Problems using Ant sql task

Varban wrote:
> 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.


I did as recommended but the problem is a sticky one :-(
AND it's getting even more confusing - at least to me. When the build seems
to be sleeping at

[echo] Updating codes and MLS on db EAHVWORK_INIT.LPDOMAIN!
[echo] Using JDBC driver at
\\lpsrv06\BuildSystem/eAHV_B/Nightly/../../JaXLionCommonRuntimeLibs/Nightly/
Latest/oracle_jdbc14_9205.jar...
[echo] Using the following parameters: oracle.jdbc.driver.OracleDriver,
jdbc:oracle:thin:@debie.akbnet.be:1521:eahvb, myuser, mypassword

I stopped the Tomcat Windows service (Anthill is running inside Tomcat). All
of a sudden once Tomcat is stopped I'm seeing more output in my build log!!!

[sql] Executing commands
[sql] 21 of 21 SQL statements executed successfully

This is what I was expecting in the first place! With ProcessExplorer I
checked the active Windows processes and threads and I discovered that the
Java process that was dispachted for the build was still running. Hence, the
build that was interrupted for whatever reason was running after Tomcat was
restarted.

Where's the logic here?

P.S. in order to follow this thread more easily, here's the Ant code again:

<echo message="Updating codes and MLS on db ${targetDb}!" />
<echo message="Using JDBC driver at ${oraclejar.location}..." />
<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;

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