ejb 多数据库操作
ejb多数据库操作
2012-05-0718:06:18|分类：j2ee|字号订阅
<?xmlversion="1.0"encoding="UTF-8"?>
<!--$Id:mysql-ds.xml889482009-05-1514:09:08Zjesper.pedersen$-->
<!--DatasourceconfigforMySQLusing3.0.9availablefrom:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<datasources>
<xa-datasource>
<jndi-name>mysqlds01</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<xa-datasource-propertyname="ServerName">127.0.0.1</xa-datasource-property>
<xa-datasource-propertyname="DatabaseName">test01</xa-datasource-property>
<xa-datasource-propertyname="User">root</xa-datasource-property>
<xa-datasource-propertyname="Password">xinhua</xa-datasource-property>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</xa-datasource>
<xa-datasource>
<jndi-name>mysqlds02</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<xa-datasource-propertyname="ServerName">127.0.0.1</xa-datasource-property>
<xa-datasource-propertyname="DatabaseName">test02</xa-datasource-property>
<xa-datasource-propertyname="User">root</xa-datasource-property>
<xa-datasource-propertyname="Password">xinhua</xa-datasource-property>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</xa-datasource>
</datasources>
@Stateless(name="sm")
@Remote
publicclassStudentManagerBeanimplementsStudentManager{
@PersistenceContext(unitname="test01")
privateEntityManagerem;
@PersistenceContext(unitname="test02")
privateEntityManagerem1;
publicvoidaddStudent(Stringname){
Useru=newUser();
u.setName(name);
em.persist(u);
Personp=newPerson();
p.setName(name+"01");
em1.persist(p);
//thrownewRuntimeException("ohno!");
}
}
<?xmlversion="1.0"encoding="UTF-8"?>
<persistencexmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
version="1.0">
<persistence-unitname="test01"transaction-type="JTA">
<jta-data-source>java:/mysqlds01</jta-data-source>
<class>com.huazhen.jpa.User</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<propertyname="hibernate.hbm2ddl.auto"value="create"/>
<propertyname="hibernate.dialect"value="org.hibernate.dialect.MySQL5Dialect"/>
</properties>
</persistence-unit>
<persistence-unitname="test02"transaction-type="JTA">
<jta-data-source>java:/mysqlds02</jta-data-source>
<class>com.huazhen.jpa.Person</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<propertyname="hibernate.hbm2ddl.auto"value="create"/>
<propertyname="hibernate.dialect"value="org.hibernate.dialect.MySQL5Dialect"/>
</properties>
</persistence-unit>
</persistence>