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

<Context path="/petclinic" docBase="petclinic" debug="4" reloadable="true">
  <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_petclinic_log." suffix=".txt" timestamp="true"/>

  <!-- Define a database connection pool for HSQL -->
  <!-- NOTE: make sure that a copy of hsqldb.jar is in the TOMCAT common/lib directory -->
  <Resource name="jdbc/petclinicHSQL" auth="Container" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/petclinicHSQL">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    
    <parameter>
      <name>driverClassName</name>
      <value>org.hsqldb.jdbcDriver</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:hsqldb:hsql://localhost:9001</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>sa</value>
    </parameter>
    
    <parameter>
      <name>maxActive</name>
      <value>50</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>10</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout</name>
      <value>60</value>
    </parameter>
    <parameter>
      <name>logAbandoned</name>
      <value>true</value>
    </parameter>
  </ResourceParams>

  <!-- Define a database connection pool for MYSQL -->
  <Resource name="jdbc/petclinicMYSQL" auth="Container" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/petclinicMYSQL">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    
    <parameter>
      <name>driverClassName</name>
      <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
    <!--
          The JDBC connection url for connecting to your MySQL dB.
          The autoReconnect=true argument to the url makes sure that the
          mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
          connection.  mysqld by default closes idle connections after 8 hours.
    -->
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/petclinic?autoReconnect=true</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>pc</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>pc</value>
    </parameter>
    
    <parameter>
      <name>maxActive</name>
      <value>50</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>10</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout</name>
      <value>60</value>
    </parameter>
    <parameter>
      <name>logAbandoned</name>
      <value>true</value>
    </parameter>
  </ResourceParams>

  
</Context>
