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