hi, I needed an XML Schema to be generated from an SQL file. It worked fine with all SQL files, until i encountered the foll. problem:
I reverse engineered a schema in an existing database on Oracle8i (Windows 2000 - Professional). An SQL file was generated which had scripts for creating all the tables that exist in that schema. [ 142 tables ] I needed an XML Schema to be derived from the generated SQL file. On 'Ant' ing ( C:>ant -f build-torque.xml), it would display the foll. message: Buildfile: build-torque.xml main: project-sql2xml: [sql-xml] Parsing SQL Schema I was shocked to see that it remained in the same state for 16.5 hours (YES, 16.5 Hours !!!!). Finally, i lost patience and tried to terminate the job, to which it responded with the message: Terminate batch job (Y/N)? Found that, even the "N" option terminated the job. After some trial & error, i found out that a column of 'LONG RAW' datatype was causing this problem. I eliminated this particular column, and on 'Ant' ing, the XML Schema was generated immediately. The build took just 1 second. I hope this piece of information might prove useful to someone. Also, i would like some help on what needs to be done to use the 'LONG RAW' datatype. Vijay Prabhu Member - Tech. Team C:\torque3>ant -f build-torque.xml
