Hi, I ran this yesterday with CVS head. I found a few bugs with the JDBC task, which I haven't formally reported yet.
(1) The schema outputted is incompatible with that required for the OM task. Specifically, it includes "app-data" which should be removed. (The doctype, the start tag, and the end tag). (2) For integer values, it included the line attribute DEFAULT="" which needed to be removed. I did find this task useful but needed to do these hand-edits. It wouldn't surprise me if there were other issues. WILL At 09:00 AM 8/9/02 -0700, you wrote: >Is anyone genenerating their XML schema from an existing database? I'm >beginning the process of moving some of our old old old (its really old!) >software over to have its interface "in the browser". I haven't gotten very >far. > >I use the "jdbc" option of torque - ant -f build-torque.xml jdbc - and it >generates the schema.xml file. I go in and look at that file and it looks >pretty good - EXCEPT: There is no decimal precision. The decimal fields >all have the proper size, but no scale - no decimal precision. In other >words, I get a "<column name="MRATE" required="true" size="7" >type="DECIMAL"/> - _unfortunately_ the field definition is MRATE >DECIMAL(7,2). If I then go and "ant init" this to the new database, I get >MRATE DECIMAL(7,0). Not good. > >Obviously I could correct this myself, but as I mentioned, I'm moving over a >preexisting system - it has a _lot_ of tables (which means a heckuva lot of >fields!!). There's got to be a way to get torque to generate the correct >column definitions. > >Thanks for any help! >Jeff Owens > > > >-- >To unsubscribe, >e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
