Ok, thanks, Will. I ran into those 2 things as well. I guess I'll have to wait and see where the "jdbc" option goes. It's pretty handy for converting existing systems, so I imagine others will be using it as well. Probably _not_ a big priority for now, though.
Jeff Owens ----- Original Message ----- From: "Will Glass-Husain" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 10:38 AM Subject: Re: Anyone generating XML from DB using Torque? > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
