Hi,

I am playing around with bugrat and turbine-torque.  I've been able to
generate a schema xml for torque to create an object-map, however when
I add in the foreign key references for the table bug, I get multiple
method definitions in the base object. 

Can someone tell me if I am doing something wrong?

Thanks
Jason Kary


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
<?xml version="1.0"?>
<!DOCTYPE app-data SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<app-data>
    <database>
        <table name="action">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="acttype" required="true" size="1" type="CHAR"/>
            <column name="actor" required="true" type="INTEGER"/>
            <column name="acttime" required="true" type="TIMESTAMP"/>
            <column name="target" required="true" size="1" type="CHAR"/>
            <column name="targetid" required="true" type="INTEGER"/>
            <column name="argone" required="true" type="INTEGER"/>
            <column name="argtwo" required="true" type="INTEGER"/>
            <column name="comment2" size="255" type="VARCHAR"/>
	    <foreign-key foreignTable="rataction">
	       <reference local="acttype" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="person">
	       <reference local="actor" foreign="id" />
	    </foreign-key>
        </table>
        <table name="actiontype">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="desctext" required="true" size="255" type="CHAR"/>
        </table>
        <table name="authgroup">
            <column name="userid" primaryKey="true" required="true"
                size="16" type="CHAR"/>
            <column name="groupid" primaryKey="true" required="true"
                size="16" type="CHAR"/>
        </table>
        <table name="authuser">
            <column name="userid" primaryKey="true" required="true"
                size="16" type="CHAR"/>
            <column name="passwd" size="16" type="CHAR"/>
        </table>
        <table name="category">
            <column name="pkg" primaryKey="true" required="true"
                size="8" type="CHAR"/>
            <column name="cat" primaryKey="true" required="true"
                size="8" type="CHAR"/>
            <column name="sub" primaryKey="true" required="true"
                size="8" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="resp" required="true" type="INTEGER"/>
            <column name="catdesc" size="255" type="CHAR"/>
        </table>
        <table name="bugclass">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="info" size="255" type="CHAR"/>
            <column name="lvl" required="true" type="INTEGER"/>
        </table>
        <table name="comment2">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="target" required="true" size="1" type="CHAR"/>
            <column name="targetid" required="true" type="INTEGER"/>
            <column name="descid" required="true" type="INTEGER"/>
            <column name="commentor" required="true" type="INTEGER"/>
            <column name="cmttime" required="true" type="TIMESTAMP"/>
        </table>
        <table name="confidence">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="info" size="255" type="CHAR"/>
            <column name="lvl" required="true" type="INTEGER"/>
        </table>
        <table name="description">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="synopsis" required="true" size="255" type="VARCHAR"/>
            <column name="url" size="255" type="VARCHAR"/>
            <column name="email" type="INTEGER"/>
            <column name="mimetype" size="128" type="VARCHAR"/>
            <column name="desctext" type="VARBINARY"/>
        </table>
        <table name="email">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="recvdate" required="true" type="TIMESTAMP"/>
            <column name="hdrmsgid" required="true" size="255" type="VARCHAR"/>
            <column name="hdrfrom" required="true" size="255" type="VARCHAR"/>
            <column name="hdrto" required="true" size="255" type="VARCHAR"/>
            <column name="hdrsubject" size="255" type="VARCHAR"/>
        </table>
        <table name="emailcontent">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="size2" required="true" type="INTEGER"/>
            <column name="content" required="true" type="LONGVARBINARY"/>
        </table>
        <table name="envdefs">
            <column name="id" primaryKey="true" required="true" size="8" type="CHAR"/>
            <column name="os" required="true" size="32" type="CHAR"/>
            <column name="osrel" required="true" size="32" type="CHAR"/>
            <column name="platform" required="true" size="32" type="CHAR"/>
        </table>
        <table name="envdesc">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="release" size="32" type="CHAR"/>
            <column name="envjvm" size="32" type="CHAR"/>
            <column name="envos" size="32" type="CHAR"/>
            <column name="envosrel" size="32" type="CHAR"/>
            <column name="envplat" size="32" type="CHAR"/>
            <column name="envdesc" size="255" type="CHAR"/>
        </table>
        <table name="forward">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="source" required="true" size="1" type="CHAR"/>
            <column name="srcid" required="true" type="INTEGER"/>
            <column name="srcsub" required="true" type="INTEGER"/>
            <column name="desturl" required="true" size="255" type="VARCHAR"/>
        </table>
        <table name="person">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="type" required="true" size="1" type="CHAR"/>
            <column name="email" required="true" size="128" type="VARCHAR"/>
            <column name="name" required="true" size="128" type="VARCHAR"/>
            <column name="login" size="16" type="VARCHAR"/>
            <column name="org" size="128" type="VARCHAR"/>
            <column name="url" size="255" type="VARCHAR"/>
            <column name="phone" size="32" type="VARCHAR"/>
            <column name="fax" size="32" type="VARCHAR"/>
        </table>
        <table name="priority">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="info" size="255" type="CHAR"/>
            <column name="lvl" required="true" type="INTEGER"/>
        </table>
        <table name="properties">
            <column name="propkey" primaryKey="true" required="true"
                size="128" type="VARCHAR"/>
            <column name="propval" type="VARBINARY"/>
        </table>
        <table name="rataction">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="acttype" required="true" size="1" type="CHAR"/>
            <column name="actor" required="true" type="INTEGER"/>
            <column name="acttime" required="true" type="TIMESTAMP"/>
            <column name="target" required="true" size="1" type="CHAR"/>
            <column name="targetid" required="true" type="INTEGER"/>
            <column name="argone" required="true" type="INTEGER"/>
            <column name="argtwo" required="true" type="INTEGER"/>
            <column name="actcmt" size="255" type="VARCHAR"/>
        </table>
        <table name="ratcomment">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="target" required="true" size="1" type="CHAR"/>
            <column name="targetid" required="true" type="INTEGER"/>
            <column name="descid" required="true" type="INTEGER"/>
            <column name="commentor" required="true" type="INTEGER"/>
            <column name="cmttime" required="true" type="TIMESTAMP"/>
        </table>
        <table name="repbug">
            <column name="report" primaryKey="true" required="true" type="INTEGER"/>
            <column name="bug" primaryKey="true" required="true" type="INTEGER"/>
        </table>
        <table name="report">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="source" required="true" size="1" type="CHAR"/>
            <column name="srcid" required="true" type="INTEGER"/>
            <column name="submitted" required="true" type="TIMESTAMP"/>
            <column name="submitter" required="true" type="INTEGER"/>
            <column name="responsible" required="true" type="INTEGER"/>
            <column name="confidence" required="true" size="1" type="CHAR"/>
            <column name="severity" required="true" size="1" type="CHAR"/>
            <column name="priority" required="true" size="1" type="CHAR"/>
            <column name="state" required="true" size="1" type="CHAR"/>
            <column name="bugclass" required="true" size="1" type="CHAR"/>
            <column name="project" required="true" size="8" type="CHAR"/>
            <column name="category" required="true" size="8" type="CHAR"/>
            <column name="subcat" required="true" size="8" type="CHAR"/>
            <column name="repdesc" required="true" type="INTEGER"/>
            <column name="envdesc" required="true" type="INTEGER"/>
            <column name="repro" type="INTEGER"/>
            <column name="around" type="INTEGER"/>
	    <foreign-key foreignTable="severity">
	       <reference local="severity" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="priority">
	       <reference local="priority" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="state">
	       <reference local="state" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="bugclass">
	       <reference local="bugclass" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="person">
	       <reference local="srcid" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="person">
	       <reference local="responsible" foreign="id" />
	    </foreign-key>
        </table>
        <table name="sequence">
            <column name="name" primaryKey="true" required="true"
                size="64" type="CHAR"/>
            <column name="nextseq" required="true" type="INTEGER"/>
        </table>
        <table name="severity">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="info" size="255" type="CHAR"/>
            <column name="lvl" required="true" type="INTEGER"/>
        </table>
        <table name="state">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="info" size="255" type="CHAR"/>
            <column name="lvl" required="true" type="INTEGER"/>
        </table>
        <table name="subscribe">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="subtype" required="true" size="1" type="CHAR"/>
            <column name="project" size="8" type="CHAR"/>
            <column name="category" size="8" type="CHAR"/>
            <column name="subcat" size="8" type="CHAR"/>
            <column name="target" required="true" size="1" type="CHAR"/>
            <column name="targetid" required="true" type="INTEGER"/>
            <column name="subscriber" required="true" type="INTEGER"/>
        </table>
        <table name="subtype">
            <column name="id" primaryKey="true" required="true" size="1" type="CHAR"/>
            <column name="name" required="true" size="32" type="CHAR"/>
            <column name="desctext" required="true" size="255" type="CHAR"/>
        </table>
        <table name="bug">
            <column name="id" primaryKey="true" required="true" type="INTEGER"/>
            <column name="source" required="true" size="1" type="CHAR"/>
            <column name="srcid" required="true" type="INTEGER"/>
            <column name="responsible" required="true" type="INTEGER"/>
            <column name="opened" required="true" type="TIMESTAMP"/>
            <column name="closed" type="TIMESTAMP"/>
            <column name="confidence" required="true" size="1" type="CHAR"/>
            <column name="severity" required="true" size="1" type="CHAR"/>
            <column name="priority" required="true" size="1" type="CHAR"/>
            <column name="state" required="true" size="1" type="CHAR"/>
            <column name="bugclass" required="true" size="1" type="CHAR"/>
            <column name="project" required="true" size="8" type="CHAR"/>
            <column name="category" required="true" size="8" type="CHAR"/>
            <column name="subcat" required="true" size="8" type="CHAR"/>
            <column name="bugdesc" primaryKey="true" required="true" type="INTEGER"/>
            <column name="envdesc" primaryKey="true" required="true" type="INTEGER"/>
            <column name="repro" type="INTEGER"/>
            <column name="around" type="INTEGER"/>
	    <foreign-key foreignTable="description">
	       <reference local="bugdesc" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="envdesc">
	       <reference local="envdesc" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="confidence">
	       <reference local="confidence" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="severity">
	       <reference local="severity" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="priority">
	       <reference local="priority" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="state">
	       <reference local="state" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="bugclass">
	       <reference local="bugclass" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="person">
	       <reference local="srcid" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="person">
	       <reference local="responsible" foreign="id" />
	    </foreign-key>
	    <foreign-key foreignTable="category">
	       <reference local="project" foreign="pkg" />
	       <reference local="category" foreign="cat" />
	       <reference local="subcat" foreign="sub" />
	    </foreign-key>
        </table>
    </database>
</app-data>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to