EJB Query Error

[Sean Li]

the error message is as follows, i don't know the reason. if anybody know the solution, please help me. thanks!
"CallCenterEJB.ejbgrpx": C:\BorlandEnterpriseServer\jdk\bin\javaw -classpath "C:\bea\wlserver\lib\weblogic_sp.jar;C:\bea\wlserver\lib\weblogic.jar;C:\BorlandEnterpriseServer\lib\asrt.jar;C:\BorlandEnterpriseServer\lib\lm.jar;C:\BorlandEnterpriseServer\lib\xmlrt.jar;C:\BorlandEnterpriseServer\lib\vbjorb.jar;C:\BorlandEnterpriseServer\lib\vbejb.jar;C:\BorlandEnterpriseServer\lib\vbsec.jar;C:\BorlandEnterpriseServer\lib\beandt.jar;C:\BorlandEnterpriseServer\lib\dx.jar;C:\BorlandEnterpriseServer\SonicMQ\lib\client.jar;D:\oracle\jdbc\lib\classes12.jar;" weblogic.ejbc -keepgenerated -compiler C:/JBuilder/bin/bcjW D:/source/CallCenter/CallCenterEJB.jar.jar D:/source/CallCenter/CallCenterEJB.jar
"CallCenterEJB.ejbgrpx": ERROR: Error from ejbc: Error while reading 'META-INF/weblogic-cmp-rdbms-jar.xml'. The error was:
"CallCenterEJB.ejbgrpx":
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByName
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.String)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsPersoninfo as p where p.name=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsPersoninfo as p where p.name=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByDepartment
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.String)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsPersoninfo as p where p.department=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsPersoninfo as p where p.department=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findManager
"CallCenterEJB.ejbgrpx": Parameter Types: ()
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsPersoninfo as p where p.manager='1'
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsPersoninfo as p where p.manager='1'
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findChildren
"CallCenterEJB.ejbgrpx": Parameter Types: (long)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsTroubletype as p where p.fid=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsTroubletype as p where p.fid=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findFather
"CallCenterEJB.ejbgrpx": Parameter Types: (long)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsTroubletype as p where p.id=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsTroubletype as p where p.id=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByName
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.String)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsTroubletype as p where p.name=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsTroubletype as p where p.name=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByTroubleType
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.Long)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsApplyform AS p where p.troubletype=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsApplyform AS p where p.troubletype=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByDeclarer
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.String)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsApplyform AS p where p.declarer=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsApplyform AS p where p.declarer=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findNewApplyforms
"CallCenterEJB.ejbgrpx": Parameter Types: ()
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsApplyform as p where p.state=0
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsApplyform as p where p.state=0
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByHandler
"CallCenterEJB.ejbgrpx": Parameter Types: (java.lang.String)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsApplyform as p where p.handler=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsApplyform as p where p.handler=?1
"CallCenterEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"CallCenterEJB.ejbgrpx": While trying to process Finder
"CallCenterEJB.ejbgrpx": Method Name: findByTroubletype
"CallCenterEJB.ejbgrpx": Parameter Types: (long)
"CallCenterEJB.ejbgrpx": EJB Query: select p from CsExperts as p where p.troubletype=?1
"CallCenterEJB.ejbgrpx": )
"CallCenterEJB.ejbgrpx": Could not parse EJB QL expression: select p from CsExperts as p where p.troubletype=?1
"CallCenterEJB.ejbgrpx": ERROR: ejbc found errors

[Andres Gonzalez]

Hi Sean ...
hhmmmm ... I'm not quite sure about it, since you did not post your ejb-jar.xml. Anyways, this ejb-ql is working for me..:

<ejb-ql>
  <![CDATA[SELECT OBJECT(s) FROM Subscription AS s WHERE s.topic = ?1]]>
</ejb-ql>

* notice the CDATA, are you using it? you must use it since some XML parsers might get confused with the ">" tag.
* are you using OBJECT(s)??
hope it helps...
cheers

[Sean Li]

