Hi Saroj,
thank you for your help.
Ad 1 - I'm sorry, but what is commit option B/C
Ad 2 - I have tried it but didn't help. Anyway, I see you use oci jdbc
driver (jdbc:oracle:oci8:@RPM-9I) and I use thin JDBC driver. Do you think
it could be a source of my problem ? Why do you use oci driver ?
Thanks a lot.
Mark
"saroj kumar"
<[EMAIL PROTECTED]> To:
<[EMAIL PROTECTED]>
Sent by: cc: (bcc: Marek
Sedliak/BYS/SOFTIP)
[EMAIL PROTECTED] Subject: RE: [JBoss-user]
TRANSACTION ISOLATION and ORACLE
eforge.net
20.12.2002 13:39
Please respond to jboss-user
Hi Mark,
2 things come to my mind:
1) Try commit option B/C They solve Deadlock problems quite nicely.
2) Add READ COMMITED Isolation Level as shown here in oracle-service.xml
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=OracleDS">
<attribute name="JndiName">OracleDS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:oracle:thin:@youroraclehost:1521:yoursid</c
onfig-property>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:oracle:oci8:@RPM-9I</config-property>
<config-property name="DriverClass"
type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property
>
<!--set these only if you want only default logins,
not through JAAS -->
<config-property name="UserName"
type="java.lang.String">SDSDS</config-property>
<config-property name="Password"
type="java.lang.String">SDSDSD</config-property>
<config-property name="TransactionIsolation"
type="java.lang.String">TRANSACTION_READ_COMMITTED</config-property>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployme
nt,name=JBoss LocalTransaction JDBC Wrapper</depends>
</mbean>
</depends>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]] On Behalf Of
>[EMAIL PROTECTED]
>Sent: Friday, December 20, 2002 5:47 PM
>To: [EMAIL PROTECTED]
>Subject: [JBoss-user] TRANSACTION ISOLATION and ORACLE
>
>
>
>
>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
