Oracle Toplink JPA vs Hibernate JPA konfigurace

Potřebujete in-memory databázi HSQL přes JTA jak v Hibernate, tak v Toplinku? Zde jsou obě varianty stejné konfigurace.

Nejprve konfigurace pro Oracle Toplink JPA:

	<persistence-unit name="toplink-pu" transaction-type="RESOURCE_LOCAL">
		<provider>oracle.toplink.essentials.PersistenceProvider</provider>
		<exclude-unlisted-classes>false</exclude-unlisted-classes>
		<properties>
			<property name="toplink.jdbc.driver" value="org.hsqldb.jdbcDriver"/>
			<property name="toplink.jdbc.url" value="jdbc:hsqldb:mem:my_database"/>
			<property name="toplink.jdbc.user" value="sa"/>
			<property name="toplink.jdbc.password" value=""/>
			<property name="toplink.logging.level" value="INFO"/>
			<property name="toplink.target-database" value="HSQL"/>
			<property name="toplink.ddl-generation" value="drop-and-create-tables"/>
			<property name="toplink.ddl-generation.output-mode" value="database"/>
		</properties>
	</persistence-unit>

A nyní, dámy a pánové, Hibernate JPA:

	<persistence-unit name="hibernate-pu" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<properties>
			<property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver" />
			<property name="hibernate.connection.url" value="jdbc:hsqldb:mem:my_database" />
			<property name="hibernate.connection.username" value="sa" />
			<property name="hibernate.connection.password" value="" />
			<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
			<property name="hibernate.hbm2ddl.auto" value="create-drop" />
		</properties>
	</persistence-unit>