Hibernate problem in Sybase, but not with others

nickvajberg · **Joined:** Tue Oct 21, 2003 8:15 am **Posts:** 186

I'M BACK!!!

And the strangest thing happened.

We have a huge application based on Hibernate that works just great in MySQL and Oracle. But when we try it with Sybase, weird things happends.

The problem now is this:

No data is added to the database, yet Hibernate says everyhing's fine. No exceptions... nothing is logged.

However, if we wrap ONE OF THE METHODS having a session inside a transaction, then EVERYTHING is added whether it was added in that session or another. That is, stuff added in one session is added only if it is in a transaction -OR- some other method having a session is transactional.

Crazy stuff.

I see that the MySQL dialact has DEFAULT_BATCH_SIZE while Sybase has NO_BATCH. Does this have anything to do with it?

Any clue?

-nick

emmanuel · **Posted:** Wed Dec 17, 2003 8:04 am

Probably something related to autocommit=true or something.

try to set batch_size=0 on your MySQL version to be sure.