ant create database(sql) task

here is an ant target to create the specified database... unfortunately, sql does not close the connection properly..



<target name="create-db" >
<sql driver="org.postgresql.Driver" classpath="${build.lib}/postgresql-8.4-702.jdbc4.jar" url="jdbc:postgresql://localhost:5432/template1" userid="userid" password="password" autocommit="true" onerror="continue">


         CREATE DATABASE ${database.prefix}_mydatabase;
       </sql>
</target>