ORA_ROWSCN, Hibernate and Level 2 caching...
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 10 Apr 2009 15:37:11 -0700 (PDT)
OK, first out of the box I'm not a Hibernate expert at all.
We have an issue here where Hibernate is not reading the correct ORA_ROWSCN
from an Oracle table.
Apparently the ORA_ROWSCN that is being read is actually ORA_ROWSCN + 1.
It seems this is the result of level 2 caching. Hibernate isn't very helpful,
telling us that ORA_ROWSCN is not supported when using level 2 caching.
I'm wondering if anyone has seen this, has any experience with this kind of an
issue?
If this seems to OT, then I apologize in advance.
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » ORA_ROWSCN, Hibernate and Level 2 caching... - Robert Freeman
