Hi,

Just wonder how does hibernate supports table partitioning (horizontal / vertical ) for very large databases?

cheers
chuck

that is database level - you can have , for example, oracle partitioning (database server level) and it is transparent to hibernate

Hi,

It seems that it is not so transparent in postgresql. I was trying to insert to table which is partitioned by the rules. Hibernation gives an error as a number of rows did not increase in the main table. The main table is only a projections of the all partitions.

It would be useful to have some way to work with hiberantion and table partitioning on open-source database - postgresql and not only on oracle.

Any suggestions ?

Sincerely,

Pawel

Pawel,
try set custom DML in mapping for your tables
16.4. Custom SQL for create, update and delete

set insert,delete,update commands like commands in psql

the tutorial said
"The stored procedures are in most cases (read: better do it than not) required to return the number of rows inserted/updated/deleted, as Hibernate has some run time checks for the success of the statement."

Although it is about the procedures possible it would be also the true for custom sql. It is probable that after running my custom sql statement it will check the number of rows.

I will have to check this but one should be able to go around this using procedures.

Thanks,

Pawel