Kauri Documentation
 PreviousHomeNext 
9.3.3 LimitationsBook Index9.4 Mock database resources

9.3.4 persistence.xml examples

Here you can find some persistence.xml examples that can help you get started with Kauri database resources in your project.

9.3.4.1 In-memory database (used in samples)

<?xml version="1.0" encoding="UTF-8"?>
<persistence 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" version="1.0">
  <persistence-unit name="kauri-dbresources" transaction-type="RESOURCE_LOCAL">
    <properties>
      <property name="hibernate.hbm2ddl.auto" value="create-drop" />
      <property name="hibernate.show_sql" value="false" />
      <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
      <property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver" />
      <property name="hibernate.connection.url" value="jdbc:hsqldb:mem:kauri-sample" />
      <property name="hibernate.connection.username" value="sa" />
      <property name="hibernate.connection.password" value="" />
    </properties>
  </persistence-unit>
</persistence>

9.3.4.2 MySQL database

<?xml version="1.0" encoding="UTF-8"?>
<persistence 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" version="1.0">
  <persistence-unit name="kauri-dbresources" transaction-type="RESOURCE_LOCAL">
    <properties>
      <property name="hibernate.hbm2ddl.auto" value="update" />
      <property name="hibernate.show_sql" value="false" />
      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />
      <property name="hibernate.connection.username" value="sqluser" />
      <property name="hibernate.connection.password" value="sqlpwd" />
      <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/kauritest" />
    </properties>
  </persistence-unit>
</persistence>

9.3.4.3 Interesting links

 PreviousHomeNext 
9.3.3 Limitations9.4 Mock database resources