JPA 配置

最新推荐文章于 2025-08-11 21:13:32 发布

原创最新推荐文章于 2025-08-11 21:13:32 发布 · 817 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jpa #emc #encoding #jdbc #sql #oracle

1、MYSQL配置

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.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_2_0.xsd"> <persistence-unit name="EMCWEB" transaction-type="RESOURCE_LOCAL"> <class>org.hibernate.ejb.HibernatePersistence</class> <class>com.test.common.BaseEntity</class> <class>com.test.entity.TradeType</class> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /> <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" /> <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/emc?useUnicode=true&characterEncoding=UTF-8" /> <property name="hibernate.connection.username" value="root" /> <property name="hibernate.connection.password" value="123456" /> <property name="hibernate.max_fetch_depth" value="3" /> <property name="hibernate.jdbc.fetch_size" value="18" /> <property name="hibernate.jdbc.batch_size" value="10" /> <property name="hibernate.show_sql" value="true" /> <property name="hibernate.format_sql" value="false" /> </properties> </persistence-unit> </persistence>

2、ORACLE配置

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.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_2_0.xsd"> <persistence-unit name="EMCWEB" transaction-type="RESOURCE_LOCAL"> <class>org.hibernate.ejb.HibernatePersistence</class> <class>com.test.common.BaseEntity</class> <class>com.test.entity.TradeType</class> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" /> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" /> <property name="hibernate.connection.username" value="emc" /> <property name="hibernate.connection.password" value="emc" /> <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:EMC"/> <property name="hibernate.max_fetch_depth" value="3"/> <property name="hibernate.jdbc.fetch_size" value="18"/> <property name="hibernate.jdbc.batch_size" value="10"/> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.format_sql" value="false"/> </properties> </persistence-unit> </persistence>