Hi,
We use Hibernate extensively in our code. Something that has cropped up recently is that where changes in the domain model mean that the SQL ID of the statement changes (since it is generated with the aliases before returning the resultset to Oracle).
This means a statement like
select a, b, c
from taba
Gets submitted to Oracle as
select a as batch1, b as batch2, c as batch3
from taba
but after a change in the domain model can become:
select a as batch11, b as batch22, c as batch33
from taba
This can be a real pain when it comes to plan stability / or if you're using profiles or SPM. Has anybody seen similar or is anybody familiar with a work around from the hibernate side?