I have a table with name value pairs in a generic data base.

I am using Criteria functionality to try to get the results out. However, I am running into problem with using multiple criteria.

For Example if the table contains name value pairs of First Names and Last Names. I can use criteria to get all the matches for First Name, and I can use to get matches for Last Names. But if I try to get results, which have First Names associated with Last Names, I can't get it working.

I am not sure what I am doing wrong

Here is an example of the code I am using




if I just use either First Column or Second Column for looking up values, everything is fine. But when I try both, nothing comes back. Any ideas? Am I clear with my question.

Thanks for all the help.

I'm not sure what you want to achieve ? Do you need an or condition for firstname and lastname ?



And I'm not sure what you mean with columns in your example. Keep in mind that HQL works on properties not columns.

Sorry I don't think I was clear. From what I understand the table is structured generically, so Essentially there are two columns in the table. One for Columns Names, and the other is for values associated with it. So it would look something like this:




What this allows us to do is add a new column, w/o changing the table. When I try to use both criterias, as I explained before, to me it seems like Hibernate is trying to match a record which has both First Name and Last Name, yet all records can have only First Name or Last Name and not both.

But I need to get the record, which contains a First Name in the Fname column and Last Name in the Lname column, so they belong to the same person.

And I have tried using "and" operators, and I get nothing back. When I use "or" operators, it brings back all matches for First Name, and then all matches for Last Name, but it doesn't look at the results to see if they are associated with each other. Essentially doing two different calls. Its like it doesn't know how First Names and Last Names go together.

By columns I do mean properties. I am sorry about that, I am still learning Hibernate lingo.

Can you post your mapping ?

I am not sure I know that that is, you mean the table structure?

and I thought about this some more, I think I need something like an inner join.

The part where you "map" classes and properties to tables and columns. Looking at your code sample I suppose you really meant "hibernate" and are programming in java ? You got the wrong group, this is NHibernate, the port to .Net.

But when you post the "mapping" information I can help, but posting to the Hibernate part of the forum won't hurt.

Thank you for your answers. I talked to some folks at work and we decided to create a dynamic query. That did the job. It seems at this point its somewhat difficult to create a crieteria search with name-value pairs in Hibernate.