[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Creating Search Querys

[thepriz]

I currently am using jBoss AS 3.2.3 but will most likely move to the latest when funding is available. The problem that I am facing right now is how to customizable search using CMP. I have 5 fields all but 2 are text fields. The text fields are easy as I can always do a q.note LIKE ''; but for Date fields and  my double field they would like to be able to do =,!=,<,<=,>=,>, BETWEEN type searches. Is there an easy way to create the EJB that can do what I want easily or do I have to create a different query for each way they want to query the data? If I have to create a different @jboss.query for each way it may be better to just grab the datasource from jBoss and do JDBC calls and build the queries on the fly. What is the best way to do what I want?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3968987#3968987

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3968987