Why I would use JDBC over Hibernate ?

[Sim Kim]

Hi Cameron Wallace McKenzie,

Congrats for the book and Best of Luck !

My question is What are the situations where I would be forced to use JDBC over Hibernate ?

Thanks.
[ June 03, 2008: Message edited by: Ulf Dittmer ]

[Reehan Lalkhanwar]

One could use raw SQL queries when you need to call functions/stored procedures on the DB.
For example:

 select TABLE_SEQUENCE.nextval from dual 

In such situation you can still create a SQLQuery in Hibernate.

[Ulf Dittmer]

I don't think Hibernate has problems dealing with stored procedures.

One area where JDBC is preferable is the batch import of large amounts of data. Using Hibernate (or ORM in general) doesn't add anything to that, but may cause a noticeable slowdown.

[Eric Weinberg]

On one project, i had to use JDBC for some queries that joined on multiple databases.