Hi All, I'm new to this forum and also to Hibernate. I'm facing a problem can anyone help me out. I'll just try to explain the problem with an example. I have two tables A and B. Table B contains some String with a corresponding Integer values (key value pair consider it that way). Now I want to insert values in table A but before that i need to get the integer value of the string (dynamic) stored in the B table. Can anyone tell me how can i do this in the Mapping XML itself and also how to pass the parameter (that is the string) for the where condition.