I'm using Hibernate 2.1.3 with Postgres 7.2.1.

I have a method rather big that inserts in several tables in one transaction.
As an example, it inserts:



The method is executing correctly giving no error. The only problem that I'm having is that in "C" table, I only have 83 registers of the total 120!?
And if I remove the 120 in C code section, it inserts correctly in A and in B.

So what's the problem? Do I have to configure some boot parameter to insert that much of data?

Whats interesting is that the method doesn't become slow or anything. And I'm printing all the newly 120 created objects right before saving them.

Do I have to configure for bulk inserts?


Please help. I'm very stuck.

You have asked several hundred questions and, by now, you should know that "enable SQL log output" is the best way to solve that problem. I also recommend you read again that big red warning message before you post.

Thanks for the reply.
I've enabled the debug in my app and I'm showing the generated sql.
What's weird is that, Hibernate is processing all of my 120 objects. But in my DB, I only have 83 registers in C.


Any help please?

Stop begging for help and debug your database. We can't help you if you don't even tell us what database it is!

First, I'm not begging for help. I'm simply asking for help like any other developer on this forum.
Second, if you look closely, you'll see that the DB I'm using is in my first post.

I've never had this problem that's why I'm asking for help to see if there's any parameter that I need to configure for bulk inserts.
Just that.

So go to a postgres forum and tell them that you execute 100 INSERTs and only 80 get saved.

Thanks for the help.
By your answer I guess there's no parameter for bulk inserts.
That was my doubght. I'll see if this is a Postgres matter.