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


<datasources>
   <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:mysql://${db.host}/${db.base-name}?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>${db.manager.name}</user-name>
    <password>${db.manager.pswd}</password>
    <min-pool-size>20</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <idle-timeout-minutes>5</idle-timeout-minutes>
    <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
   </local-tx-datasource>

  <local-tx-datasource>
    <jndi-name>PortalDS</jndi-name>
    <connection-url>jdbc:mysql://${db.host}/${db.base-name}?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false&amp;autoReconnect=true</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>${db.manager.name}</user-name>
    <password>${db.manager.pswd}</password>
    <min-pool-size>20</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <idle-timeout-minutes>5</idle-timeout-minutes>
    <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>

</datasources>
