Problem with ESBDB operation

Posted by chetanparekh on 25-Apr-2011 08:00

We have ESBDB file in Sonic ESB Process which inserts data into table. Sometimes when we send 1000+ messages to this Sonic ESB Process it acquire lock on the database table. The lock getting released only when we shutdown Sonic Domain Manager.

Is there anything we need to take care while doing DB insert through ESBDB file?

My understanding is that by default all database operations performed using ESBDB are executed in auto commit mode.

Technology Partner - Forum

All Replies

Posted by jerem on 04-May-2011 03:44

Hello Chetan,

Did you see a real lock in the DB log file or is it at the process level (message are not taken from the entry endpoint)?

I ask that because if you have an exit queue it can be full and process get blocked.

with no persistance set a reboot can clean the exit destination.

Yes each request is commited.

Regards

Chan Jeremy

This thread is closed