Hibernate Community • View topic - database Query pasing for HQL Queries

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

database Query pasing for HQL Queries

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

tarakjoshi

Post subject: database Query pasing for HQL Queries

Posted: Fri Aug 08, 2008 9:02 am

Newbie

Joined: Fri Aug 08, 2008 8:47 am
Posts: 1

Hi Hibernate Gurus,

During one of the performance issue evaluation we found one issue/query

We are using Hibernate 3.0

Quote:

Issue /Query : For some HQL queries AWR Report from Oracle 10g shows that
Section : SQL ordered by Parse Calls , in this section queries are having same Parse Calls and Same Execution For example,

<B>Parse Calls Executions % Total Parses SQL Id
49,739 49,739 21.82 15unhakmkq3rw
</B>

Quote:

upon logging Translated queries also shows it uses bind variables
(example ....this_.realm_guid in (?, ?) and this_.locale_guid in (?, ?) )

Now Hibernate says they are always using PreparedStatement for execution then how is it possible that the parsing and execution are same ?

I am completely unaware in this area.

Help will be much appriciated.

Thanks in advance.
-Tarak

Top

raboof

Post subject:

Posted: Tue Oct 14, 2008 3:47 am

Newbie

Joined: Mon Oct 16, 2006 10:23 am
Posts: 8

We're also seeing this, and would appreciate some documentation on how to make this perform better.

http://forum.hibernate.org/viewtopic.php?t=944025 mentions setting 'conn.setConnectionCachingEnabled(true);' on the connection might help, but a more `practical' guide to setting this up correctly would certainly be useful.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum