Hi all,

Help required for hibernate batch update query being fired in our application hanging

Hibernate version: 3.0.5

Name and version of the database you are using: Oracle 10.1.2

The generated SQL (show_sql=true):
08/10/24 14:42:39 Hibernate: update texts set text=?, field_name=? where text_id=?
08/10/24 14:42:39 Hibernate: update texts set text=?, field_name=? where text_id=?
08/10/24 14:42:39 Hibernate: update texts set text=?, field_name=? where text_id=?


Problems:

1. We have a parent bean and 3 child bean same type which has a CLOB field value.
2. One of field in child bean (CLOB field) is modified and we are setting the modified value in parent bean and updating it.
3.All the child bean are modified and if the value of the field is more say 8000 character for one child the update query is hanging continuously and transaction is not getting committed.
4. From the logs while doing the batch update it is hanging.

Regards,
Vijay

Hi

Your query can be hanging for one of the below reasons.

The database driver you have used has some defects.Please try to use some higher version of driver and check whether it is feasible to perform the update.I have experirnced similar issues in past and we did resolved it after we did a driver upgrade.Please dont use classes12.zip or classes12.jar.

User odbc14.jar belonging to latest version.The driver compatibility can be found inside the jdbc folder of oracle installations.Use the readme.txt from it to the driver variations and use the drivers from this folder only.


If still this is an issue try to convert the field into blob type.this should work.Hope my answer will suffice.

Cheers !
Vikramaditya Garg