Here are my descriptors: | <jbosscmp-jdbc> | <defaults> | <create-table>false</create-table> | <remove-table>false</remove-table> | </defaults> | | <enterprise-beans> | <entity> | <ejb-name>XmlfeedrequestsBean</ejb-name> | <datasource>java:xmlbaseDS</datasource> | <datasource-mapping>Oracle8</datasource-mapping> | <table-name>ctms.xmlfeedrequests</table-name> | </entity> | | </enterprise-beans> | </jbosscmp-jdbc> | | | <?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> | <enterprise-beans> | <entity> | <description>base xml feed request bean</description> | <display-name>XmlfeedrequestsEB</display-name> | <ejb-name>XmlfeedrequestsBean</ejb-name> | <local-home>possystems.transporter.XmlfeedrequestsLocalHome</local-home> | <local>possystems.transporter.XmlfeedrequestsLocal</local> | <ejb-class>possystems.transporter.XmlfeedrequestsBean</ejb-class> | <persistence-type>Container</persistence-type> | <prim-key-class>java.math.BigDecimal</prim-key-class> | <reentrant>False</reentrant> | <abstract-schema-name>Xmlfeedrequests</abstract-schema-name> | <cmp-field> | <field-name>xmlfeedrequestseqid</field-name> | </cmp-field> | <cmp-field> | <field-name>destination</field-name> | </cmp-field> | <cmp-field> | <field-name>action</field-name> | </cmp-field> | <cmp-field> | <field-name>vkey</field-name> | </cmp-field> | <cmp-field> | <field-name>ikey</field-name> | </cmp-field> | <cmp-field> | <field-name>processedflag</field-name> | </cmp-field> | <cmp-field> | <field-name>processeddate</field-name> | </cmp-field> | <cmp-field> | <field-name>statusmessage</field-name> | </cmp-field> | <cmp-field> | <field-name>createdby</field-name> | </cmp-field> | <cmp-field> | <field-name>createddate</field-name> | </cmp-field> | <cmp-field> | <field-name>modifiedby</field-name> | </cmp-field> | <cmp-field> | <field-name>modifieddate</field-name> | </cmp-field> | <primkey-field>xmlfeedrequestseqid</primkey-field> | <query> | <description>auto generated method</description> | <query-method> | <method-name>findByDestination</method-name> | <method-params> | <method-param>java.lang.String</method-param> | </method-params> | </query-method> | <ejb-ql>SELECT OBJECT(x) FROM Xmlfeedrequests AS x WHERE x.destination = ?1</ejb-ql> | </query> | <query> | <description>auto generated method</description> | <query-method> | <method-name>findByWaitingStatus</method-name> | <method-params/> | </query-method> | <ejb-ql>SELECT OBJECT(x) FROM Xmlfeedrequests AS x WHERE x.processedflag = 'W' or x.processedflag = 'R'</ejb-ql> | </query> | <query> | <description>auto generated method</description> | <query-method> | <method-name>findDuplicateWaitingStatus</method-name> | <method-params> | <method-param>java.math.BigDecimal</method-param> | <method-param>java.math.BigDecimal</method-param> | </method-params> | </query-method> | <ejb-ql>SELECT OBJECT(x) FROM Xmlfeedrequests AS x WHERE x.processedflag = 'W' and not x.xmlfeedrequestseqid = ?1 and x.ikey = ?2</ejb-ql> | </query> | <query> | <query-method> | <method-name>findByInSendStatus</method-name> | <method-params/> | </query-method> | <ejb-ql>SELECT OBJECT(o) FROM Xmlfeedrequests o where o.processedflag = 'S'</ejb-ql> | </query> | </entity> | | | </enterprise-beans> | | <assembly-descriptor> | <container-transaction> | <method> | <ejb-name>XmlfeedrequestsBean</ejb-name> | <method-name>*</method-name> | </method> | <trans-attribute>Required</trans-attribute> | </container-transaction> | </assembly-descriptor> | </ejb-jar> | | | <?xml version = '1.0' encoding = 'windows-1252'?> | <!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 3.0//EN" "http://www.jboss.org/j2ee/dtd/jboss_3_0.dtd"> | <jboss> | <enterprise-beans> | <entity> | <ejb-name>XmlfeedrequestsBean</ejb-name> | <jndi-name>XmlfeedrequestsBean</jndi-name> | <local-jndi-name>local/XmlfeedrequestsBean</local-jndi-name> | </entity> | </enterprise-beans> | </jboss> | | Here is the code for the bean: | | import javax.ejb.*; | | /** | * This is the bean class for the XmlfeedrequestsBean enterprise bean. | * Created Dec 15, 2005 10:18:42 AM | * @author aazaroff | */ | public abstract class XmlfeedrequestsBean implements javax.ejb.EntityBean, possystems.transporter.XmlfeedrequestsLocalBusiness { | private javax.ejb.EntityContext context; | | // <editor-fold defaultstate="collapsed" desc="EJB infrastructure methods. Click on the + sign on the left to edit the code."> | // TODO Consider creating Transfer Object to encapsulate data | // TODO Review finder methods | /** | * @see javax.ejb.EntityBean#setEntityContext(javax.ejb.EntityContext) | */ | public void setEntityContext(javax.ejb.EntityContext aContext) { | context = aContext; | } | | /** | * @see javax.ejb.EntityBean#ejbActivate() | */ | public void ejbActivate() { | | } | | /** | * @see javax.ejb.EntityBean#ejbPassivate() | */ | public void ejbPassivate() { | | } | | /** | * @see javax.ejb.EntityBean#ejbRemove() | */ | public void ejbRemove() { | | } | | /** | * @see javax.ejb.EntityBean#unsetEntityContext() | */ | public void unsetEntityContext() { | context = null; | } | | /** | * @see javax.ejb.EntityBean#ejbLoad() | */ | public void ejbLoad() { | | } | | /** | * @see javax.ejb.EntityBean#ejbStore() | */ | public void ejbStore() { | | } | // </editor-fold> | | | public abstract java.math.BigDecimal getXmlfeedrequestseqid(); | public abstract void setXmlfeedrequestseqid(java.math.BigDecimal xmlfeedrequestseqid); | | public abstract java.lang.String getDestination(); | public abstract void setDestination(java.lang.String destination); | | public abstract java.lang.String getAction(); | public abstract void setAction(java.lang.String action); | | public abstract java.lang.String getVkey(); | public abstract void setVkey(java.lang.String vkey); | | public abstract java.math.BigDecimal getIkey(); | public abstract void setIkey(java.math.BigDecimal ikey); | | public abstract java.lang.String getProcessedflag(); | public abstract void setProcessedflag(java.lang.String processedflag); | | public abstract java.sql.Timestamp getProcesseddate(); | public abstract void setProcesseddate(java.sql.Timestamp processeddate); | | public abstract java.lang.String getStatusmessage(); | public abstract void setStatusmessage(java.lang.String statusmessage); | | public abstract java.lang.String getCreatedby(); | public abstract void setCreatedby(java.lang.String createdby); | | public abstract java.sql.Timestamp getCreateddate(); | public abstract void setCreateddate(java.sql.Timestamp createddate); | | public abstract java.lang.String getModifiedby(); | public abstract void setModifiedby(java.lang.String modifiedby); | | public abstract java.sql.Timestamp getModifieddate(); | public abstract void setModifieddate(java.sql.Timestamp modifieddate); | | public abstract java.lang.String getPlatformIndicator (); | | public abstract void setPlatformIndicator (java.lang.String platformIndicator); | | | public java.math.BigDecimal ejbCreate(java.math.BigDecimal xmlfeedrequestseqid, java.lang.String destination, java.lang.String action, java.lang.String vkey, java.math.BigDecimal ikey, java.lang.String processedflag, java.sql.Timestamp processeddate, java.lang.String statusmessage, java.lang.String createdby, java.sql.Timestamp createddate, java.lang.String modifiedby, java.sql.Timestamp modifieddate) throws javax.ejb.CreateException { | if (xmlfeedrequestseqid == null) { | throw new javax.ejb.CreateException("The field \"xmlfeedrequestseqid\" must not be null"); | } | | // TODO add additional validation code, throw CreateException if data is not valid | setXmlfeedrequestseqid(xmlfeedrequestseqid); | setDestination(destination); | setAction(action); | setVkey(vkey); | setIkey(ikey); | setProcessedflag(processedflag); | setProcesseddate(processeddate); | setStatusmessage(statusmessage); | setCreatedby(createdby); | setCreateddate(createddate); | setModifiedby(modifiedby); | setModifieddate(modifieddate); | | return null; | } | | public void ejbPostCreate(java.math.BigDecimal xmlfeedrequestseqid, java.lang.String destination, java.lang.String action, java.lang.String vkey, java.math.BigDecimal ikey, java.lang.String processedflag, java.sql.Timestamp processeddate, java.lang.String statusmessage, java.lang.String createdby, java.sql.Timestamp createddate, java.lang.String modifiedby, java.sql.Timestamp modifieddate) { | // TODO populate relationships here if appropriate | | } | | public void moveWip(java.math.BigDecimal requestSeqid, java.lang.String curPlatform, int wip, java.lang.String message) throws java.sql.SQLException { | //TODO implement moveWip | } | } | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4133283#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...