Hi,
The simple queries mentioned below are showing up in the DB2 catalog cache as being executed ~800 times, but the number of compilations is showing up as 4294967295.
Is there anything in the way that hibernate prepares queries that might cause them to be compiled instead of pulled from an already-compiled cache on the db2 server? In looking at the code myself I don't think there's anything out of the ordinary there, but I was told this could happen as a result of "explicitly preparing" the query.
Are there any settings or changes I could make that could affect when a prepared statement requires a recompile?
Thanks for your help,
Jenica Humphreys
MountainView Software
---------------
[b]Hibernate version:[/b] 2.1
[b]Mapping documents:[/b]n/a
[b]Name and version of the database you are using:[/b]DB2 8.1 (with Websphere 5, Java 1.3)
[b]The generated SQL (show_sql=true):
select country0_.country_id as
country_id0_, country0_.country_cd as country_cd0_, c
ountry0_.description_txt as descript3_0_ from RM_COUNTRY country0_
where country0_.country_id=? with ur
select insured0_.name_txt as
x0_0_ from RM_INSURED insured0_ where (insured0_.insure d_id=? ) with
ur
select policy0_.policy_nbr as
x0_0_ from RM_Policy policy0_ where (policy0_.policy_i
d=? ) with ur
|