tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adxun <ad...@live.cn>
Subject help!!!about openejb standalone transaction control and db2 for mdb
Date Fri, 25 Jan 2013 06:33:48 GMT
<Resource id="DB2" type="DataSource">  
 jdbcDriver=com.ibm.db2.jcc.DB2Driver 
 XADataSource = com.ibm.db2.jcc.DB2XADataSource 
 jdbcurl=.... 
user=.... 
..... 
</Resource>  

<Resource id="H2" type="DataSource">  
 jdbcDriver=org.h2.Driver 
 XADataSource = org.h2.jdbcx.JdbcDataSource 
 jdbcurl=.... 
user=.... 
..... 
</Resource>  

openejb start.... 

warning:XADataSource not supported by "DB2" 

program  work fine below,but tansaction not valid! finally h2 update
sucessed,db2 error,should be both rollback! 


usert.begin(); 


DataSource dx=(DataSource)ctx.lookup ("H2") 
//XAConnection xa=dx.getXAConnection(); 
Connection con= dx.getConnection(); 

con.execute("update.h2_tbl..set ").... 

DataSource dx=(DataSource)ctx.lookup ("DB2") 
//XAConnection xa=dx.getXAConnection(); 
Connection con= dx.getConnection(); 

con.execute("update.db2_tbl..set ").... 



user.commit(); 

..................... 
user.rollback() 

and 

only connect h2 database and execute a sql ,mdb client may received info
from mdb 

if connect db2 database and execute same a sql  mdb client cannot received
info from mdb? 

(sql operation all in mdb and sql execute successed! sql is a update
statement) 

why? 



--
View this message in context: http://openejb.979440.n4.nabble.com/help-about-openejb-standalone-transaction-control-and-db2-for-mdb-tp4660396.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Mime
View raw message