I have two classes A.java and B.java in the project I use.
I have mappings for these classes.
I have a table (table C) containing only a single column (used to make the drop down in the jsp page).
This is not associated with any class A or B.
I want to call a stored procedure to get these values(select single column from table C).
Can I call the stored procedure without creating a class for this?
Its odd to mix Hibernate, which is designed to allow your code to be transferable seemlesly accross any type of RDBMS, and stored procedures, which tightly couple you to one RDBMS. You would normally use a stored procedure from Hibernate for a piece of database logic Hibernate can't perform (e.g. create a new database user etc). You may be shooting yourself in the foot long term for a minor short term gain.