Spring Framework example source code file (petclinic_tomcat_all.xml)

This example Spring Framework source code file (petclinic_tomcat_all.xml) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - Spring Framework tags/keywords

container, container, context, define, define, hsql, jdbc, mysql, resource, resourceparams, resourceparams, the, the, tomcat

The Spring Framework petclinic_tomcat_all.xml source code

<?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
      <value>org.apache.commons.dbcp.BasicDataSourceFactory
    </parameter>
    
    <parameter>
      <name>driverClassName
      <value>org.hsqldb.jdbcDriver
    </parameter>
    <parameter>
      <name>url
      <value>jdbc:hsqldb:hsql://localhost:9001
    </parameter>
    <parameter>
      <name>username
      <value>sa
    </parameter>
    
    <parameter>
      <name>maxActive
      <value>50
    </parameter>
    <parameter>
      <name>maxIdle
      <value>10
    </parameter>
    <parameter>
      <name>maxWait
      <value>10000
    </parameter>
    <parameter>
      <name>removeAbandoned
      <value>true
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout
      <value>60
    </parameter>
    <parameter>
      <name>logAbandoned
      <value>true
    </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
      <value>org.apache.commons.dbcp.BasicDataSourceFactory
    </parameter>
    
    <parameter>
      <name>driverClassName
      <value>org.gjt.mm.mysql.Driver
    </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
      <value>jdbc:mysql://localhost:3306/petclinic?autoReconnect=true
    </parameter>
    <parameter>
      <name>username
      <value>pc
    </parameter>
    <parameter>
      <name>password
      <value>pc
    </parameter>
    
    <parameter>
      <name>maxActive
      <value>50
    </parameter>
    <parameter>
      <name>maxIdle
      <value>10
    </parameter>
    <parameter>
      <name>maxWait
      <value>10000
    </parameter>
    <parameter>
      <name>removeAbandoned
      <value>true
    </parameter>
    <parameter>
      <name>removeAbandonedTimeout
      <value>60
    </parameter>
    <parameter>
      <name>logAbandoned
      <value>true
    </parameter>
  </ResourceParams>

  
</Context>