Hi,
We are using Hibernate 3.0, Java 1.6.0_20 and Oracle 10.2 (and JDBC4 drivers).
We have a table T with a row R which contains BLOB field B in it. The table is used heavily and needed performance tuning. Our DBA's ran Oracle reports and said they noticed occasional "update T" statement right after an "INSERT INTO T". In our code, we only have INSERT statements, no updates. So where are the updates coming from? Here is how we are saving the data with Hibernate.
Object R = new R(); // new Row - This maps to an object in our application R.setField1("Field1"); R.setBlob(B); // B is the BLOB field. It is a serialized object in our application session.persist(R);
The size of the BLOB varies anywhere from 2K to 20K. Any help would be greatly appreciated.
Thanks, Jay Malde
|