<?xml version="1.0" encoding="UTF-8"?>
<project name="north.foo" default="run-postgres-test" basedir=".">
 
<target name="def">
  <taskdef name="sqlunit"  
       classname="net.sourceforge.antsqlunittask.SqlunitTask">
    <classpath>
      <pathelement location="${basedir}/../net.sourceforge.sqlunit/lib/sqlunit-2.9.jar" />
    </classpath>
  </taskdef>
</target>
 
<target name="run-postgres-test" depends="def">
  <sqlunit testFile="${basedir}/sqltest.xml" />
</target>
 
</project>

<sqlunit>
 <connection>
  <driver>org.postgresql.jdbc.Driver</driver>
  <url>jdbc:postgresql://localhost:5432/original</url>
  <user>olivier</user>
  <password>motdepasse</password>
 </connection>
 <test name="simple test" failure-message="Et meeeerde!">
  <sql>
   <stmt>select 'hello world' as essai</stmt>
  </sql>
  <result>
   <resultset>
    <row id="1">
     <col id="1" name="essai" type="VARCHAR">hello world</col>
    </row>
   </resultset>
  </result>
 </test>
</sqlunit>

Buildfile: /Volumes/Users/olivier/workspace/north.foo/build.xml
def:
run-postgres-test:
  [sqlunit] junit/framework/TestCase
BUILD FAILED: file:/Volumes/Users/olivier/workspace/north.foo/build.xml:14: junit/framework/TestCase
Total time: 343 milliseconds