Hi!

I have a table with only 2 columns, 'KEY' and 'VALUE'. I would like to retrieve a Map object from Hibernate with the key mapped to 'KEY' and value mapped to 'VALUE' instead of having to create a POJO to represent each record and returning as a list, after which I have to manually retrieve each record and store the key and value to a Map object. I'm using Hibernate with Spring, running on Oracle 10g, so I'm using Spring's HibernateTemplate object to perform my database operations. Anybody knows if it is possible in Hibernate to obtain a Map object directly without having the need to create POJO and mapping to the table?

Adrian

if you are using Spring you can just use the JdbcTemplate to access your database directly with SQL statements and not use hibernate.

Ok... But is it possible if I want to use Hibernate to do this? Architecture-wise, this can be messy since both Spring and Hibernate are used to access the database.

Well Hibernate is not really meant to be used that way you have to have the object struct there for it do anything, since it works on object relations not database relations.

As far as the architure goes this should be a problem as long you are not trying to change persistant object directly. If you just using jdbc to query it should be fine. Do it all the time :).

I see.... Hmm... Now I'll have to figure how to declare and obtain the jdbcTemplate. :P Thanks for the info!

Adrian

Well you just have you class that is accessing the data ( your DAO object) extend JdbcDaoSupport and either set or inject your datasource.

Alrighty then... Thanks!