6 Replies Latest reply on Oct 28, 2004 3:35 AM by ivan

    TransactionRolledBackException, IllegalStateException, JBoss

    ivan Newbie

      Hi all,

      I'm using JBoss 3.2.5. I'm getting a TransactionRolledBackException
      on an entity bean (EZonas) when I add new finder methods
      with serveral argument on some other entity bean.
      If I remove the added finder method then everything works again.
      The weird thing is that the modified entity does work correctly
      whereas the EZonas one just fails because of the change.
      I've tried hot and cold deployment but the problem persists in either
      case.

      I'm going nuts over this problem because I can't add new finder methods
      to other entities.

      I'm using XDoclet to generate the finder methods.
      The tables have no relations whatsoever.
      I've generated the entities using Middlegen.
      The datebase is SQLServer 2000.

      Any help would be appreciated,
      Ivan

      Here's is the stack trace

      2004-10-22 17:04:12,109 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract java.util.Collection com.lctelsystems.pdm.be.ejb.interfaces.EZonaLocalHome.findByPais(java.lang.String) throws javax.ejb.FinderException, causedBy:
      java.lang.IllegalStateException: createBeanClassInstanceCommand == null
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createBeanClassInstance(JDBCStoreManager.java:550)
      at org.jboss.ejb.plugins.CMPPersistenceManager.createBeanClassInstance(CMPPersistenceManager.java:114)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createBeanClassInstance(CachedConnectionInterceptor.java:250)
      at org.jboss.ejb.EntityContainer.createBeanClassInstance(EntityContainer.java:221)
      at org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java:168)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:78)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:128)
      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:94)
      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
      at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:478)
      at org.jboss.ejb.Container.invoke(Container.java:743)
      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:294)
      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
      at $Proxy56.findByPais(Unknown Source)
      at com.lctelsystems.pdm.be.ejb.session.AreaManagerBean.getZonas(Unknown Source)
      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.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      at org.jboss.ejb.Container.invoke(Container.java:723)
      at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
      at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      at sun.rmi.transport.Transport$1.run(Transport.java:148)
      at java.security.AccessController.doPrivileged(Native Method)
      at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      at java.lang.Thread.run(Thread.java:534)

        • 1. Re: TransactionRolledBackException, IllegalStateException, J
          Joan Horta  Tosas Novice

          Please provide ejb-jar.xml and other usefull config files/source classes to help you.

          • 2. Re: TransactionRolledBackException, IllegalStateException, J
            ivan Newbie

            Hi,

            here is the ejb-jar.xml (with additional finder in ET01 making EZonas fail) and further down
            ejb-jar.xml (without additional finder in ET01).


            <?xml version="1.0" encoding="ISO-8859-1"?>

            <!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>

            <![CDATA[No Description.]]>
            <display-name>Generated by XDoclet</display-name>

            <enterprise-beans>

            <!-- Session Beans -->

            <![CDATA[]]>
            <display-name>LoginManager Session Bean</display-name>

            <ejb-name>LoginManager</ejb-name>

            com.lctelsystems.pdm.be.ejb.interfaces.LoginManagerHome
            com.lctelsystems.pdm.be.ejb.interfaces.LoginManager
            <ejb-class>com.lctelsystems.pdm.be.ejb.session.LoginManagerSession</ejb-class>
            <session-type>Stateless</session-type>
            <transaction-type>Container</transaction-type>




            <![CDATA[Sequence generator]]>

            <ejb-name>SequenceSession</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.SequenceSessionLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.SequenceSessionLocal
            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.SequenceSessionSession</ejb-class>
            <session-type>Stateless</session-type>
            <transaction-type>Container</transaction-type>

            <env-entry>
            <env-entry-name>blockSize</env-entry-name>
            <env-entry-type>java.lang.Integer</env-entry-type>
            <env-entry-value><![CDATA[5]]></env-entry-value>
            </env-entry>
            <env-entry>
            <env-entry-name>retryCount</env-entry-name>
            <env-entry-type>java.lang.Integer</env-entry-type>
            <env-entry-value><![CDATA[2]]></env-entry-value>
            </env-entry>

            <ejb-local-ref >
            <ejb-ref-name>ejb/Sequence</ejb-ref-name>
            <ejb-ref-type>Entity</ejb-ref-type>
            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.SequenceLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.SequenceLocal
            <ejb-link>Sequence</ejb-link>
            </ejb-local-ref>




            <![CDATA[]]>
            <display-name>AreaManager Session Bean</display-name>

            <ejb-name>AreaManager</ejb-name>

            com.lctelsystems.pdm.be.ejb.interfaces.AreaManagerHome
            com.lctelsystems.pdm.be.ejb.interfaces.AreaManager
            <ejb-class>com.lctelsystems.pdm.be.ejb.session.AreaManagerSession</ejb-class>
            <session-type>Stateless</session-type>
            <transaction-type>Container</transaction-type>




            <![CDATA[]]>
            <display-name>HotelSearch Session Bean</display-name>

            <ejb-name>HotelSearchManager</ejb-name>

            com.lctelsystems.pdm.be.ejb.interfaces.HotelSearchManagerHome
            com.lctelsystems.pdm.be.ejb.interfaces.HotelSearchManager
            <ejb-class>com.lctelsystems.pdm.be.ejb.session.HotelSearchManagerSession</ejb-class>
            <session-type>Stateless</session-type>
            <transaction-type>Container</transaction-type>




            <![CDATA[]]>
            <display-name>PriceManager Session Bean</display-name>

            <ejb-name>PriceManager</ejb-name>

            com.lctelsystems.pdm.be.ejb.interfaces.PriceManagerHome
            com.lctelsystems.pdm.be.ejb.interfaces.PriceManager
            <ejb-class>com.lctelsystems.pdm.be.ejb.session.PriceManagerSession</ejb-class>
            <session-type>Stateless</session-type>
            <transaction-type>Container</transaction-type>



            <!--
            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 markup for those beans.
            -->

            <!-- Entity Beans -->

            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_hotel table.]]>

            <ejb-name>EHotel</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.EHotelLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.EHotelLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.EHotelCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>EHotel</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the id]]>
            <field-name>id</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the pais]]>
            <field-name>pais</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the zona]]>
            <field-name>zona</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the destino]]>
            <field-name>destino</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the hotel]]>
            <field-name>hotel</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the establecim]]>
            <field-name>establecim</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the categoria]]>
            <field-name>categoria</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomComercial]]>
            <field-name>nomComercial</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomFiscal]]>
            <field-name>nomFiscal</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the direccion1]]>
            <field-name>direccion1</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the direccion2]]>
            <field-name>direccion2</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the codPostal]]>
            <field-name>codPostal</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomMunicipio]]>
            <field-name>nomMunicipio</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomProvincia]]>
            <field-name>nomProvincia</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomResponsable]]>
            <field-name>nomResponsable</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomContacto]]>
            <field-name>nomContacto</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the telefono]]>
            <field-name>telefono</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the fax]]>
            <field-name>fax</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nif]]>
            <field-name>nif</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the codContable]]>
            <field-name>codContable</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the prepagoSn]]>
            <field-name>prepagoSn</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the diasPrepago]]>
            <field-name>diasPrepago</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the formaPago]]>
            <field-name>formaPago</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the desdeFecha]]>
            <field-name>desdeFecha</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the envioCorreo]]>
            <field-name>envioCorreo</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the clAgrupStd]]>
            <field-name>clAgrupStd</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the mailing1]]>
            <field-name>mailing1</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the mailing2]]>
            <field-name>mailing2</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the mailing3]]>
            <field-name>mailing3</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the mailing4]]>
            <field-name>mailing4</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the mailing5]]>
            <field-name>mailing5</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the ficheroTexto]]>
            <field-name>ficheroTexto</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the fechaModifTexto]]>
            <field-name>fechaModifTexto</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the usuModifTexto]]>
            <field-name>usuModifTexto</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the cargue]]>
            <field-name>cargue</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the blqInput]]>
            <field-name>blqInput</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the horaRecogida]]>
            <field-name>horaRecogida</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the lugarRecogida]]>
            <field-name>lugarRecogida</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the facturar]]>
            <field-name>facturar</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the emision]]>
            <field-name>emision</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the email]]>
            <field-name>email</field-name>
            </cmp-field>
            <primkey-field>id</primkey-field>


            <![CDATA[pais is not indexed.]]>
            <query-method>
            <method-name>findByPaisAndZona</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.pais = ?1 AND o.zona = ?2]]></ejb-ql>


            <![CDATA[pais is not indexed.]]>
            <query-method>
            <method-name>findByPaisAndZonaAndDestino</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.pais = ?1 AND o.zona = ?2 AND o.destino = ?3]]></ejb-ql>


            <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(o) FROM EHotel o]]></ejb-ql>


            <![CDATA[pais is not indexed.]]>
            <query-method>
            <method-name>findByPais</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.pais = ?1]]></ejb-ql>


            <![CDATA[zona is not indexed.]]>
            <query-method>
            <method-name>findByZona</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.zona = ?1]]></ejb-ql>


            <![CDATA[destino is not indexed.]]>
            <query-method>
            <method-name>findByDestino</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.destino = ?1]]></ejb-ql>


            <![CDATA[hotel is not indexed.]]>
            <query-method>
            <method-name>findByHotel</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.hotel = ?1]]></ejb-ql>


            <![CDATA[establecim is not indexed.]]>
            <query-method>
            <method-name>findByEstablecim</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.establecim = ?1]]></ejb-ql>


            <![CDATA[categoria is not indexed.]]>
            <query-method>
            <method-name>findByCategoria</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.categoria = ?1]]></ejb-ql>


            <![CDATA[nom_comercial is not indexed.]]>
            <query-method>
            <method-name>findByNomComercial</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomComercial = ?1]]></ejb-ql>


            <![CDATA[nom_fiscal is not indexed.]]>
            <query-method>
            <method-name>findByNomFiscal</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomFiscal = ?1]]></ejb-ql>


            <![CDATA[direccion_1 is not indexed.]]>
            <query-method>
            <method-name>findByDireccion1</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.direccion1 = ?1]]></ejb-ql>


            <![CDATA[direccion_2 is not indexed.]]>
            <query-method>
            <method-name>findByDireccion2</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.direccion2 = ?1]]></ejb-ql>


            <![CDATA[cod_postal is not indexed.]]>
            <query-method>
            <method-name>findByCodPostal</method-name>
            <method-params>
            <method-param>int</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.codPostal = ?1]]></ejb-ql>


            <![CDATA[nom_municipio is not indexed.]]>
            <query-method>
            <method-name>findByNomMunicipio</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomMunicipio = ?1]]></ejb-ql>


            <![CDATA[nom_provincia is not indexed.]]>
            <query-method>
            <method-name>findByNomProvincia</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomProvincia = ?1]]></ejb-ql>


            <![CDATA[nom_responsable is not indexed.]]>
            <query-method>
            <method-name>findByNomResponsable</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomResponsable = ?1]]></ejb-ql>


            <![CDATA[nom_contacto is not indexed.]]>
            <query-method>
            <method-name>findByNomContacto</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nomContacto = ?1]]></ejb-ql>


            <![CDATA[telefono is not indexed.]]>
            <query-method>
            <method-name>findByTelefono</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.telefono = ?1]]></ejb-ql>


            <![CDATA[fax is not indexed.]]>
            <query-method>
            <method-name>findByFax</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.fax = ?1]]></ejb-ql>


            <![CDATA[nif is not indexed.]]>
            <query-method>
            <method-name>findByNif</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.nif = ?1]]></ejb-ql>


            <![CDATA[cod_contable is not indexed.]]>
            <query-method>
            <method-name>findByCodContable</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.codContable = ?1]]></ejb-ql>


            <![CDATA[prepago_sn is not indexed.]]>
            <query-method>
            <method-name>findByPrepagoSn</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.prepagoSn = ?1]]></ejb-ql>


            <![CDATA[dias_prepago is not indexed.]]>
            <query-method>
            <method-name>findByDiasPrepago</method-name>
            <method-params>
            <method-param>short</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.diasPrepago = ?1]]></ejb-ql>


            <![CDATA[forma_pago is not indexed.]]>
            <query-method>
            <method-name>findByFormaPago</method-name>
            <method-params>
            <method-param>short</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.formaPago = ?1]]></ejb-ql>


            <![CDATA[desde_fecha is not indexed.]]>
            <query-method>
            <method-name>findByDesdeFecha</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.desdeFecha = ?1]]></ejb-ql>


            <![CDATA[envio_correo is not indexed.]]>
            <query-method>
            <method-name>findByEnvioCorreo</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.envioCorreo = ?1]]></ejb-ql>


            <![CDATA[cl_agrup_std is not indexed.]]>
            <query-method>
            <method-name>findByClAgrupStd</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.clAgrupStd = ?1]]></ejb-ql>


            <![CDATA[mailing_1 is not indexed.]]>
            <query-method>
            <method-name>findByMailing1</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.mailing1 = ?1]]></ejb-ql>


            <![CDATA[mailing_2 is not indexed.]]>
            <query-method>
            <method-name>findByMailing2</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.mailing2 = ?1]]></ejb-ql>


            <![CDATA[mailing_3 is not indexed.]]>
            <query-method>
            <method-name>findByMailing3</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.mailing3 = ?1]]></ejb-ql>


            <![CDATA[mailing_4 is not indexed.]]>
            <query-method>
            <method-name>findByMailing4</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.mailing4 = ?1]]></ejb-ql>


            <![CDATA[mailing_5 is not indexed.]]>
            <query-method>
            <method-name>findByMailing5</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.mailing5 = ?1]]></ejb-ql>


            <![CDATA[fichero_texto is not indexed.]]>
            <query-method>
            <method-name>findByFicheroTexto</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.ficheroTexto = ?1]]></ejb-ql>


            <![CDATA[fecha_modif_texto is not indexed.]]>
            <query-method>
            <method-name>findByFechaModifTexto</method-name>
            <method-params>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.fechaModifTexto = ?1]]></ejb-ql>


            <![CDATA[usu_modif_texto is not indexed.]]>
            <query-method>
            <method-name>findByUsuModifTexto</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.usuModifTexto = ?1]]></ejb-ql>


            <![CDATA[cargue is not indexed.]]>
            <query-method>
            <method-name>findByCargue</method-name>
            <method-params>
            <method-param>java.math.BigDecimal</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.cargue = ?1]]></ejb-ql>


            <![CDATA[blq_input is not indexed.]]>
            <query-method>
            <method-name>findByBlqInput</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.blqInput = ?1]]></ejb-ql>


            <![CDATA[hora_recogida is not indexed.]]>
            <query-method>
            <method-name>findByHoraRecogida</method-name>
            <method-params>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.horaRecogida = ?1]]></ejb-ql>


            <![CDATA[lugar_recogida is not indexed.]]>
            <query-method>
            <method-name>findByLugarRecogida</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.lugarRecogida = ?1]]></ejb-ql>


            <![CDATA[facturar is not indexed.]]>
            <query-method>
            <method-name>findByFacturar</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.facturar = ?1]]></ejb-ql>


            <![CDATA[emision is not indexed.]]>
            <query-method>
            <method-name>findByEmision</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.emision = ?1]]></ejb-ql>


            <![CDATA[email is not indexed.]]>
            <query-method>
            <method-name>findByEmail</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHotel o WHERE o.email = ?1]]></ejb-ql>

            <!-- Write a file named ejb-finders-EHotelBean.xml if you want to define extra finders. -->



            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_paises table.]]>

            <ejb-name>EPais</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.EPaisLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.EPaisLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.EPaisCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>com.lctelsystems.pdm.be.ejb.interfaces.EPaisPK</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>EPais</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the pais]]>
            <field-name>pais</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nombre]]>
            <field-name>nombre</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nombreAbr]]>
            <field-name>nombreAbr</field-name>
            </cmp-field>


            <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(o) FROM EPais o]]></ejb-ql>


            <![CDATA[nombre is not indexed.]]>
            <query-method>
            <method-name>findByNombre</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EPais o WHERE o.nombre = ?1]]></ejb-ql>


            <![CDATA[nombre_abr is not indexed.]]>
            <query-method>
            <method-name>findByNombreAbr</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EPais o WHERE o.nombreAbr = ?1]]></ejb-ql>

            <!-- Write a file named ejb-finders-EPaisBean.xml if you want to define extra finders. -->



            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_zona table.]]>

            <ejb-name>EZona</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.EZonaLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.EZonaLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.EZonaCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>EZona</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the zona]]>
            <field-name>zona</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the pais]]>
            <field-name>pais</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomZona]]>
            <field-name>nomZona</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the nomZonaAbr]]>
            <field-name>nomZonaAbr</field-name>
            </cmp-field>
            <primkey-field>zona</primkey-field>


            <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(o) FROM EZona o]]></ejb-ql>


            <query-method>
            <method-name>findByPais</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT OBJECT(o) FROM EZona o WHERE o.pais = ?1]]></ejb-ql>

            <!-- Write a file named ejb-finders-EZonaBean.xml if you want to define extra finders. -->



            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_hoc_cu table.]]>

            <ejb-name>EHocCu</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.EHocCuLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.EHocCuLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.EHocCuCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>EHocCu</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the id]]>
            <field-name>id</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the pais]]>
            <field-name>pais</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the zona]]>
            <field-name>zona</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the destino]]>
            <field-name>destino</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the hotel]]>
            <field-name>hotel</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the corrProv]]>
            <field-name>corrProv</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the cupo]]>
            <field-name>cupo</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the tipoHabitacion]]>
            <field-name>tipoHabitacion</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the desde]]>
            <field-name>desde</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the hasta]]>
            <field-name>hasta</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the habitaciones]]>
            <field-name>habitaciones</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the diasRelease]]>
            <field-name>diasRelease</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the prioridad]]>
            <field-name>prioridad</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the regimen]]>
            <field-name>regimen</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the tarifa]]>
            <field-name>tarifa</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the planning]]>
            <field-name>planning</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the fechaCreacion]]>
            <field-name>fechaCreacion</field-name>
            </cmp-field>
            <primkey-field>id</primkey-field>


            <query-method>
            <method-name>findByPaisAndTipoHabAndDesdeAndHastaAndHabitacionesAndTarifa</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.String</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.pais = ?1 AND o.tipoHabitacion = ?2 AND (o.desde < ?3 OR o.desde = ?3) AND (o.hasta < ?4 OR o.hasta = ?4)]]></ejb-ql>


            <query-method>
            <method-name>findByPaisAndZonaAndTipoHabAndDesdeAndHastaAndHabitacionesAndTarifa</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.String</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.pais = ?1 AND o.zona = ?2 AND o.tipoHabitacion = ?3 AND (o.desde < ?4 OR o.desde = ?4) AND (o.hasta > ?5 OR o.hasta = ?5)]]></ejb-ql>


            <query-method>
            <method-name>findByPaisAndZonaAndDestinoAndTipoHabAndDesdeAndHastaAndHabitacionesAndTarifa</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.String</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.pais = ?1 AND o.zona = ?2 AND o.destino = ?3 AND o.tipoHabitacion = ?4 AND (o.desde < ?5 OR o.desde = ?5) AND (o.hasta > ?6 OR o.hasta = ?6)]]></ejb-ql>


            <query-method>
            <method-name>findByPaisAndZonaAndDestinoAndHotelAndTipoHabAndDesdeAndHastaAndHabitacionesAndTarifa</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.String</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.pais = ?1 AND o.zona = ?2 AND o.destino = ?3 AND o.hotel = ?4 AND o.tipoHabitacion = ?5 AND (o.desde < ?6 OR o.desde = ?6) AND (o.hasta > ?7 OR o.hasta = ?7)]]></ejb-ql>


            <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(o) FROM EHocCu o]]></ejb-ql>


            <![CDATA[pais is not indexed.]]>
            <query-method>
            <method-name>findByPais</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.pais = ?1]]></ejb-ql>


            <![CDATA[zona is not indexed.]]>
            <query-method>
            <method-name>findByZona</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.zona = ?1]]></ejb-ql>


            <![CDATA[destino is not indexed.]]>
            <query-method>
            <method-name>findByDestino</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.destino = ?1]]></ejb-ql>


            <![CDATA[hotel is not indexed.]]>
            <query-method>
            <method-name>findByHotel</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.hotel = ?1]]></ejb-ql>


            <![CDATA[corr_prov is not indexed.]]>
            <query-method>
            <method-name>findByCorrProv</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.corrProv = ?1]]></ejb-ql>


            <![CDATA[cupo is not indexed.]]>
            <query-method>
            <method-name>findByCupo</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.cupo = ?1]]></ejb-ql>


            <![CDATA[tipo_habitacion is not indexed.]]>
            <query-method>
            <method-name>findByTipoHabitacion</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.tipoHabitacion = ?1]]></ejb-ql>


            <![CDATA[desde is not indexed.]]>
            <query-method>
            <method-name>findByDesde</method-name>
            <method-params>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.desde = ?1]]></ejb-ql>


            <![CDATA[hasta is not indexed.]]>
            <query-method>
            <method-name>findByHasta</method-name>
            <method-params>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.hasta = ?1]]></ejb-ql>


            <![CDATA[habitaciones is not indexed.]]>
            <query-method>
            <method-name>findByHabitaciones</method-name>
            <method-params>
            <method-param>short</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.habitaciones = ?1]]></ejb-ql>


            <![CDATA[dias_release is not indexed.]]>
            <query-method>
            <method-name>findByDiasRelease</method-name>
            <method-params>
            <method-param>short</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.diasRelease = ?1]]></ejb-ql>


            <![CDATA[prioridad is not indexed.]]>
            <query-method>
            <method-name>findByPrioridad</method-name>
            <method-params>
            <method-param>short</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.prioridad = ?1]]></ejb-ql>


            <![CDATA[regimen is not indexed.]]>
            <query-method>
            <method-name>findByRegimen</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.regimen = ?1]]></ejb-ql>


            <![CDATA[tarifa is not indexed.]]>
            <query-method>
            <method-name>findByTarifa</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.tarifa = ?1]]></ejb-ql>


            <![CDATA[planning is not indexed.]]>
            <query-method>
            <method-name>findByPlanning</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.planning = ?1]]></ejb-ql>


            <![CDATA[fecha_creacion is not indexed.]]>
            <query-method>
            <method-name>findByFechaCreacion</method-name>
            <method-params>
            <method-param>java.sql.Timestamp</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EHocCu o WHERE o.fechaCreacion = ?1]]></ejb-ql>

            <!-- Write a file named ejb-finders-EHocCuBean.xml if you want to define extra finders. -->



            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_user table.]]>

            <ejb-name>EUser</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.EUserLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.EUserLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.EUserCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>EUser</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the id]]>
            <field-name>id</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the idAgency]]>
            <field-name>idAgency</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the branch]]>
            <field-name>branch</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the password]]>
            <field-name>password</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the encryptedPassword]]>
            <field-name>encryptedPassword</field-name>
            </cmp-field>
            <primkey-field>id</primkey-field>


            <![CDATA[idAgency is not indexed.]]>
            <query-method>
            <method-name>findByIdAgencyAndBranch</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EUser o WHERE o.idAgency = ?1 AND o.branch = ?2]]></ejb-ql>


            <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(o) FROM EUser o]]></ejb-ql>


            <![CDATA[idAgency is not indexed.]]>
            <query-method>
            <method-name>findByIdAgency</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EUser o WHERE o.idAgency = ?1]]></ejb-ql>


            <![CDATA[branch is not indexed.]]>
            <query-method>
            <method-name>findByBranch</method-name>
            <method-params>
            <method-param>java.lang.Integer</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EUser o WHERE o.branch = ?1]]></ejb-ql>


            <![CDATA[password is not indexed.]]>
            <query-method>
            <method-name>findByPassword</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EUser o WHERE o.password = ?1]]></ejb-ql>


            <![CDATA[encryptedPassword is not indexed.]]>
            <query-method>
            <method-name>findByEncryptedPassword</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM EUser o WHERE o.encryptedPassword = ?1]]></ejb-ql>

            <!-- Write a file named ejb-finders-EUserBean.xml if you want to define extra finders. -->



            <![CDATA[Sequence Block Entity Bean]]>

            <ejb-name>Sequence</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.SequenceLocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.SequenceLocal

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.SequenceCMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.String</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>Sequence</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the index]]>
            <field-name>index</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the name]]>
            <field-name>name</field-name>
            </cmp-field>
            <primkey-field>name</primkey-field>

            <!-- Write a file named ejb-finders-SequenceBean.xml if you want to define extra finders. -->



            <![CDATA[This class is part of pdmV1, and it is a CMP EJB accessing the e_t01 table.]]>

            <ejb-name>ET01</ejb-name>

            <local-home>com.lctelsystems.pdm.be.ejb.interfaces.ET01LocalHome</local-home>
            com.lctelsystems.pdm.be.ejb.interfaces.ET01Local

            <ejb-class>com.lctelsystems.pdm.be.ejb.entity.ET01CMP</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            False
            <cmp-version>2.x</cmp-version>
            <abstract-schema-name>ET01</abstract-schema-name>
            <cmp-field >
            <![CDATA[Returns the id]]>
            <field-name>id</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the programa]]>
            <field-name>programa</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the hotCpr]]>
            <field-name>hotCpr</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the fDesde]]>
            <field-name>FDesde</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the fHasta]]>
            <field-name>FHasta</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the tipoHab]]>
            <field-name>tipoHab</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the regAlimento]]>
            <field-name>regAlimento</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the impPaxCosto]]>
            <field-name>impPaxCosto</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the cargue]]>
            <field-name>cargue</field-name>
            </cmp-field>
            <cmp-field >
            <![CDATA[Returns the impPaxPvp]]>
            <field-name>impPaxPvp</field-name>
            </cmp-field>
            <primkey-field>id</primkey-field>


            <query-method>
            <method-name>findByProgDesdeFHastaTipoHabRegAlimento</method-name>
            <method-params>
            <method-param>java.lang.String</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.sql.Timestamp</method-param>
            <method-param>java.lang.String</method-param>
            <method-param>java.lang.String</method-param>
            </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT OBJECT(o) FROM ET01 o WHERE o.programa = ?1 AND o.fDesde = ?2 AND o.fHasta = ?3 AND o.tipoHab = ?4 AND o.regAlimento = ?5]]></ejb-ql>


            <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(o) FROM ET01 o]]></ejb-ql>

            <!-- Write a file named ejb-finders-ET01Bean.xml if you want to define extra finders. -->



            <![CDATA[This class

            • 3. Re: TransactionRolledBackException, IllegalStateException, J
              ivan Newbie

              Hi again,

              too much info in the post and the config file got truncated.
              I'll send them to your mail account if that doesn't bother you.

              Cheers,
              Ivan

              • 4. Re: TransactionRolledBackException, IllegalStateException, J
                ivan Newbie

                Hi all,

                error is due to a compilation of EJB-QL sentence.
                There must be a good reason why it doesn't compile
                but I can't see it (yet).


                2004-10-27 14:23:21,484 ERROR [org.jboss.ejb.EntityContainer] Starting failed jboss.j2ee:jndiName=pdmV1-I1.EDestinLocalHome,service=EJB
                org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(o) FROM ET01 o WHERE o.programa = ?1 AND o.fDesde = ?2 AND o.fHasta = ?3 AND o.tipoHab = ?4 AND o.regAlimento = ?5'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException: Unknown terminal field: at line 1, column 63. Encountered: "fDesde" after: "o.")
                at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:52)
                at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:60)

                • 5. Re: TransactionRolledBackException, IllegalStateException, J
                  Joern Newbie

                  mmm, maybe(i'm not an expert ;) <field-name>FDesde</field-name> != o.fDesde = ?2

                  case-sensitiv??

                  • 6. Re: TransactionRolledBackException, IllegalStateException, J
                    ivan Newbie

                    Hi all again,

                    finally got it. The query doesn´t compile because the database fields

                    f_desde and f_hasta

                    have been mapped to
                    FDesde and FHasta in the entity bean but the finder refers to them
                    as
                    o.fDesde and o.fHasta

                    The code is generated by Middlegen 2b and I just cut and paste
                    from the single column finder to create this new finder.
                    Hence watch out for columns that contain an underscore when generating
                    entities from tables using this fantastic tool.

                    Ivan