Hi Dain The problem is that in rc2 and rc1 it worked well...
before I post it as a bug take a look at the ejb.jar.xml,jboss.xml, and jbosscmp-jdbc.xml obs: all of them are generated by xdoclet Dain Sundstrom wrote: > No I haven't seen it before. I assume you have a bad ejb-jar.xml file, > or you are trying to do something unsupported by JBossCMP (like unknown > primary keys). I just won't know until I see the ejb-jar.xml file. > > -dain > > Emerson Cargnin - MSA wrote: > >> ok, but have you seen some kind of wrong sql generation bug appeareing >> in 3.0.0?? >> >> Dain Sundstrom wrote: >> >>> File a bug report a sourceforge. Make sure to include the >>> ejb-jar.xml file, or the revelent sections if it is huge. >>> >>> -dain >>> >>> Emerson Cargnin - MSA wrote: >>> >>>> I have an CMP application that used to work until rc2, after trying >>>> to use with rc3 or 3.0.0 it start to give me jdbc error. >>>> Here is the ejb-ql and sql generated for it: >>>> >>>> ejb-ql : select object (o) from Praca where p.municipio.uf.oid= ?1 >>>> >>>> sql : >>>> SELECT t0_p.oid FROM PRACA t0_p, MUNICIPIO t2_p_municipio, UF >>>> t1_p_municipio_uf WHERE (t1_p_municipio_uf.oid = ?) AND >>>> (t0_p.=t2_p_municipio.oid AND t2_p_municipio.=t1_p_municipio_uf.oid) >>>> >>>> obs: take a look on the "t0_p.=", it looks really strange... >>>> >>>> i'm gonna test against the cvs HEAD version ... >>>> >>>> there's a n:1 relation from PRACA to MUNICIPIO (locale - > city ) >>>> and a n:1 from MUNICIPIO to UF (city -> state) >>>> >>>> >>>> the jboss.log >>>> >>>> 2002-06-20 16:31:28,143 DEBUG [RMI TCP Connection(2)-127.0.0.2]: >>>> javax.ejb.FinderException: Find failed: java.sql.SQLException: >>>> ORA-01747: invalid user.table.column, table.column, or column >>>> specification >>>> at >>>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:143) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:40) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:472) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:348) > >>>> >>>> at >>>> >org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323) > >>>> >>>> at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:610) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>> >>>> at >>>> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>> >>>> at java.lang.reflect.Method.invoke(Method.java:324) >>>> at >>>> >org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1116) > >>>> >>>> at >>>> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73) >>>> >>>> at >>>> >org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:257) > >>>> >>>> at >>>> >org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79) >>>> >>>> at >>>> >org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44) > >>>> >>>> at >>>> >org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:98) >>>> >>>> at >>>> >org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167) >>>> >>>> at >>>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52) >>>> >>>> at >>>> >org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:104) >>>> >>>> at >>>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:109) >>>> >>>> at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) >>>> at >>>> >org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:227) > >>>> >>>> at >>>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) >>>> >>>> at $Proxy49.findByFilter(Unknown Source) >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> Sponsored by: >>>> ThinkGeek at http://www.ThinkGeek.com/ >>>> _______________________________________________ >>>> Jboss-development mailing list >>>> [EMAIL PROTECTED] >>>> https://lists.sourceforge.net/lists/listinfo/jboss-development >>> >>> >>> >>> >>> >> >> >> >> >> ------------------------------------------------------- >> Sponsored by: >> ThinkGeek at http://www.ThinkGeek.com/ >> _______________________________________________ >> Jboss-development mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-development > > >
<?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>No Description.</description> <display-name>Generated by XDoclet</display-name> <enterprise-beans> <!-- Session Beans --> <session > <description><![CDATA[Session Facade controlador das funcoes relativas ao cadastro]]></description> <ejb-name>ejb/CadastroFacade</ejb-name> <home>br.com.sicredi.cadastro.ambos.ejbinterface.CadastroFacadeHome</home> <remote>br.com.sicredi.cadastro.ambos.ejbinterface.CadastroFacade</remote> <ejb-class>br.com.sicredi.cadastro.servidor.ejb.CadastroFacadeEJB</ejb-class> <session-type>Stateless</session-type> <transaction-type>Container</transaction-type> </session> <session > <description><![CDATA[Session Facade controlador das funcoes relativas a cobranca]]></description> <ejb-name>ejb/CobrancaFacade</ejb-name> <home>br.com.sicredi.cobranca.ambos.ejbinterface.CobrancaFacadeHome</home> <remote>br.com.sicredi.cobranca.ambos.ejbinterface.CobrancaFacade</remote> <ejb-class>br.com.sicredi.cobranca.servidor.ejb.CobrancaFacadeEJB</ejb-class> <session-type>Stateless</session-type> <transaction-type>Container</transaction-type> </session> <session > <description><![CDATA[Session Facade controlador das funcoes relativas a auditoria]]></description> <ejb-name>ejb/AuditoriaFacade</ejb-name> <home>br.com.sicredi.auditoria.ambos.ejbinterface.AuditoriaFacadeHome</home> <remote>br.com.sicredi.auditoria.ambos.ejbinterface.AuditoriaFacade</remote> <ejb-class>br.com.sicredi.auditoria.servidor.ejb.AuditoriaFacadeEJB</ejb-class> <session-type>Stateless</session-type> <transaction-type>Container</transaction-type> </session> <!-- To add session beans that you have deployment descriptor info for, add a file to your merge directory called session-beans.xml that contains the <session></session> markup for those beans. --> <!-- Entity Beans --> <entity > <description><![CDATA[No Description.]]></description> <ejb-name>UF</ejb-name> <local-home>br.com.sicredi.cadastro.servidor.ejb.UFLocalHome</local-home> <local>br.com.sicredi.cadastro.servidor.ejb.UFLocal</local> <ejb-class>br.com.sicredi.cadastro.servidor.ejb.UFEJB</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>java.lang.Long</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>UF</abstract-schema-name> <cmp-field > <description><![CDATA[Method getOid.]]></description> <field-name>oid</field-name> </cmp-field> <cmp-field > <description><![CDATA[Method getSigla.]]></description> <field-name>sigla</field-name> </cmp-field> <cmp-field > <description><![CDATA[Method getNome.]]></description> <field-name>nome</field-name> </cmp-field> <primkey-field>oid</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <result-type-mapping>Local</result-type-mapping> <ejb-ql><![CDATA[select OBJECT(b) from UF b]]></ejb-ql> </query> </entity> <entity > <description><![CDATA[No Description.]]></description> <ejb-name>Banco</ejb-name> <local-home>br.com.sicredi.cadastro.servidor.ejb.BancoLocalHome</local-home> <local>br.com.sicredi.cadastro.servidor.ejb.BancoLocal</local> <ejb-class>br.com.sicredi.cadastro.servidor.ejb.BancoEJB</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>java.lang.Long</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Banco</abstract-schema-name> <cmp-field > <description><![CDATA[]]></description> <field-name>oid</field-name> </cmp-field> <cmp-field > <description><![CDATA[retorna codigo.]]></description> <field-name>codigo</field-name> </cmp-field> <cmp-field > <description><![CDATA[retorna nome]]></description> <field-name>nome</field-name> </cmp-field> <primkey-field>oid</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <result-type-mapping>Local</result-type-mapping> <ejb-ql><![CDATA[select OBJECT(b) from Banco b]]></ejb-ql> </query> </entity> <entity > <description><![CDATA[No Description.]]></description> <ejb-name>Municipio</ejb-name> <local-home>br.com.sicredi.cadastro.servidor.ejb.MunicipioLocalHome</local-home> <local>br.com.sicredi.cadastro.servidor.ejb.MunicipioLocal</local> <ejb-class>br.com.sicredi.cadastro.servidor.ejb.MunicipioEJB</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>java.lang.Long</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Municipio</abstract-schema-name> <cmp-field > <description><![CDATA[retorna Oid]]></description> <field-name>oid</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>sigla</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>nome</field-name> </cmp-field> <primkey-field>oid</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <result-type-mapping>Local</result-type-mapping> <ejb-ql><![CDATA[select OBJECT(b) from Municipio b]]></ejb-ql> </query> </entity> <entity > <description><![CDATA[No Description.]]></description> <ejb-name>Praca</ejb-name> <local-home>br.com.sicredi.cobranca.servidor.ejb.PracaLocalHome</local-home> <local>br.com.sicredi.cobranca.servidor.ejb.PracaLocal</local> <ejb-class>br.com.sicredi.cobranca.servidor.ejb.PracaEJB</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>java.lang.Long</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Praca</abstract-schema-name> <cmp-field > <description><![CDATA[]]></description> <field-name>oid</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>situacao</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>endereco</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>cepInicial</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>cepFinal</field-name> </cmp-field> <primkey-field>oid</primkey-field> <query> <query-method> <method-name>findAll</method-name> <method-params> </method-params> </query-method> <result-type-mapping>Local</result-type-mapping> <ejb-ql><![CDATA[select OBJECT(b) from Praca b]]></ejb-ql> </query> <query> <query-method> <method-name>findByFilter</method-name> <method-params> <method-param>java.lang.Long</method-param> </method-params> </query-method> <result-type-mapping>Local</result-type-mapping> <ejb-ql><![CDATA[select object(p) from Praca p where p.municipio.uf.oid = ?1]]></ejb-ql> </query> </entity> <entity > <description><![CDATA[No Description.]]></description> <ejb-name>Auditoria</ejb-name> <local-home>br.com.sicredi.auditoria.servidor.ejb.AuditoriaLocalHome</local-home> <local>br.com.sicredi.auditoria.servidor.ejb.AuditoriaLocal</local> <ejb-class>br.com.sicredi.auditoria.servidor.ejb.AuditoriaEJB</ejb-class> <persistence-type>Container</persistence-type> <prim-key-class>java.lang.Long</prim-key-class> <reentrant>False</reentrant> <cmp-version>2.x</cmp-version> <abstract-schema-name>Auditoria</abstract-schema-name> <cmp-field > <description><![CDATA[retorna Oid]]></description> <field-name>oid</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>usuario</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>dataHora</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>dadosInput</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>dadosOutput</field-name> </cmp-field> <cmp-field > <description><![CDATA[]]></description> <field-name>transacao</field-name> </cmp-field> <primkey-field>oid</primkey-field> </entity> <!-- To add entity beans that you have deployment descriptor info for, add a file to your 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 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>municipio-praca</ejb-relation-name> <!-- bidirectional --> <ejb-relationship-role > <ejb-relationship-role-name>MunicipioEJB</ejb-relationship-role-name> <multiplicity>One</multiplicity> <relationship-role-source > <ejb-name>Municipio</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>pracas</cmr-field-name> <cmr-field-type>java.util.Collection</cmr-field-type> </cmr-field> </ejb-relationship-role> <ejb-relationship-role > <ejb-relationship-role-name>PracaEJB</ejb-relationship-role-name> <multiplicity>Many</multiplicity> <relationship-role-source > <ejb-name>Praca</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>municipio</cmr-field-name> </cmr-field> </ejb-relationship-role> </ejb-relation> <ejb-relation > <ejb-relation-name>banco-pracas</ejb-relation-name> <!-- bidirectional --> <ejb-relationship-role > <ejb-relationship-role-name>BancoEJB</ejb-relationship-role-name> <multiplicity>One</multiplicity> <relationship-role-source > <ejb-name>Banco</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>pracas</cmr-field-name> <cmr-field-type>java.util.Collection</cmr-field-type> </cmr-field> </ejb-relationship-role> <ejb-relationship-role > <ejb-relationship-role-name>PracaEJB</ejb-relationship-role-name> <multiplicity>Many</multiplicity> <relationship-role-source > <ejb-name>Praca</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>banco</cmr-field-name> </cmr-field> </ejb-relationship-role> </ejb-relation> <ejb-relation > <ejb-relation-name>municipio-uf</ejb-relation-name> <!-- bidirectional --> <ejb-relationship-role > <ejb-relationship-role-name>uf</ejb-relationship-role-name> <multiplicity>One</multiplicity> <relationship-role-source > <ejb-name>UF</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>municipios</cmr-field-name> <cmr-field-type>java.util.Collection</cmr-field-type> </cmr-field> </ejb-relationship-role> <ejb-relationship-role > <ejb-relationship-role-name>municipio</ejb-relationship-role-name> <multiplicity>Many</multiplicity> <relationship-role-source > <ejb-name>Municipio</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>uf</cmr-field-name> </cmr-field> </ejb-relationship-role> </ejb-relation> </relationships> <!-- Assembly Descriptor --> <assembly-descriptor > <!-- finder permissions --> <method-permission > <description>description not supported yet by ejbdoclet</description> <unchecked/> <method > <ejb-name>UF</ejb-name> <method-name>findAll</method-name> <method-params> </method-params> </method> </method-permission> <!-- finder permissions --> <method-permission > <description>description not supported yet by ejbdoclet</description> <unchecked/> <method > <ejb-name>Banco</ejb-name> <method-name>findAll</method-name> <method-params> </method-params> </method> </method-permission> <!-- finder permissions --> <method-permission > <description>description not supported yet by ejbdoclet</description> <unchecked/> <method > <ejb-name>Municipio</ejb-name> <method-name>findAll</method-name> <method-params> </method-params> </method> </method-permission> <!-- finder permissions --> <!-- finder permissions --> <method-permission > <description>description not supported yet by ejbdoclet</description> <unchecked/> <method > <ejb-name>Praca</ejb-name> <method-name>findAll</method-name> <method-params> </method-params> </method> </method-permission> <method-permission > <description>description not supported yet by ejbdoclet</description> <unchecked/> <method > <ejb-name>Praca</ejb-name> <method-name>findByFilter</method-name> <method-params> <method-param>java.lang.Long</method-param> </method-params> </method> </method-permission> <!-- finder permissions --> <!-- finder permissions --> <!-- finder permissions --> <!-- transactions --> <!-- finder transactions --> </assembly-descriptor> </ejb-jar>
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS//EN" "http://www.jboss.org/j2ee/dtd/jboss.dtd";> <jboss> <enterprise-beans> <entity> <ejb-name>UF</ejb-name> <local-jndi-name>local/UF</local-jndi-name> </entity> <entity> <ejb-name>Banco</ejb-name> <local-jndi-name>local/Banco</local-jndi-name> </entity> <entity> <ejb-name>Municipio</ejb-name> <local-jndi-name>local/Municipio</local-jndi-name> </entity> <entity> <ejb-name>Praca</ejb-name> <local-jndi-name>local/Praca</local-jndi-name> </entity> <entity> <ejb-name>Auditoria</ejb-name> <local-jndi-name>local/Auditoria</local-jndi-name> </entity> <session> <ejb-name>ejb/CadastroFacade</ejb-name> <jndi-name>ejb/CadastroFacade</jndi-name> </session> <session> <ejb-name>ejb/CobrancaFacade</ejb-name> <jndi-name>ejb/CobrancaFacade</jndi-name> </session> <session> <ejb-name>ejb/AuditoriaFacade</ejb-name> <jndi-name>ejb/AuditoriaFacade</jndi-name> </session> </enterprise-beans> <resource-managers> </resource-managers> </jboss>
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd";> <jbosscmp-jdbc> <defaults> <datasource>java:/OracleDS</datasource> <datasource-mapping>Oracle8</datasource-mapping> </defaults> <enterprise-beans> <entity> <ejb-name>UF</ejb-name> <cmp-field> <field-name>nome</field-name> <column-name>nome</column-name> </cmp-field> <cmp-field> <field-name>oid</field-name> <column-name>oid</column-name> </cmp-field> <cmp-field> <field-name>sigla</field-name> <column-name>sigla</column-name> </cmp-field> <cmp-field> <field-name>nome</field-name> <column-name>nome</column-name> </cmp-field> <!-- To define load groups for this entity, write a file named jbosscmp-jdbc-load-UFEJB.xml and put it in your mergedir. Write it according to the following DTD slice: <!ELEMENT load-groups (load-group+)> <!ELEMENT load-group (load-group-name, description?, field-name+)> <!ELEMENT load-group-name (#PCDATA)> <!ELEMENT description (#PCDATA)> <!ELEMENT field-name (#PCDATA)> <!ELEMENT eager-load-group (#PCDATA)> <!ELEMENT lazy-load-groups (load-group-name+)> --> </entity> <entity> <ejb-name>Banco</ejb-name> <cmp-field> <field-name>codigo</field-name> <column-name>codigo</column-name> </cmp-field> <cmp-field> <field-name>nome</field-name> <column-name>nome</column-name> </cmp-field> <cmp-field> <field-name>oid</field-name> <column-name>oid</column-name> </cmp-field> <!-- To define load groups for this entity, write a file named jbosscmp-jdbc-load-BancoEJB.xml and put it in your mergedir. Write it according to the following DTD slice: <!ELEMENT load-groups (load-group+)> <!ELEMENT load-group (load-group-name, description?, field-name+)> <!ELEMENT load-group-name (#PCDATA)> <!ELEMENT description (#PCDATA)> <!ELEMENT field-name (#PCDATA)> <!ELEMENT eager-load-group (#PCDATA)> <!ELEMENT lazy-load-groups (load-group-name+)> --> </entity> <entity> <ejb-name>Municipio</ejb-name> <cmp-field> <field-name>nome</field-name> <column-name>nome</column-name> </cmp-field> <cmp-field> <field-name>oid</field-name> <column-name>oid</column-name> </cmp-field> <cmp-field> <field-name>sigla</field-name> <column-name>sigla</column-name> </cmp-field> <!-- To define load groups for this entity, write a file named jbosscmp-jdbc-load-MunicipioEJB.xml and put it in your mergedir. Write it according to the following DTD slice: <!ELEMENT load-groups (load-group+)> <!ELEMENT load-group (load-group-name, description?, field-name+)> <!ELEMENT load-group-name (#PCDATA)> <!ELEMENT description (#PCDATA)> <!ELEMENT field-name (#PCDATA)> <!ELEMENT eager-load-group (#PCDATA)> <!ELEMENT lazy-load-groups (load-group-name+)> --> </entity> <entity> <ejb-name>Praca</ejb-name> <cmp-field> <field-name>cepFinal</field-name> <column-name>cepFinal</column-name> </cmp-field> <cmp-field> <field-name>cepInicial</field-name> <column-name>cepInicial</column-name> </cmp-field> <cmp-field> <field-name>endereco</field-name> <column-name>endereco</column-name> </cmp-field> <cmp-field> <field-name>oid</field-name> <column-name>oid</column-name> </cmp-field> <cmp-field> <field-name>situacao</field-name> <column-name>situacao</column-name> </cmp-field> <!-- To define load groups for this entity, write a file named jbosscmp-jdbc-load-PracaEJB.xml and put it in your mergedir. Write it according to the following DTD slice: <!ELEMENT load-groups (load-group+)> <!ELEMENT load-group (load-group-name, description?, field-name+)> <!ELEMENT load-group-name (#PCDATA)> <!ELEMENT description (#PCDATA)> <!ELEMENT field-name (#PCDATA)> <!ELEMENT eager-load-group (#PCDATA)> <!ELEMENT lazy-load-groups (load-group-name+)> --> </entity> <entity> <ejb-name>Auditoria</ejb-name> <cmp-field> <field-name>dadosInput</field-name> <column-name>dadosInput</column-name> </cmp-field> <cmp-field> <field-name>dadosOutput</field-name> <column-name>dadosOutput</column-name> </cmp-field> <cmp-field> <field-name>dataHora</field-name> <column-name>dataHora</column-name> </cmp-field> <cmp-field> <field-name>oid</field-name> <column-name>oid</column-name> </cmp-field> <cmp-field> <field-name>transacao</field-name> <column-name>transacao</column-name> </cmp-field> <cmp-field> <field-name>usuario</field-name> <column-name>usuario</column-name> </cmp-field> <!-- To define load groups for this entity, write a file named jbosscmp-jdbc-load-AuditoriaEJB.xml and put it in your mergedir. Write it according to the following DTD slice: <!ELEMENT load-groups (load-group+)> <!ELEMENT load-group (load-group-name, description?, field-name+)> <!ELEMENT load-group-name (#PCDATA)> <!ELEMENT description (#PCDATA)> <!ELEMENT field-name (#PCDATA)> <!ELEMENT eager-load-group (#PCDATA)> <!ELEMENT lazy-load-groups (load-group-name+)> --> </entity> </enterprise-beans> <relationships> <ejb-relation> <ejb-relation-name>municipio-praca</ejb-relation-name> <foreign-key-mapping/> <ejb-relationship-role> <ejb-relationship-role-name>MunicipioEJB</ejb-relationship-role-name> <key-fields> <key-field> <field-name>oid</field-name> <column-name></column-name> </key-field> </key-fields> </ejb-relationship-role> <ejb-relationship-role> <ejb-relationship-role-name>PracaEJB</ejb-relationship-role-name> <key-fields/> </ejb-relationship-role> </ejb-relation> <ejb-relation> <ejb-relation-name>banco-pracas</ejb-relation-name> <foreign-key-mapping/> <ejb-relationship-role> <ejb-relationship-role-name>BancoEJB</ejb-relationship-role-name> <key-fields> <key-field> <field-name>oid</field-name> <column-name></column-name> </key-field> </key-fields> </ejb-relationship-role> <ejb-relationship-role> <ejb-relationship-role-name>PracaEJB</ejb-relationship-role-name> <key-fields/> </ejb-relationship-role> </ejb-relation> <ejb-relation> <ejb-relation-name>municipio-uf</ejb-relation-name> <foreign-key-mapping/> <ejb-relationship-role> <ejb-relationship-role-name>uf</ejb-relationship-role-name> <key-fields> <key-field> <field-name>oid</field-name> <column-name></column-name> </key-field> </key-fields> </ejb-relationship-role> <ejb-relationship-role> <ejb-relationship-role-name>municipio</ejb-relationship-role-name> <key-fields/> </ejb-relationship-role> </ejb-relation> </relationships> <dependent-value-classes> </dependent-value-classes> </jbosscmp-jdbc>
