David,
thaks. I have tried to set
<config-property name="TransactionIsolation" type
="java.lang.String">TRANSACTION_READ_COMMITTED</config-property>
into oracle-service.xml but it didn't help. Still when I call the second
bean's method with RequiresNew transaction attribute it hangs. Looks like
this setting would have no impact connection.
Thanks.
Marek
David Jencks
<davidjencks@directvinternet To:
[EMAIL PROTECTED]
.com> cc: (bcc: Marek
Sedliak/BYS/SOFTIP)
Sent by: Subject: Re: [JBoss-user]
TRANSACTION ISOLATION and ORACLE
[EMAIL PROTECTED]
eforge.net
20.12.2002 14:15
Please respond to jboss-user
by default jboss doesn't set the tx isolation level. You can only set it
in the datasource configuration, not per bean/method.
You can use names or numbers
for *-service.xml
<config-property name="TransactionIsolation"
type="java.lang.String">READ_COMMITTED</config-property>
for ds.xml
<transaction-isolation>READ_COMMITTED</transaction-isolation>
david jencks
On 2002.12.20 07:16:51 -0500 [EMAIL PROTECTED] wrote:
>
>
> Hi All.
>
> I have already searched the forum but haven't found any answer. Please, I
> would appreciate any suggestions. I have the following problem :
>
> I've got two session beans. The first one has a method with Required
> transaction attribute and the second one has a method with RequiresNew
> transaction attribute. The following code hags - because the first
> transaction is blocking the second one.
>
> // the following code hangs
> class SessionBean {
>
> public void hasRequiredAttribute() {
> .. . . . . . .
> // it hangs here !!
> anotherSessionBean.hasRequiresNewAttribute(); // method 2
>
> } //of method
>
> } //of class
>
> It looks like SERIALIZABLE isolation level is set - in the first method
> (Required attribute) I just query the data (just SELECT) but it locks the
> bean. Does JBoss always use "pessimistic concurrency" at the server level
> ?
> My DB is Oracle and it has its default isolation level set to
> READ_COMMITTED. With this isolation level, the above problem should not
> have occured. How can I determine what isolation level is being
> implemented
> in JBoss? Or how can I change that? I think it should be possible to
> change it in oracle-service.xml. But it looks it doesn't work or I do
> that
> wrong. Also I have tried to set it for a SESSION - didn't help.
>
>
> Thanks a lot.
>
> Mark
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: The Best Geek Holiday Gifts!
> Time is running out! Thinkgeek.com has the coolest gifts for
> your favorite geek. Let your fingers do the typing. Visit Now.
> T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
-------------------------------------------------------
This SF.NET email is sponsored by: The Best Geek Holiday Gifts!
Time is running out! Thinkgeek.com has the coolest gifts for
your favorite geek. Let your fingers do the typing. Visit Now.
T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This SF.NET email is sponsored by: The Best Geek Holiday Gifts!
Time is running out! Thinkgeek.com has the coolest gifts for
your favorite geek. Let your fingers do the typing. Visit Now.
T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
