I'm using Hibernate in a JBoss SEAM application. I want to use partitioning in PostgreSQL. I created a script to partition the table, but when I tried inserting data into it, Hibernate throws an error indicating 0 rows were updated when it expected 1.

I found a possible solution online, but its for a later hibernate version than I'm using in JBoss 4.2.3.GA, which embeds hibernate 3.2.4 SP1.

http://stackoverflow.com/questions/8309 ... postgresql

When I try the code, it indicates batchSize is not visible.

Is there a better way to override the BatchingBatcher class or has someone else encountered the same problem with a different solution?

Any help you can provide would be greatly appreciated.

TIA,

M.

I found a solution that works, but it probably isn't ideal.

Essentially, you redine the entity bean's insert sql statement as denoted in the following post:

http://archives.postgresql.org/pgsql-pe ... g00219.php

By setting ResultCheckStyle.NONE in the SQLInsert annotation, the data is inserted without any issue.