Changes between Version 19 and Version 20 of v6/pgsummary

Timestamp:

05/31/2012 09:25:14 AM (14 years ago)

Author:

huangzhong

Comment:

--

v6/pgsummary

@@ -164 +164 @@
 }}}
 
+* 手动开启JPA事务的问题
+{{{
+有些定时任务中使用了
+EntityTransaction et = EnvUtils.getEnv().getEm().getTransaction();
+et.begin()
+//数据库操作
+et.commit()
+这样的事务处理，在oracle版本中运行正常，但在postgresql上抛
+java.lang.IllegalStateException: Not allowed to create transaction on shared EntityManager - use Spring transactions or
+EJB CMT instead
+异常，初步估计和驱动有关，换成以下写法正常
+final EntityManager em = EnvUtils.getEnv().getEm();
+    TransactionTemplate tt = EnvUtils.getEnv().getTransactionTemplate();
+    tt.execute(new TransactionCallbackWithoutResult() {
+        public void doInTransactionWithoutResult(TransactionStatus status) {
+            try {
+                //数据库操作
+            } catch (Exception ex) {
+                ex.printStackTrace();
+                status.setRollbackOnly();
+            }
+        }
+    });
+}}}
+
 == 导数据 ==
 * 字符长度超长