MySQL 과 Oracle DBCP config.xml 기본연결설정정보

<connection-sources>

    <description>this script is a connection description</description>

    <JDBCConnectionPool name="mysql">

          <description>MySql Connection Source</description>

          <defaultAutoCommit>true</defaultAutoCommit>

          <defaultReadOnly>false</defaultReadOnly>

          <driverClassName>org.gjt.mm.mysql.Driver</driverClassName>

          <maxActive>10</maxActive>

          <maxIdle>10</maxIdle>

          <maxWait>10000</maxWait>

          <username>unicorn</username>

          <password>love</password>

          <url>jdbc:mysql://localhost/unicorn</url>

    </JDBCConnectionPool>

      

    <JDBCConnectionPool name="mysql">

          <description>oracle Connection Source</description>

          <defaultAutoCommit>true</defaultAutoCommit>

          <defaultReadOnly>false</defaultReadOnly>

          <driverClassName>oracle.jdbc.driver.OracleDriver
          </driverClassName>

          <maxActive>10</maxActive>

          <maxIdle>10</maxIdle>

          <maxWait>10000</maxWait>

          <username>unicorn</username>

          <password>love</password>

          <url>jdbc:oracle:thin:@localhost:1521:unicorn</url>

    </JDBCConnectionPool>

</connection-sources>