DB2 配置

zz22

DRIVER CLASS: com.ibm.db2.jcc.DB2Driver

DRIVER LOCATION: db2jcc.jar and db2jcc_license_cu.jar
(Both of these jars must be included)

JDBC URL FORMAT: jdbc:db2://<host>[:<port>]/<database_name>

JDBC URL Examples:

jdbc:db2://127.0.0.1:50000/SAMPLE


JPA 配置
1. 在META-INF下建立persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence
version="1.0"
xmlns="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">
<persistence-unit name="condition-ejb" transaction-type="RESOURCE_LOCAL">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<mapping-file>condition-ejb-orm.xml</mapping-file>
<class>com.shmily.unittest.ConditionCMP</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<property name="javax.persistence.jdbc.driver" value="com.ibm.db2.jcc.DB2Driver"/>
<property name="javax.persistence.jdbc.user" value="dt82201"/>
<property name="javax.persistence.jdbc.password" value="5t6y7u8i"/>
<property name="javax.persistence.jdbc.url" value="jdbc:db2://65.197.28.229:60004/DB20"/>
<property name="eclipselink.target-database" value="DB2" />
<property name="eclipselink.cache.shared.default" value="false" />
<property name="eclipselink.logging.level.sql" value="FINEST" />
<property name="eclipselink.logging.level" value="WARNING" />
</properties>
</persistence-unit>
</persistence>

2. 在Java类里使用 JPA 在容器之外
EntityManagerFactory emf = Persistence.createEntityManagerFactory("condition-ejb");
em = emf.createEntityManager();
来得到EntityManager 来使用JPA.