<?xml version="1.0" encoding="UTF-8"?>
<datasources>

  <local-tx-datasource>
    <jndi-name>PicketLinkIDMDS</jndi-name>

    <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>    
    <driver-class>org.hsqldb.jdbcDriver</driver-class>
    <user-name>sa</user-name>
    <password></password>

    <!-- connection pool parameters -->
    <min-pool-size>1</min-pool-size>
    <max-pool-size>5</max-pool-size>

    <!-- disable idle connection removal, hsqldb does not reap threads on closed connections -->
    <idle-timeout-minutes>0</idle-timeout-minutes>
    <!-- check all statements are closed when the connection is returned to the pool -->
    <track-statements />
    <!-- hsqldb benefits from prepared statement caching -->
    <prepared-statement-cache-size>32</prepared-statement-cache-size>

    <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
    <metadata>
      <type-mapping>Hypersonic SQL</type-mapping>
    </metadata>

    <!-- ensure the datasource is not initialized before the database itself -->
    <depends>jboss:service=Hypersonic,database=picketlinkIDM</depends>
  </local-tx-datasource>

  <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic,database=picketlinkIDM">
    <attribute name="Database">picketlinkIDM</attribute>
    <attribute name="InProcessMode">false</attribute>
  </mbean>

</datasources>
