Please take me out from your mailing list! I did not subscribe to any of these.
[EMAIL PROTECTED] --- Dain Sundstrom <[EMAIL PROTECTED]> wrote: >Directionality of a relationship has nothing to do with the table >structure that is automatically generated. If you want an specific >mapping you will have to specify it in the jbosscmp-jdbc.xml file. > >-dain > >Robertson, Jason wrote: > >> I have what I think is a uni-directional relationship >> (RoleEJB->OrganizationTypeEJB), but when the SQL code is generated for >> OrganizationTypeEJB it includes an unexpected column >> "RoleEJB_organizationType" that appears to be a foreign key back to the >> RoleEJB. For example: >> >> ...JDBCCreateEntityCommand.OrganizationTypeEJB] Insert Entity SQL: >> INSERT INTO organizationtype (name, description, RoleEJB_organizationType) >> VALUES (?, ?, ?) >> >> I'm creating the tables on my own, and I don't have this column so obviously >> it can't load an OrganizationTypeEJB. >> >> Why is this? Do I have something configured wrong? >> >> Here's the meaningful parts of my ejb-jar file (no entries in the >> jbosscmp-jdbc.xml): >> >> <enterprise-beans> >> >> <!-- OrganizationTypeEntity --> >> <entity> >> <ejb-name>OrganizationTypeEJB</ejb-name> >> <local>...OrganizationTypeEntity</local> >> <local-home>...OrganizationTypeEntityHome</local-home> >> <ejb-class>...OrganizationTypeEntityBean</ejb-class> >> <persistence-type>Container</persistence-type> >> <prim-key-class>java.lang.String</prim-key-class> >> <reentrant>false</reentrant> >> <cmp-version>2.x</cmp-version> >> <abstract-schema-name>OrganizationTypeSchema</abstract-schema-name> >> <cmp-field> >> <field-name>name</field-name> >> </cmp-field> >> <cmp-field> >> <field-name>description</field-name> >> </cmp-field> >> <primkey-field>name</primkey-field> >> <query> >> <description>Find all organization types.</description> >> <query-method> >> <method-name>findAllOrganizationTypes</method-name> >> <method-params /> >> </query-method> >> <ejb-ql><![CDATA[ >> SELECT DISTINCT OBJECT(o) FROM OrganizationTypeSchemaAS o >> ]]></ejb-ql> >> </query> >> </entity> >> >> <!-- RoleEntity --> >> <entity> >> <ejb-name>RoleEJB</ejb-name> >> <local>...RoleEntity</local> >> <local-home>...RoleEntityHome</local-home> >> <ejb-class>...RoleEntityBean</ejb-class> >> <persistence-type>Container</persistence-type> >> <prim-key-class>java.lang.String</prim-key-class> >> <reentrant>false</reentrant> >> <cmp-version>2.x</cmp-version> >> <abstract-schema-name>RoleSchema</abstract-schema-name> >> <cmp-field> >> <field-name>name</field-name> >> </cmp-field> >> <cmp-field> >> <field-name>description</field-name> >> </cmp-field> >> <primkey-field>name</primkey-field> >> <query> >> <description> >> Find all roles for a given organization type. >> </description> >> <query-method> >> <method-name>findAllRoles</method-name> >> <method-params> >> <method-param>...OrganizationTypeEntity</method-param> >> </method-params> >> </query-method> >> <ejb-ql><![CDATA[ >> SELECT DISTINCT OBJECT(r) >> FROM RoleSchema r >> WHERE r.organizationType = ?1 >> ]]></ejb-ql> >> </query> >> </entity> >> >> </enterprise-beans> >> >> <relationships> >> <ejb-relation> >> >> <ejb-relation-name>Role-OrganizationType</ejb-relation-name> >> >> <ejb-relationship-role> >> <ejb-relationship-role-name> >> Role-Spawns-OrgType >> </ejb-relationship-role-name> >> <multiplicity>One</multiplicity> >> <relationship-role-source> >> <ejb-name>RoleEJB</ejb-name> >> </relationship-role-source> >> <cmr-field> >> <cmr-field-name>organizationType</cmr-field-name> >> </cmr-field> >> </ejb-relationship-role> >> >> <ejb-relationship-role> >> <ejb-relationship-role-name> >> OrgType-Fulfills-Role >> </ejb-relationship-role-name> >> <multiplicity>One</multiplicity> >> <relationship-role-source> >> <ejb-name>OrganizationTypeEJB</ejb-name> >> </relationship-role-source> >> </ejb-relationship-role> >> >> </ejb-relation> >> </relationships> >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> JBoss-user mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-user >> > > > >_______________________________________________ >JBoss-user mailing list >[EMAIL PROTECTED] >https://lists.sourceforge.net/lists/listinfo/jboss-user _____________________________________________________________ Get your FREE 6MB web-based e-mail @ 1800-Mail.com A FREE service by WIZIW.COM Powered by one of the fastest e-mail engines, EveryOneNet. UserID : YourName @ 1800-Mail.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user