I have an existing app that I am changing to EJB.
In the existing app I retrieve information from the database based on what the user requests.
In my app the where clause is built dynamically for the query. At one point I can have (Name=? and Value=?) occur n number of times (i.e. It could occur an infinite amount of times.
I cannot see a way to implement such an occurrance in EJB-QL. It appears to me that EJB-QL will only take very structured queries and is not capable of supporting dynamicly created ones.
Is this a valid assumption? If not, how does one create dynamic queries?
wrong forum. You want the cmp forum. Try jboss-ql. You are correct that ejb-ql is extremely limited.