Hi Saroi,
not exactly - in this case I use session beans for calling data access
layer that accesses database. Connection is picked up from pool and used.
So in this case I do not use entity beans.
Thanks
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 18:15
Please respond to jboss-user
Hi Marek,
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]] On Behalf Of
>[EMAIL PROTECTED]
>Sent: Friday, December 20, 2002 10:13 PM
>To: [EMAIL PROTECTED]
>Subject: RE: [JBoss-user] TRANSACTION ISOLATION and ORACLE
>
>
>
>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.
Yes, there is no such thing for Session Bean.
But, how are you accessing Entity Beans? You must be calling
Them through Session Beans only.
Or, you are making JDBC Calls?
>
>
>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
>
-------------------------------------------------------
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
