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>