Thomas Dudziak wrote:
Ah, no, you misunderstood. You should put that into the schema XML
file, not into the build file. And you don't need to download the DTD,
simply put the URL as-is into the DOCTYPE decl. DdlUtils will
recognize the DTD url and use the internal DTD (which is contained in
the jar) instead.

Sorry to be a pain, but I need more clarification. I reverted my build.xml and now here is the top of my schema.xml file:

<!DOCTYPE database PUBLIC "//APACHE/DDLUITLS/" "http://db.apache.org/torque/dtd/database.dtd";>
  <database>

Running my DdlToDatabaseTask gives me:

BUILD FAILED
C:\Development\trunk\build.xml:451: Could not read schema file C:\Development\trunk\schema.xml: The database model has no name

Firstly, please let me know if I correctly added the DOCTYPE to this file. Secondly, would it make sense for the writeSchemaToFile command to include this header automatically? I trying for roundtrip movement of data and schema between development databases using DDLUtils. As such, I need to automate all steps.

Thanks for your help. I plan on writing up this whole process and posting it as an example once I get everything working. I think more examples would prove most useful to other newbies like me.

Guy

Reply via email to