thank u for your reply. the following is my xml file. please check for me.
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ejb-jar (View Source for full doctype...)>
- <ejb-jar>
- <enterprise-beans>
- <session>
<display-name>CsTableIndex</display-name>
<ejb-name>CsTableIndex</ejb-name>
<local-home>callcenter.CsTableIndexLocalHome</local-home>
<local>callcenter.CsTableIndexLocal</local>
<ejb-class>callcenter.CsTableIndexBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/tabeSequence</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>callcenter.CsSequenceHome</local-home>
<local>callcenter.CsSequence</local>
<ejb-link>CsSequence</ejb-link>
</ejb-local-ref>
</session>
- <session>
<display-name>CsCallCenter</display-name>
<ejb-name>CsCallCenter</ejb-name>
<home>callcenter.CsCallCenterHome</home>
<remote>callcenter.CsCallCenter</remote>
<ejb-class>callcenter.CsCallCenterBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Container</transaction-type>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/user</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
<local-home>callcenter.CsUserLocalHome</local-home>
<local>callcenter.CsUserLocal</local>
<ejb-link>CsUser</ejb-link>
</ejb-local-ref>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/applyform</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>callcenter.CsApplyformHome</local-home>
<local>callcenter.CsApplyform</local>
<ejb-link>CsApplyform</ejb-link>
</ejb-local-ref>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/expert</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>callcenter.CsExpertsHome</local-home>
<local>callcenter.CsExperts</local>
<ejb-link>CsExperts</ejb-link>
</ejb-local-ref>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/troubletype</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>callcenter.CsTroubletypeHome</local-home>
<local>callcenter.CsTroubletype</local>
<ejb-link>CsTroubletype</ejb-link>
</ejb-local-ref>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/tableindex</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
<local-home>callcenter.CsTableIndexLocalHome</local-home>
<local>callcenter.CsTableIndexLocal</local>
<ejb-link>CsTableIndex</ejb-link>
</ejb-local-ref>
- <resource-ref>
<description />
<res-ref-name>jdbc/datasource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
- <session>
<display-name>CsUser</display-name>
<ejb-name>CsUser</ejb-name>
<local-home>callcenter.CsUserLocalHome</local-home>
<local>callcenter.CsUserLocal</local>
<ejb-class>callcenter.CsUserBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Container</transaction-type>
- <ejb-local-ref>
<description />
<ejb-ref-name>ejb/person</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>callcenter.CsPersoninfoHome</local-home>
<local>callcenter.CsPersoninfo</local>
<ejb-link>CsPersoninfo</ejb-link>
</ejb-local-ref>
</session>
- <entity>
<display-name>CsApplyform</display-name>
<ejb-name>CsApplyform</ejb-name>
<local-home>callcenter.CsApplyformHome</local-home>
<local>callcenter.CsApplyform</local>
<ejb-class>callcenter.CsApplyformBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>callcenter.CsApplyformPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>CsApplyform</abstract-schema-name>
- <cmp-field>
<field-name>id</field-name>
</cmp-field>
- <cmp-field>
<field-name>declaretime</field-name>
</cmp-field>
- <cmp-field>
<field-name>state</field-name>
</cmp-field>
- <cmp-field>
<field-name>declarer</field-name>
</cmp-field>
- <cmp-field>
<field-name>troubletype</field-name>
</cmp-field>
- <cmp-field>
<field-name>scenario</field-name>
</cmp-field>
- <cmp-field>
<field-name>location</field-name>
</cmp-field>
- <cmp-field>
<field-name>handler</field-name>
</cmp-field>
- <cmp-field>
<field-name>method</field-name>
</cmp-field>
- <cmp-field>
<field-name>handletime</field-name>
</cmp-field>
- <cmp-field>
<field-name>result</field-name>
</cmp-field>
- <cmp-field>
<field-name>resulttime</field-name>
</cmp-field>
- <query>
- <query-method>
<method-name>findByTroubleType</method-name>
- <method-params>
<method-param>java.lang.Long</method-param>
</method-params>
</query-method>
<ejb-ql>select OBJECT(p) from CsApplyform AS p where p.troubletype=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findByDeclarer</method-name>
- <method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select OBJECT(p) from CsApplyform AS p where p.declarer=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findNewApplyforms</method-name>
<method-params />
</query-method>
<ejb-ql>select OBJECT(p) from CsApplyform as p where p.state=0</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findDoneByDate</method-name>
- <method-params>
<method-param>java.util.Date</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsApplyform as p where p.handletime>?1 and p.state=2</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findDoneByPeriod</method-name>
- <method-params>
<method-param>java.util.Date</method-param>
<method-param>java.util.Date</method-param>
</method-params>
</query-method>
<ejb-ql>select OBJECT(p) from CsApplyform AS p where p.state=2 AND p.handletime>begin AND p.handletime<end</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findByHandler</method-name>
- <method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsApplyform as p where p.handler=?1</ejb-ql>
</query>
</entity>
- <entity>
<display-name>CsPersoninfo</display-name>
<ejb-name>CsPersoninfo</ejb-name>
<local-home>callcenter.CsPersoninfoHome</local-home>
<local>callcenter.CsPersoninfo</local>
<ejb-class>callcenter.CsPersoninfoBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>CsPersoninfo</abstract-schema-name>
- <cmp-field>
<field-name>username</field-name>
</cmp-field>
- <cmp-field>
<field-name>name</field-name>
</cmp-field>
- <cmp-field>
<field-name>password</field-name>
</cmp-field>
- <cmp-field>
<field-name>manager</field-name>
</cmp-field>
- <cmp-field>
<field-name>department</field-name>
</cmp-field>
- <cmp-field>
<field-name>location</field-name>
</cmp-field>
- <cmp-field>
<field-name>phone</field-name>
</cmp-field>
- <cmp-field>
<field-name>email</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcbrand</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcos</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcmodel</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcsn</field-name>
</cmp-field>
- <cmp-field>
<field-name>pccpu</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcmemory</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcharddisk</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcmonitor</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcnetadapter</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcvideocarder</field-name>
</cmp-field>
- <cmp-field>
<field-name>pcsoundcarder</field-name>
</cmp-field>
- <cmp-field>
<field-name>printerbrand</field-name>
</cmp-field>
- <cmp-field>
<field-name>printermodel</field-name>
</cmp-field>
- <cmp-field>
<field-name>printersn</field-name>
</cmp-field>
- <cmp-field>
<field-name>memo</field-name>
</cmp-field>
<primkey-field>username</primkey-field>
- <query>
- <query-method>
<method-name>findByName</method-name>
- <method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsPersoninfo as p where p.name=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findByDepartment</method-name>
- <method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsPersoninfo as p where p.department=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findManager</method-name>
<method-params />
</query-method>
<ejb-ql>select object(p) from CsPersoninfo as p where p.manager='1'</ejb-ql>
</query>
</entity>
- <entity>
<display-name>CsExperts</display-name>
<ejb-name>CsExperts</ejb-name>
<local-home>callcenter.CsExpertsHome</local-home>
<local>callcenter.CsExperts</local>
<ejb-class>callcenter.CsExpertsBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>callcenter.CsExpertsPK</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>CsExperts</abstract-schema-name>
- <cmp-field>
<field-name>id</field-name>
</cmp-field>
- <cmp-field>
<field-name>addtime</field-name>
</cmp-field>
- <cmp-field>
<field-name>operator</field-name>
</cmp-field>
- <cmp-field>
<field-name>troubletype</field-name>
</cmp-field>
- <cmp-field>
<field-name>scenario</field-name>
</cmp-field>
- <cmp-field>
<field-name>method</field-name>
</cmp-field>
- <cmp-field>
<field-name>applyformid</field-name>
</cmp-field>
- <query>
- <query-method>
<method-name>findByTroubletype</method-name>
- <method-params>
<method-param>long</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsExperts as p where p.troubletype=?1</ejb-ql>
</query>
</entity>
- <entity>
<display-name>CsTroubletype</display-name>
<ejb-name>CsTroubletype</ejb-name>
<local-home>callcenter.CsTroubletypeHome</local-home>
<local>callcenter.CsTroubletype</local>
<ejb-class>callcenter.CsTroubletypeBean</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>CsTroubletype</abstract-schema-name>
- <cmp-field>
<field-name>id</field-name>
</cmp-field>
- <cmp-field>
<field-name>name</field-name>
</cmp-field>
- <cmp-field>
<field-name>fid</field-name>
</cmp-field>
<primkey-field>id</primkey-field>
- <query>
- <query-method>
<method-name>findChildren</method-name>
- <method-params>
<method-param>long</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsTroubletype as p where p.fid=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findFather</method-name>
- <method-params>
<method-param>long</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsTroubletype as p where p.id=?1</ejb-ql>
</query>
- <query>
- <query-method>
<method-name>findByName</method-name>
- <method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from CsTroubletype as p where p.name=?1</ejb-ql>
</query>
</entity>
- <entity>
<display-name>CsSequence</display-name>
<ejb-name>CsSequence</ejb-name>
<local-home>callcenter.CsSequenceHome</local-home>
<local>callcenter.CsSequence</local>
<ejb-class>callcenter.CsSequenceBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>CsSequence</abstract-schema-name>
- <cmp-field>
<field-name>sequencename</field-name>
</cmp-field>
- <cmp-field>
<field-name>sequenceindex</field-name>
</cmp-field>
<primkey-field>sequencename</primkey-field>
</entity>
</enterprise-beans>
- <relationships>
- <ejb-relation>
<ejb-relation-name>csPersoninfo-csApplyform</ejb-relation-name>
- <ejb-relationship-role>
<description>csPersoninfo</description>
<ejb-relationship-role-name>CsPersoninfoRelationshipRole</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
- <relationship-role-source>
<description>csPersoninfo</description>
<ejb-name>CsPersoninfo</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csApplyform</description>
<cmr-field-name>csApplyform_declarer</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
- <ejb-relationship-role>
<description>csApplyform</description>
<ejb-relationship-role-name>CsApplyformRelationshipRole</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
- <relationship-role-source>
<description>csApplyform</description>
<ejb-name>CsApplyform</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csPersoninfo</description>
<cmr-field-name>declarerInfo</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
- <ejb-relation>
<ejb-relation-name>csPersoninfo-csApplyform0</ejb-relation-name>
- <ejb-relationship-role>
<description>csPersoninfo</description>
<ejb-relationship-role-name>CsPersoninfoRelationshipRole</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
- <relationship-role-source>
<description>csPersoninfo</description>
<ejb-name>CsPersoninfo</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csApplyform</description>
<cmr-field-name>csApplyform_handler</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
- <ejb-relationship-role>
<description>csApplyform</description>
<ejb-relationship-role-name>CsApplyformRelationshipRole</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
- <relationship-role-source>
<description>csApplyform</description>
<ejb-name>CsApplyform</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csPersoninfo</description>
<cmr-field-name>handlerInfo</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
- <ejb-relation>
<ejb-relation-name>csPersoninfo-csExperts</ejb-relation-name>
- <ejb-relationship-role>
<description>csPersoninfo</description>
<ejb-relationship-role-name>CsPersoninfoRelationshipRole</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
- <relationship-role-source>
<description>csPersoninfo</description>
<ejb-name>CsPersoninfo</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csExperts</description>
<cmr-field-name>csExperts_operator</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
- <ejb-relationship-role>
<description>csExperts</description>
<ejb-relationship-role-name>CsExpertsRelationshipRole</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
- <relationship-role-source>
<description>csExperts</description>
<ejb-name>CsExperts</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csPersoninfo</description>
<cmr-field-name>operatorInfo</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
- <ejb-relation>
<ejb-relation-name>csTroubletype-csExperts</ejb-relation-name>
- <ejb-relationship-role>
<description>csTroubletype</description>
<ejb-relationship-role-name>CsTroubletypeRelationshipRole</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
- <relationship-role-source>
<description>csTroubletype</description>
<ejb-name>CsTroubletype</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csExperts</description>
<cmr-field-name>csExperts</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
- <ejb-relationship-role>
<description>csExperts</description>
<ejb-relationship-role-name>CsExpertsRelationshipRole</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
- <relationship-role-source>
<description>csExperts</description>
<ejb-name>CsExperts</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csTroubletype</description>
<cmr-field-name>troubletypeInfo</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
- <ejb-relation>
<ejb-relation-name>csTroubletype-csApplyform</ejb-relation-name>
- <ejb-relationship-role>
<description>csTroubletype</description>
<ejb-relationship-role-name>CsTroubletypeRelationshipRole</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
- <relationship-role-source>
<description>csTroubletype</description>
<ejb-name>CsTroubletype</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csApplyform</description>
<cmr-field-name>csApplyform</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
- <ejb-relationship-role>
<description>csApplyform</description>
<ejb-relationship-role-name>CsApplyformRelationshipRole</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
- <relationship-role-source>
<description>csApplyform</description>
<ejb-name>CsApplyform</ejb-name>
</relationship-role-source>
- <cmr-field>
<description>csTroubletype</description>
<cmr-field-name>troubletypeInfo</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
</relationships>
- <assembly-descriptor>
- <container-transaction>
- <method>
<ejb-name>CsApplyform</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsPersoninfo</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsExperts</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsTroubletype</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsSequence</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsTableIndex</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsCallCenter</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
- <container-transaction>
- <method>
<ejb-name>CsUser</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
</assembly-descriptor>
</ejb-jar>

[Sean Li]

the JBuilder 7 made the xml file for me. and i never modify it. and i've checked the examples in JBuilder7. i think it's the same. i don't know why.

[Andres Gonzalez]

I don't know mate... I'm really not an expert but...
you're gettn an error in findByName in CsPersoninfo right?
first of all, modify the query and put it the way it should be (with the cdata, something like this):
<ejb-ql><![CDATA[select object(p) from CsPersoninfo as p where p.name=?1]]</ejb-ql>
test it and see if the error occurs in other line..
- also check your findByName method...
- also check this:

<ejb-ql>select OBJECT(p) from CsApplyform AS p where p.state=2 AND p.handletime>begin AND p.handletime<end</ejb-ql>

change it too.. the parser might think that:
p.handletime>begin is the end of the tag...
let me know so I can also learn... :roll:
good luck

[Sean Li]

let me answer this question by myself. thanks to Andres first.
the error in my ejb ql is i should add a blank before and after the '='. i don't know why, i just checked my code with the samples provided by borland one by one, and found the only difference.
for example, a ejb ql should be:
select p from CsApplyform as p where p.state = 2
notice there are two blanks before and after '='.