Using Hibernate only for JDBC Connection

sameermiddha · **Joined:** Wed Feb 15, 2006 6:32 am **Posts:** 2

Can i use Hibernate just for making JDBC Connection and getting a session and not using Hibernate for Object Relational Mapping. I want to use SQL after connection is made to database for returning rows from the database by using ResultSet in JDBC because in our case View tables are used for querying.When the View is created there are so many records which are retrieved and when we query on that view we reqire very few records so there are performance issues...So what i thought of using Hibernate for Connection and then without creating View using Sql to get the Resultset instead of getting objects(using Hibernate) as there is no information regarding the constaints used in the table so using mapping files would be peculiar thing to do(i guess so)
Can anybody help me out or suggest any other solution

max · **Posted:** Mon Mar 13, 2006 10:31 am

nothing prevents you from mapping an object to a view or use native sql queries and still get mapped objects.

if you are only going to use sql completely why then at all bother with configuring hibernate ?