It would have to be optional behavior (ideally, specified by database,
like the type maps), but I think it's a great idea.

On Wed, 21 Mar 2001, Bill Burke wrote:

> Hi all,
> 
> (Where should I email questions like this? Jboss-Dev, Jboss-User, 
> JBoss-CMP? Thanks)
> 
> Why not have the ability to "select for update" in CMP for an EntityBean 
> load?  I know this is unnessary when only one instance of JBoss is 
> running or if the bean is marked as read-only, but what happens when you 
> have more than one JBoss hitting the DB?  Since clustering is not 
> supported, is this a good way to manage multiple instances of JBoss 
> hitting the same datasource?
> 
> You could make all your connections TRANSACTION_SERIALIZABLE, but 
> doesn't that create performance problems?  Also, with serializing, it 
> kind of sucks that the whole transaction is rolled back if one row in 
> one table has serialization issues.
> 
> Also, maybe "select for update" can be used as an optimization for the 
> LOCKING-WAITING performance problem discussed earlier by Marc and Simone.
> 
> Regards,
> Bill
> 
> 
> --
> This is the JBossCMP mailing list. Please send email to '[EMAIL PROTECTED]'
> with the command 'unsubscribe jbosscmp [email@address]' in the body of the mail
> to be removed from this list.
> 

-- 
Dan Christopherson (danch) 
nVisia Technical Architect (www.nvisia.com)

Opinions expressed are mine and do not neccessarily reflect any 
position or opinion of nVISIA.

---------------------------------------------------------------------------
If you're a capitalist and you have the best goods and they're 
free, you don't have to proselytize, you just have to wait.
-Eben Moglen


_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to