Hi Eric, Similar thoughts ... did you take a look at the Common Warehouse Metamodel from the OMG http://www.omg.org/cwm/? This is probably the closest there is to portable relational metadata (and UML and ...) with XML mapping ...
Cheers, Jon -----Original Message----- From: Eric Pugh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 6:39 PM To: 'Turbine Torque Users List' Subject: RE: [PATCH] Re: Creating XML schema from database (project-jdbc) The world is looking for the xml schema that details everything in the db! A fried of mine was working on one, that you could use, and some xsl stylesheets to convert to torque or dbforms schema format.. Not sure where he got, I will check. Eric -----Original Message----- From: Alexis HAUMONT [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 8:30 AM To: Turbine Torque Users List Subject: [PATCH] Re: Creating XML schema from database (project-jdbc) Jon Scott Stevens wrote: >on 6/17/02 4:03 AM, "Alexis HAUMONT" <[EMAIL PROTECTED]> wrote: > > > >>I just had to patch Torque to get the size="" attribute of my columns >>for NUMBER type columns. >>The default Torque JdbcTask only retrieved the size="" attribute for >>CHAR OR VARCHAR column types.. >> >>Alex. >> >> > >How about submitting that patch so that others can benefit from it? > >;-) > >-jon > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > I did ;-) It was already as an attachment of my previous mail. Here it is once again. (should I post it to the dev-list ? ). We're using this task intensively on my project.. we're using Torque but the database designer uses AMC Designor to model the tables.. so we retrieve the XML schema from the database, and apply some Xslt process to set back the 'autoIncrement' attribute on desired tables, and set back type="BIT" for oracle Number(1) columns. (if someone want's this stylesheet, I can post it, but it's a little specific to my app..). This process is straight-forward using an Ant task, but not so 'clean'. Is there any plan to define (or does it exist already ??) a 'standard' XML schema definition of a database, so that Torque, Database modeler, JDO or whatever ... could at least share the same definition. Alex. -- 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]>
