Please see the checkins under JIRA-1923, Rev 599394 In-progress- maven plugin creation and assembly file changes to include tools in distribution
Regards, Amita On Nov 29, 2007 4:36 PM, Amita Vadhavkar <[EMAIL PROTECTED]> wrote: > When trying for tool to convert from DB Schema to SDO Model xsds - tried > using > SDO's XSDHelper in one attempt and Apache Torque in another. > > 1) When using XSDHelper ------------------- > Tried using XSDHelper.generate () to take as input param the SDO created > by DAS > using its dynamic DO creation approach. Saw that when there is a SDO which > > contains child DO (like Table STATES will contain table CITIES), it was > giving below exception originating from EMF - > java.lang.IllegalArgumentException: The 'no duplicates' constraint is > violated > java.lang.IllegalArgumentException: The 'no duplicates' constraint is > violated > at org.eclipse.emf.common.util.BasicEList.add (BasicEList.java:642) > at org.eclipse.xsd.impl.XSDNamedComponentImpl.addToSortedList( > XSDNamedComponentImpl.java:165) > at org.eclipse.xsd.impl.XSDSchemaImpl$3.caseXSDTypeDefinition( > XSDSchemaImpl.java:1801) > at org.eclipse.xsd.util.XSDSwitch.doSwitch(XSDSwitch.java:201) > at org.eclipse.xsd.util.XSDSwitch.doSwitch(XSDSwitch.java:88) > at org.eclipse.xsd.util.XSDSwitch.doSwitch(XSDSwitch.java:74) > at org.eclipse.xsd.impl.XSDSchemaImpl.adoptContent (XSDSchemaImpl.java > :1819) > at org.eclipse.xsd.impl.XSDConcreteComponentImpl.eNotify( > XSDConcreteComponentImpl.java:1160) > at org.eclipse.emf.ecore.util.EcoreEList.dispatchNotification( > EcoreEList.java:234) > at org.eclipse.emf.common.notify.impl.NotifyingListImpl.addUnique( > NotifyingListImpl.java:292) > at org.eclipse.emf.common.util.BasicEList.add(BasicEList.java:600) > at org.apache.tuscany.sdo.helper.SchemaBuilder.buildComplexSchemaType( > SchemaBuilder.java:352) > at org.apache.tuscany.sdo.helper.SchemaBuilder.buildSchema( > SchemaBuilder.java:551) > at org.apache.tuscany.sdo.helper.SchemaBuilder.addElement2ComplexType( > SchemaBuilder.java:188) > at > org.apache.tuscany.sdo.helper.SchemaBuilder.buildComplexSchemaTypeContents > (SchemaBuilder.java:306) > at org.apache.tuscany.sdo.helper.SchemaBuilder.buildComplexSchemaType( > SchemaBuilder.java:371) > at org.apache.tuscany.sdo.helper.SchemaBuilder.buildSchema ( > SchemaBuilder.java:551) > at org.apache.tuscany.sdo.helper.XSDHelperImpl.generate( > XSDHelperImpl.java:287) > at org.apache.tuscany.sdo.helper.XSDHelperImpl.generate( > XSDHelperImpl.java:268) > > 2) When using Apache Torque-------------------- > Apache Torque generator task - jdbc worked well and the output (say > schema.xml) > could be used by stax to form the SDO Model xsds. This approach turned out > to be > simpler and no dependency on SDO and EMF. > > I am creating tuscany-das-tools to place this utility tool and also > creating maven plugin for same. > > Suggestions? > > Regards, > Amita > > > > On Nov 26, 2007 6:29 PM, Amita Vadhavkar <[EMAIL PROTECTED]> > wrote: > > > http://www.mail-archive.com/[email protected]/msg25916.html > > > > As first attempt trying to create an utility/tool to convert from DB > > Schema to model XSDs - > > RDB DAS has a reusable core part which uses DB Metadata to create SDO > > Types and properties. Its result can > > be fed to Tuscany SDO's XSDHelper to form XSDs. > > > > http://www.mail-archive.com/[email protected]/msg19374.html > > DB SChema->SDO->XSD is possible without errors as it comes from Types > > generated from SDO > > > > Use: > > When doing static SDO model based Data Access (not only RDB DAS) and > > model is not available or not up-to-date w.r.t. DB schema - > > like cases of rapid prototyping when DB schema is undergoing changes. > > > > Limitation: > > DB Metadata APIs should support - > > DatabaseMetaData.getTables (), getPrimaryKeys(), getCrossReference(), > > ResultSetMetaData.getColumnCount(), getTableName(), getSchemaName(), > > getColumnName(), getColumnType(), > > > > Suggestions? > > > > Regards, > > Amita > > > >
