Apparently "with ur" allows the DB2 database to select data without placing any locks on the database tables. I've been asked to add that to any select statement that I send to the database. We're accessing DB2 7.1 on an OS 390.

I've looked through the dialect settings, and was unable to find a place to add that. Is this something that would require me to change the hibernate source to accomodate?

Thanks for your help!
Jenica

Yes, though you _should_ be able to do it in a custom persister that extends EntityPersister. If you have any problem doing this, let me know, and I will make whatever changes are necessary to allow EntityPersister to be more easily extended/customized.

I'm still working on it, and might find a clean solution. What I've noticed so far though is that maybe I need a way to change what Loader is used. I can change that in the persister but it looks like it will require a lot of copying and pasting!

I'll let you know what I come up with.

Thanks for your help!

Jenica

It appears that this could be implemented as an additional lock type, or as another 'piece' of the SQL Select object that could be specified in a dialect.

Overriding the persister doesn't seem to give me access to override all of the loaders, and there doesn't seem to be a good place to catch all of the 'select' SQL to modify it.

Am I missing something?

Thanks again for your help!
Jenica[/u]

I'll probably accept any patch you propose to make this more easily customizable by subclasses. Just tell me what you need (ie. produce a patch)

A patch has been submitted to JIRA.