Thank you veru much for you're helping me.
I looked at standardjboss.xml but there is no change to set commit option
for session bean - just for entity beans.
Marek
"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 16:15
Please respond to jboss-user
Replies inline
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]] On Behalf Of
>[EMAIL PROTECTED]
>Sent: Friday, December 20, 2002 7:49 PM
>To: [EMAIL PROTECTED]
>Subject: RE: [JBoss-user] TRANSACTION ISOLATION and ORACLE
>
>
>
>Hi Saroj,
>
>thank you for your help.
>Ad 1 - I'm sorry, but what is commit option B/C
These are different ways to handle Transactions and bean life cycle.
Default Commit option is A. You can have a look at
JBOSS_HOME\server\default\
Conf\standardjboss.xml.
I use Commit Option B in this way:
Snippet from jboss.xml
----------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss PUBLIC
"-//JBoss//DTD JBOSS 3.0//EN"
"http://www.jboss.org/j2ee/dtd/jboss_3_0.dtd";>
<jboss>
<secure>false</secure>
<container-configurations>
<container-configuration>
<container-name>
Instance Per Transaction CMP 2.x
EntityBean
</container-name>
<commit-option>B</commit-option>
</container-configuration>
</container-configurations>
<resource-managers/>
<enterprise-beans>
<entity>
<ejb-name>AddressTypeMaster</ejb-name>
<configuration-name>Instance Per Transaction
CMP
2.x EntityBean</configuration-name>
<jndi-name>sdsdsdsd</jndi-name>
<local-jndi-name>dsdsdsdlcoal</local-jndi-name>
</entity>
</enterprise-beans>
</jboss>
May be you can try this.
>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 ?
This problem will not be due to thin driver. I use OCI to handle CLOB.
>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:y
>oursid</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=RA
>RDeployme
>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
-Saroj
-------------------------------------------------------
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
