Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB Query Error  RSS feed

 
Sean Li
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1561
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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..:

* 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
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1561
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

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
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 '='.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!