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

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- $Id: hsqldb-ds.xml,v 1.1.2.5 2003/05/30 18:27:09 d_jencks Exp $ -->


<datasources>
  <local-tx-datasource>
    <!-- remove this depends tag if you are not using the tcp connection url -->
    <depends>jboss:service=Hypersonic</depends>
    <jndi-name>DefaultDS</jndi-name>
    <!-- for tcp connection, allowing other processes to use the hsqldb database -->
    <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
    <!-- for totally in-memory db, not saved when jboss stops.  hsql mbean is unnecessary-->
    <!--connection-url>jdbc:hsqldb:.</connection-url-->
    <!-- for in-process db,  saved when jboss stops.  hsql mbean is unnecessary-->
    <!--connection-url>jdbc:hsqldb:default-db-name</connection-url-->
    <driver-class>org.hsqldb.jdbcDriver</driver-class>
    <user-name>sa</user-name>
    <password></password>
    <!--example of how to specify class that determines if exception means connection should be destroyed-->
    <!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->

    <!-- this will be run before a managed connection is removed from the pool for use by a client-->
    <!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> -->

    <!-- this will be run each time a connection handle is created.  Useful for setting up user-specific packages in Oracle -->
    <!-- <new-connection-sql>blah</new-connection-sql>-->
    <min-pool-size>5</min-pool-size>
    <security-domain>HsqlDbRealm</security-domain>
  </local-tx-datasource>

  <!-- this mbean should be used only when using tcp connections -->
  <mbean code="org.jboss.jdbc.HypersonicDatabase" 
	 name="jboss:service=Hypersonic">
    <attribute name="Port">1701</attribute>
    <attribute name="Silent">true</attribute>
    <attribute name="Database">default</attribute>
    <attribute name="Trace">false</attribute>
    <attribute name="No_system_exit">true</attribute>
  </mbean>
</datasources>
