I'm trying to create a J2EE application which should be deployed on JBoss.
Right now I'm struggeling with CMR relations. I have tried a lot, and looked into the XPetstore sample application to get my Xdoclet tags right. But everything has failed.
I hope you guys can help.
I want to create a CMR relation between to (Entity) beans as follows:
+--------------+ +-----------------+ | XGroup | | Category | | |- 1------0+ --| | +--------------+ +-----------------+
So, this is a bidirectional 1-n relation. Where each XGroup can contain zero or more Categories.
Each category has exactly one parent, which is a XGroup object.
My code get's deployed without any problems. But JBoss creates 3 tables:
CATEGORY, XGROUP, and CATEGORY-XGROUP-XGROUP-CATEGORIES.
I don't think it should be nessecary to have the 3th table. (2 should be enough???)...
I don't see what is causing this. Below is the code for my beans, and the resulting deployment descriptors.
Hope you guys can help!
Many thanks,
Harm de Laat Informatiefabriek The Netherlands
XGroupBean.java:
/* * Created on Jul 7, 2003 * * To change the template for this generated file go to * Window>Preferences>Java>Code Generation>Code and Comments */ package nl.xbase.group.implementation;
import java.rmi.RemoteException; import java.util.Collection;
import javax.ejb.EJBException; import javax.ejb.EntityBean; import javax.ejb.EntityContext; import javax.ejb.RemoveException; import javax.ejb.CreateException;
/**
* GroupBean.java
* @author harm
* Date: Jul 7, 2003
* @ejb.bean
* primkey-field = "id"
* name = "XGroup"
* display-name = "A container to keep categories."
* type = "CMP"
* transaction-type = "Container"
* jndi-name = "ejb/XGroup"
* local-jndi-name = "XGroup"
* view-type = "both"
* cmp-type = "2.x"
* * @ejb.transaction type = "Required"
*/
public abstract class XGroupBean implements EntityBean {
/**
* @ejb.create-method view-type = "both"
* @param id
* @return
* @throws CreateException
*/
public String ejbCreate(String id) throws CreateException {
this.setId(id);
return null;
}
public void ejbPostCreate(String id) throws CreateException {
}
/**
* @ejb.persistent-field
* @ejb.interface-method view-type = "both"
* @ejb.pk-field
* @return
*/
public abstract String getId();
/**
* @ejb.interface-method view-type = "both"
* @param id
*/
public abstract void setId(String id);
/* CMR - fields */
/**
* @ejb.persistent-field
* @ejb.interface-method view-type = "both"
* @ejb.relation
* target-ejb = "Category"
* name = "Group-Category"
* role-name = "GroupHasCategories"
* target-role-name = "CategoryInGroup"
* target-cascade-delete = "yes"
* @jboss.relation
* fk-column = "category_fk"
* related-pk-field = "categoryId"
*/
public abstract Collection getCategories();
/**
* @ejb.interface-method view-type = "both"
* @param categories
*/
public abstract void setCategories(Collection categories);
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbActivate()
*/
public void ejbActivate() throws EJBException, RemoteException {
// TODO Auto-generated method stub
}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbLoad()
*/
public void ejbLoad() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbPassivate()
*/
public void ejbPassivate() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbRemove()
*/
public void ejbRemove()
throws RemoveException, EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbStore()
*/
public void ejbStore() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#setEntityContext(javax.ejb.EntityContext)
*/
public void setEntityContext(EntityContext arg0)
throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#unsetEntityContext()
*/
public void unsetEntityContext() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
}
CategoryBean.java:
/* * Created on Jul 1, 2003 * * To change the template for this generated file go to * Window>Preferences>Java>Code Generation>Code and Comments */ package nl.xbase.category.implementation;
import java.rmi.RemoteException;
import javax.ejb.CreateException; import javax.ejb.EJBException; import javax.ejb.EntityBean; import javax.ejb.EntityContext; import javax.ejb.RemoveException;
import nl.xbase.group.implementation.XGroupLocal;
/**
* CategoryBean.java
* @author harm
* Date: Jul 1, 2003
*
* @ejb.bean
* name = "Category"
* display-name = "A container to keep advertisements."
* type = "CMP"
* transaction-type = "Container"
* jndi-name = "ejb/Category"
* local-jndi-name = "Category"
* view-type = "both"
* cmp-version = "2.x"
* primkey-field = "categoryId"
* @ejb.transaction type = "Required"
*
*
*/
public abstract class CategoryBean implements EntityBean {
/**
* @ejb.create-method view-type = "both"
* @param id
* @return
* @throws CreateException
*/
public String ejbCreate(String id) throws CreateException {
this.setCategoryId(id);
return null;
}
public void ejbPostCreate(String id) throws CreateException {
}
/**
* @ejb.persistent-field
* @ejb.interface-method view-type = "both"
* @ejb.pk-field
* @return
*/
public abstract String getCategoryId();
/**
* @ejb.interface-method view-type = "both"
* @param id
*/
public abstract void setCategoryId(String id);
/* CMR - fields */
/**
* @ejb.persistent-field
* @ejb.interface-method view-type = "both"
* @ejb.relation
* name = "Group-Category"
* role-name = "CategoryInGroup"
* target-role-name = "GroupHasCategories"
* @jboss.relation
* fk-column = "group_fk"
* related-pk-field = "id"
*/
public abstract XGroupLocal getXGroup();
/**
* @ejb.interface-method view-type = "both"
* @param group
*/
public abstract void setXGroup(XGroupLocal group);
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbActivate()
*/
public void ejbActivate() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbLoad()
*/
public void ejbLoad() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbPassivate()
*/
public void ejbPassivate() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbRemove()
*/
public void ejbRemove()
throws RemoveException, EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#ejbStore()
*/
public void ejbStore() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#setEntityContext(javax.ejb.EntityContext)
*/
public void setEntityContext(EntityContext arg0)
throws EJBException, RemoteException {
// TODO Auto-generated method stub}
/* (non-Javadoc)
* @see javax.ejb.EntityBean#unsetEntityContext()
*/
public void unsetEntityContext() throws EJBException, RemoteException {
// TODO Auto-generated method stub}
}
ejb-jar.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd";>
<ejb-jar >
<description><![CDATA[No Description.]]></description> <display-name>Generated by XDoclet</display-name>
<enterprise-beans>
<!-- Session Beans -->
<!--
To add session beans that you have deployment descriptor info for, add
a file to your XDoclet merge directory called session-beans.xml that contains
the <session></session> markup for those beans.
-->
<!-- Entity Beans -->
<entity >
<description><![CDATA[GroupBean.java]]></description>
<display-name>A container to keep categories.</display-name><ejb-name>XGroup</ejb-name>
<home>nl.xbase.group.implementation.XGroupHome</home>
<remote>nl.xbase.group.implementation.XGroup</remote>
<local-home>nl.xbase.group.implementation.XGroupLocalHome</local-home>
<local>nl.xbase.group.implementation.XGroupLocal</local>
<ejb-class>nl.xbase.group.implementation.XGroupCMP</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>XGroup</abstract-schema-name>
<cmp-field >
<description><![CDATA[]]></description>
<field-name>id</field-name>
</cmp-field>
<cmp-field >
<description><![CDATA[]]></description>
<field-name>categories</field-name>
</cmp-field>
<primkey-field>id</primkey-field><!-- Write a file named ejb-finders-XGroupBean.xml if you want to define extra finders. -->
</entity>
<entity >
<description><![CDATA[CategoryBean.java]]></description>
<display-name>A container to keep advertisements.</display-name><ejb-name>Category</ejb-name>
<home>nl.xbase.category.implementation.CategoryHome</home>
<remote>nl.xbase.category.implementation.Category</remote>
<local-home>nl.xbase.category.implementation.CategoryLocalHome</local-home>
<local>nl.xbase.category.implementation.CategoryLocal</local>
<ejb-class>nl.xbase.category.implementation.CategoryCMP</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>Category</abstract-schema-name>
<cmp-field >
<description><![CDATA[]]></description>
<field-name>categoryId</field-name>
</cmp-field>
<cmp-field >
<description><![CDATA[]]></description>
<field-name>XGroup</field-name>
</cmp-field>
<primkey-field>categoryId</primkey-field><!-- Write a file named ejb-finders-CategoryBean.xml if you want to define extra finders. -->
</entity>
<!--
To add entity beans that you have deployment descriptor info for, add
a file to your XDoclet merge directory called entity-beans.xml that contains
the <entity></entity> markup for those beans.
-->
<!-- Message Driven Beans -->
<!--
To add message driven beans that you have deployment descriptor info for, add
a file to your XDoclet merge directory called message-driven-beans.xml that contains
the <message-driven></message-driven> markup for those beans.
-->
</enterprise-beans>
<!-- Relationships -->
<relationships >
<ejb-relation >
<ejb-relation-name>Group-Category</ejb-relation-name><ejb-relationship-role >
<ejb-relationship-role-name>CategoryInGroup</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
<relationship-role-source >
<ejb-name>Category</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>XGroup</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role >
<ejb-relationship-role-name>GroupHasCategories</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
<relationship-role-source >
<ejb-name>XGroup</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>categories</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
</ejb-relation> </relationships>
<!-- Assembly Descriptor -->
<assembly-descriptor >
<!--
To add additional assembly descriptor info here, add a file to your
XDoclet merge directory called assembly-descriptor.xml that contains
the <assembly-descriptor></assembly-descriptor> markup.
--><!-- finder permissions -->
<!-- finder permissions -->
<!-- transactions -->
<container-transaction >
<method >
<ejb-name>XGroup</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
<container-transaction >
<method >
<ejb-name>Category</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction><!-- finder transactions --> </assembly-descriptor>
</ejb-jar>
jboss.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 3.2//EN" "http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd";>
<jboss>
<unauthenticated-principal>nobody</unauthenticated-principal>
<enterprise-beans>
<!--
To add beans that you have deployment descriptor info for, add
a file to your XDoclet merge directory called jboss-beans.xml that contains
the <session></session>, <entity></entity> and <message-driven></message-driven>
markup for those beans.
-->
<entity>
<ejb-name>XGroup</ejb-name>
<jndi-name>ejb/XGroup</jndi-name>
<local-jndi-name>XGroup</local-jndi-name> <method-attributes>
</method-attributes> </entity>
<entity>
<ejb-name>Category</ejb-name>
<jndi-name>ejb/Category</jndi-name>
<local-jndi-name>Category</local-jndi-name> <method-attributes>
</method-attributes></entity>
</enterprise-beans>
<resource-managers> </resource-managers>
</jboss>
jbosscmp-jdbc.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd";>
<jbosscmp-jdbc>
<defaults>
<preferred-relation-mapping>relation-table</preferred-relation-mapping>
</defaults><enterprise-beans>
<!--
To add beans that you have deployment descriptor info for, add
a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml
that contains the <entity></entity> markup for those beans.
--> <entity>
<ejb-name>XGroup</ejb-name> <cmp-field>
<field-name>id</field-name> </cmp-field>
<cmp-field>
<field-name>categories</field-name></cmp-field>
<!-- jboss 3.2 features -->
<!-- optimistic locking does not express the exclusions needed -->
</entity> <entity>
<ejb-name>Category</ejb-name> <cmp-field>
<field-name>categoryId</field-name> </cmp-field>
<cmp-field>
<field-name>XGroup</field-name></cmp-field>
<!-- jboss 3.2 features -->
<!-- optimistic locking does not express the exclusions needed -->
</entity></enterprise-beans>
<relationships>
<ejb-relation>
<ejb-relation-name>Group-Category</ejb-relation-name><ejb-relationship-role>
<ejb-relationship-role-name>CategoryInGroup</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>categoryId</field-name>
<column-name>category_fk</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>GroupHasCategories</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>id</field-name>
<column-name>group_fk</column-name>
</key-field>
</key-fields>
</ejb-relationship-role> </ejb-relation> </relationships>
</jbosscmp-jdbc>
------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
