You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Kevin Sutter (JIRA)" <ji...@apache.org> on 2007/08/17 18:14:30 UTC
[jira] Assigned: (OPENJPA-172) DSRA9250E: Operation
setTransactionIsolation is not allowed during a global transaction for
Shareable Connections.
[ https://issues.apache.org/jira/browse/OPENJPA-172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Sutter reassigned OPENJPA-172:
------------------------------------
Assignee: Albert Lee
I believe Albert has verified that this problem no longer exists, but since he is out on vacation, I will just assign it to him and let him post his findings when he gets back. Since I'm not absolutely sure of the current state, this will not get resolved for the 1.0.0 release cutoff. I will change the release accordingly as well.
> DSRA9250E: Operation setTransactionIsolation is not allowed during a global transaction for Shareable Connections.
> -------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-172
> URL: https://issues.apache.org/jira/browse/OPENJPA-172
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Affects Versions: 0.9.6
> Environment: Websphere 6.1 for zos and DB2 zos V8
> Reporter: Ritika Maheshwari
> Assignee: Albert Lee
>
> My persistence.xml looks like following
> *******************************************************************************************************
> <?xml version="1.0" ?>
> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> version="1.0">
> <persistence-unit name="dwtest" transaction-type="JTA">
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
> <non-jta-data-source>jdbc/ErwwDS</non-jta-data-source>
> <class>ejb.jpa.test.Customer</class>
> <class>ejb.jpa.test.District</class>
> <class>ejb.jpa.test.Warehouse</class>
> <class>ejb.jpa.test.History</class>
> <class>ejb.jpa.test.Item</class>
> <class>ejb.jpa.test.Neworders</class>
> <class>ejb.jpa.test.Orderline</class>
> <class>ejb.jpa.test.Orders</class>
> <class>ejb.jpa.test.Stock</class>
> <properties>
>
> <property name="openjpa.LockManager" value="pessimistic"/>
> <property name="openjpa.ReadLockLevel" value="read"/>
> <property name="openjpa.WriteLockLevel" value="write"/>
> <property name="openjpa.LockTimeout" value="30000"/>
> <property name="openjpa.FetchBatchSize" value="1" />
> <property name="openjpa.jdbc.TransactionIsolation" value="read-committed" />
> <property name="openjpa.Log" value="DefaultLevel=WARN, Runtime=INFO, Tool=INFO,SQL=TRACE"/>
>
> </properties>
> </persistence-unit>
> </persistence>
> *******************************************************************************************************************
> The Orderline entity looks like following
> *************************************************************************************************
> @Entity
> @IdClass(ejb.jpa.test.OrderlineId.class)
> @SequenceGenerator(name="mysequence",sequenceName="ORDER_ID")
> public class Orderline implements Serializable{
>
> @Id
> @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="mysequence")
> java.lang.Integer ol_o_id = null;
> @Id
> java.lang.String ol_d_id = null;
> @Id
> java.lang.String ol_w_id = null;
> @Id
> java.lang.Short ol_number = null;
> java.lang.String ol_i_id = null;
> java.sql.Timestamp ol_delivery_d = null;
> java.lang.String ol_supply_w_id = null;
> java.lang.Short ol_quantity = null;
> java.math.BigDecimal ol_amount = null;
> java.sql.Timestamp itime = null;
> java.lang.String ol_dist_info = null;
> @ManyToOne(fetch=FetchType.LAZY)
> @JoinColumns({
> @JoinColumn(name="ol_o_id", referencedColumnName="o_id"),
> @JoinColumn(name="ol_d_id", referencedColumnName="o_d_id"),
> @JoinColumn(name="ol_w_id", referencedColumnName="o_w_id")
> })
> Orders orders = null;
> @ManyToOne(fetch=FetchType.LAZY)
> @JoinColumns({
> @JoinColumn(name="ol_i_id", referencedColumnName="s_i_id"),
> @JoinColumn(name="ol_supply_w_id", referencedColumnName="s_w_id")
>
> })
> Stock stock = null;
> *************************************************************************************************************************
> Now if I run the following client
> UserTransaction ut = null;
> ClientEJB facade = null;
> EntityManager em = null;
> try {
> Hashtable parms = new Hashtable();
> parms.put( Context.INITIAL_CONTEXT_FACTORY,
> "com.ibm.websphere.naming.WsnInitialContextFactory");
> InitialContext ctx = new InitialContext(parms);
> ut = (UserTransaction) ctx.lookup("java:comp/UserTransaction"); ut.begin();
> em = getFactory().createEntityManager ();
>
> try {
> OpenJPAEntityManager kem = OpenJPAPersistence.cast (em);
> kem.getFetchPlan().setReadLockMode(LockModeType.WRITE);
> stock = (Stock)kem.find(Stock.class,stockKey);
> kem.getFetchPlan().setReadLockMode(null);
>
> } catch (Exception fe) {}
> try {
>
> Timestamp itime = new Timestamp(System.currentTimeMillis());
> Orderline orderLine = new Orderline (districtId, warehouseId,
> new Short((short)ol_number), itemId,null, itemSupplyWarehouseId,new Short((short)itemQuantity), amount, itime, stockDistInfo);
> em.persist(orderLine);
> em.flush();
> ***************************************************************************************************************
> I get the the following stack trace, which appears to happen when we try to get the next value from Sequence
> [3/12/07 13:59:06:496 PDT] 00000020 SystemErr R 3073 TRACE [WebContainer : 0] openjpa.jdbc.SQL - <t 1503025558, conn 1348751460> executing prepstmnt 2134933312 SELECT t0.s_data, t0.s_dist_01, t0.s_dist_02, t0.s_dist_03, t0.s_dist_04, t0.s_dist_05, t0.s_dist_06, t0.s_dist_07, t0.s_dist_08, t0.s_dist_09, t0.s_dist_10, t0.s_order_cnt, t0.s_quantity, t0.s_remote_cnt, t0.s_ytd FROM Stock t0 WHERE t0.s_i_id = ? AND t0.s_w_id = ? WITH RS USE AND KEEP UPDATE LOCKS [params=(String) 000111, (String) 0001]
> [3/12/07 13:59:06:498 PDT] 00000020 SystemErr R 3075 TRACE [WebContainer : 0] openjpa.jdbc.SQL - <t 1503025558, conn 1348751460> [2 ms] spent
> [3/12/07 13:59:06:720 PDT] 00000020 SystemErr R javax.ejb.EJBException: ClientEJB: CreateException: OrderLineLocalHome create failed in placeNewOrder() of ClientEJB; nested exception is: <0|true|0.9.6-incubating> org.apache.openjpa.persistence.PersistenceException: DSRA9250E: Operation setTransactionIsolation is not allowed during a global transaction for Shareable Connections.
> <0|true|0.9.6-incubating> org.apache.openjpa.persistence.PersistenceException: DSRA9250E: Operation setTransactionIsolation is not allowed during a global transaction for Shareable Connections.
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3764)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:80)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:56)
> at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:59)
> at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:159)
> at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:143)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:554)
> at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:435)
> at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:420)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:538)
> at org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:131)
> at org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:471)
> at org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:2662)
> at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:36)
> at org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:845)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1865)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1825)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1609)
> at org.apache.openjpa.kernel.DelegatingBroker.flush(DelegatingBroker.java:959)
> at org.apache.openjpa.persistence.EntityManagerImpl.flush(EntityManagerImpl.java:438)
> at helpers.ClientEJB.placeNewOrder(Unknown Source)
> at erww.web.ErwwController.performServicesForNewOrder(ErwwController.java:550)
> at erww.web.ErwwController.performTask(ErwwController.java:272)
> at erww.web.ErwwController.doGet(ErwwController.java:85)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
>
> Any idea why is this happening is this a bug.It appears like that while trying to get the next value from Sequence JPA tries to get a connection and then on the connection if the isolationLevel is not already READ_COMMITTED it tries to set it to READ_COMMITTED and that is where it blows out
> ritika
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.