HI All, I am new to using hibernate and have a question.

After any CRUD operation, I guess I was expecting hibenate to close the session, which would result in the tables also being closed out...But when I view the connection/job on the as400, the tables remain open in a *SHRRD lock (which basically just prevents the table from being move,deleted,etc..).
Is this normal?..Am I doing something wrong?

Just to provide some additional info:
1. We are not specifically calling session.close(), as I obtain the session from factory using getCurrentSession() prior to each transaction (which I believe handles this automatically?).
2. Journalling is not enabled on the database, so the isolation level is set to 0 (none).

Thanks for any help.
Kevin..

It's the QZDASOINIT job right? These are in subsystem QUSRWRK or QSYSWRK.
If you leave the session open, you will indeed see the Open Data Path (ODP) staying open with a shared read lock.

This is nothing to worry about.

Get the table journalled though. CRTJRNRCV, then CRTJRN and associate the two.
Create the receiver as *SYSTEM managed and delete receivers *YES.

Then use STRJRNPF to journal the file to the journal.

Good luck.

Thanks for the response Kango.

You are correct..It is job QZDASOINIT in QUSRWRK.
However I thought that I read somewhere (could be wrong) that using the getCurrentSession() method of the sessionfactory handled the session.close() for you automatically. My understanding was that it was only when you called openSession() that you needed to specifically call close().

Maybe I am just misinterpreting something.

Unfortunetaly, journalling is not an option at this point.