ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brill, C" <C.Br...@t-systems.com>
Subject Executing multiple .sql in one Transaction
Date Wed, 27 Aug 2008 12:19:10 GMT
I'm trying to execute multiple sql-files within the sql-task in one transaction.
that means a rollback should be done if one of these files doesn't work.
for example the stored procedures test1.sql and test2.sql are fine and test3.sql crashes.
in that case test1 and test2 should not be in the database.

<sql driver="com.informix.jdbc.IfxDriver"
  url="jdbc:informix-sqli://***:1551/*:*"
  userid="symosyad" password="***" onerror="stop" print="true" delimiter="ยง"
  keepformat="true" autocommit="off">
  <classpath>
    <pathelement location="${name.dir.jdbc}" />
    <pathelement path="${classpath}" />
  </classpath>
  <fileset dir="${name.dir.delivery}/${name.label/${name.dir.vob.root}/DB/symosy_net/procedures"
includes="*.sql" />
</sql>

could you please tell me how to do that?

Thanks
Christoph

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message