RE: Like Statements in orion-ejb-jar.xml

[Chris Turner]

I have used like statements successfully. Make sure of the following: 1) you have created an orion-ejb.jar.xml file in the META-INF directory of your <name>-ejb.jar file. This must contain the query. 2) you have deleted the existing orion-ejb.jar file from the deployment directory if you had already deployed your application. If you just overwrite/edit the orion-ejb-jar.xml in the deployment directory then this will not work.   WARNING: When orion finally supports EJB-QL, the semantics of LIKE will change. EJB-QL does not allow like to be used with input parameters. Hence specifying an EJB-QL query of the type: "SELECT OBJECT(c) FROM Customer c WHERE c.name LIKE ?1" is illegal. You can only use constants or CMP fields in the like. Therefore if you base the running of your application on a LIKE comparison you will not be able to move to full EJB 2.0 compliance without some major reworks.   Chris   -----Original Message----- From: Michael Maurer [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 11:20 To: Orion-Interest Subject: Like Statements in orion-ejb-jar.xml I would like to perform like Statements in finder methods. Therfor I changed in the orion-ejb-jar.xml  the sql Statement to where xxx like ?    ! But Orion always overwrites it to where xxx = ? Is there a way to use like statements in Orion  or do one have to use sql Queries?   Thanks Michael _____________________________________________________________________ This message has been checked for all known viruses by MessageLabs. _________________________________________________________________________ Alison Associates The information contained in this e-mail and any attached files is intended only for the use of the person(s) to whom it is addressed and may be privileged, confidential and exempt from disclosure under applicable law. The views of the author may not necessarily reflect the views of the Company. If you are not the intended recipient please do not copy or convey this message or any attached files to any other person but delete this message and any attached files and notify us of incorrect receipt via e-mail to [EMAIL PROTECTED] _____________________________________________________________________ This message has been checked for all known viruses by MessageLabs.