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
