I have a problem with a query in my application performing very slow. Using hibernate 4.3.11 and Java EE 1.7 against an oracle 11g database.

I have a query I am using with a single bind parameter. I have hibernate.show_sql turned on and I can take the query from the log output and run an explain plan on it to see the cost is very low. Running the query directly against the database (using toad or sqlplus) takes 30ms. When it is executed in my application it takes over 15 seconds. Is it possible the query being run from hibernate is not what is being printed to the output log? Can someone tell me how to figure this out?

Thanks

Most likely that you are fetching a lot of data. The query on the DB side might take less because you don't transform the objects and process them from JDBC. If there are many records, try using pagination or batch processing.

After some more digging I have discovered this is a problem with Oracle Dates and Timestamps vs Java Date and Timestamp.

Relevant SO Topic: http://stackoverflow.com/questions/6612 ... imestamp-o