I was doing this with postgresql and it did the same thing.
The culprit was a line along the lines of
Constraints ... primary keys .....;
I fixed it by remove the constraints part and just leaving
primary keys(....);
There's also a bug in torque which won't set the size attribute of
columns in the xml. I don't know if this has been fixed but i did submit a
bug
and fix.
As one of the other emails has pointed out, you probably are better off
using the project-jdbc task.
Huy
> -----Original Message-----
> From: Lang, Cliff [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 17 August 2001 6:43 AM
> To: [EMAIL PROTECTED]
> Subject: Can't get sql2xml to work
>
>
> I have the latest copies of torque (2.1.0) and ant (1.4) and can't get
> any action from "ant sql2xml"
>
> I dumped the schema from mysql, and saved it as schema/schema.sql. If
> it is not there I get an error, so I know the file is in the right
> place. The ant build just never comes back, nor does it produce any new
> files within the torque directory.
>
> Screen capture from "ant sql2xml"
> (myuser)->ant -v sql2xml
> Ant version 1.4Beta1 compiled on August 9 2001
> Buildfile: build.xml
> Detected Java version: 1.3 in: /usr/j2se/jre
> Detected OS: SunOS
> parsing buildfile /usr/local/tomcat-build/torque/build.xml with URI =
> file:/usr/local/tomcat-build/torque/build.xml
> Project base dir set to: /usr/local/tomcat-build/torque
> [property] Loading /usr/local/tomcat-build/torque/build.properties
> Build sequence for target `sql2xml' is [init-tasks, sql2xml]
> Complete build sequence is [init-tasks, sql2xml, project-datadtd, main,
> project-datadump, project-om, project-sql, javadocs, turbine-service,
> compile, project-datasql]
>
> init-tasks:
>
> sql2xml:
> [null] Parsing SQL Schema
>
>
> ############# and it hangs here forever ........
>
> Anything I can look for? Also, are there any details if I need to build
> the schema.xml by hand? Is there an FAQ?
>
> Thanks, Cliff
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
