Problem with finders with mySQL

[saadsheikh]

hi there,
I am using JBOSS 3.2.1 with mySQL. The problem is that the EJB QL is giving a lot of problems. both LIKE of strings and > < operators of time are not giving desired results.

Can anyone help???

Saad

[crhandy]

Are you using the ![CDATA[ejbql statement]] syntax in your <ejb-ql> tags?

[kv_moj]

Hi,

No way to know exactly why you're having this problem without seeing your deploy-descriptors but sometimes it helps to just know that these do work.
I've used LIKE and all the other jbossQL specific operators as well as the <> on most versions of Jboss with mysql no problems - so you're doing something wrong.
If you're still having this problem post your ejb.jar and jbosscmp-jdbc.xml and maybe someone'll see the problem.

kv.