A couple of "advanced" ANT (in Eclipse) questions
I started with ANT today. I see a huge potential in it. However I have now used the whole day trying to get two tings to work - and simply can't find the answer. I hope some ANT experts will take the time to answer the following questions:
1. Can I create a new Eclipse project with a ANT build? If so, how?
2. I get an error trying to create a database for my project with the following code:
<target name="sql.runAll" depends="sql.getLogin">
<sql driver="${sql.jdbcClasspath}" url="${sql.jdbcURL}" userid="uid" password="pw">
<classpath>
<pathelement path="${sql.jdbcPath}" />
</classpath>
CREATE DATABASE idlmedia02_${var.port}
</sql>
</target>
The error: CREATE DATABASE statement not allowed within multi-statement transaction. <sql driver="${sql.jdbcClasspath}" url="${sql.jdbcURL}" userid="uid" password="pw">
<classpath>
<pathelement path="${sql.jdbcPath}" />
</classpath>
CREATE DATABASE idlmedia02_${var.port}
</sql>
</target>
Is there a way to use CREATE DATABASE statements from within ANT?
As always when I ask for help - I would be really thankful to anybody who can shed light on these subjects.
Keep in mind though that doing it that way means Eclipse has no idea that project exists. You'd probably need to do an "import existing project" in Eclipse for it to show up in the project list.
@Brian - Thank you for the advice - however making Eclipse aware of the new project would be part of it. Without this it's just as easy to create a new project before running the ANT script.
@Matt - I'll have to check this when I get the time (away for a couple of days and things pile up). However I think the error message indicates that this is not the problem (now I got to check if I can do Create Database within a cftransaction tag as well :)