Thanks!
I'll look into that now. I see that Oracle may have a way to do this also. I'm trying to find simplest way possible to go from an Oracle database to castor generated objects. Something like this: Oracle DB --> XML Schema --> XSD file --> Castor JDO Objects. Ideally, one could then use the Castor JDO objects as a datalayer and just communicate to them (doing creates, retreives, updates and deletes) instead of to the database. What would really be sweet is if this whole process could be automated. We have concerns that knowledge of how the tables will be used will have to be built into XML mapping used to generate the castor objects. (For example, which objects are contained in other objects.) This would kind of defeat the purpose. Our alternative, a very good and frequently used alternative, is to just write the datalayer by hand. If we have to go in and start adjusting XML mapping files, then it would probably be simpler, and less error prone, to just write the data layer. Thanks, Skip -----Original Message----- From: Ilia Iourovitski [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Oracle schema to XSD file Torque has utility to generate mapping file from database schema. You can start from it. http://jakarta.apache.org/turbine/torque/index.html Ilia --- Bruce Snyder <[EMAIL PROTECTED]> wrote: > This one time, at band camp, Cole, Ronald said: > > CR> Does anyone have a way to turn an Oracle Schema > into an XSD file to > CR>feed into the SourceGenerator ? > CR> > CR> I've started writing one. A program that logs > onto an Oracle > CR>instance, gets all of the tables in the user's > schema (from the user_tables > CR>table) and creates the xsd file. But I figure > that someone must have crossed > CR>this bridge before, and I'm not completely sure > of the format in which the > CR>xsd file must be written. > > Skip, > I'm the JDO lead developer. I don't work on the XML > side. However, it > seems to me that if you have the DDL, creating a > schema from this can be > done in many ways. One of which (and in my opinion, > the easiest) is via > the use of XSLT. Just write an XSL and apply it > using Ant's style task > (http://jakarta.apache.org/ant/manual/CoreTasks/style.html). > > The reason for a suggest rather than offering > something from the Castor > Project is that I know there is nothing of this sort > currently included > in the Castor Project. > > Bruce > -- > perl -e 'print > unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' > > ----------------------------------------------------------- > > If you wish to unsubscribe from this mailing, send > mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
