数据库的数据源配置示例

以下示例中数据库配置需要根据业务需求选择对应类型数据库配置并修改对应C3p0-Url、C3p0-UserName、C3p0-Password即可。

guassdb（高斯数据库）

<group name="default">
            <configValue key="Database-Type">gaussDB</configValue>
            <configValue key="Jdbc-Type"/>
            <configValue key="C3p0-DriverClass">com.huawei.gauss200.jdbc.Driver</configValue>
            <configValue key="C3p0-Url">jdbc:gaussdb://127.0.0.1:15400/esb8sp1_pk</configValue>
            <configValue key="C3p0-UserName">gaussdb</configValue>
            <configValue key="C3p0-Password">gaussdb</configValue>
            <configValue key="C3p0-PoolSize">30</configValue>
            <configValue key="C3p0-MaxPoolSize">300</configValue>
            <configValue key="C3p0-MinPoolSize">30</configValue>
            <configValue key="C3p0-MaxIdleTime">600</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">900</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">1</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>

Kingbase

<group name="default">
            <configValue key="Database-Type">kingbase</configValue>
            <configValue key="Jdbc-Type"/>
            <configValue key="C3p0-DriverClass">com.kingbase8.Driver</configValue>
            <configValue key="C3p0-Url">jdbc:kingbase8://127.0.0.1:54321/BPMWL</configValue>
            <configValue key="C3p0-UserName">SYSTEM</configValue>
            <configValue key="C3p0-Password">SYSTEM</configValue>
            <configValue key="C3p0-PoolSize">10</configValue>
            <configValue key="C3p0-MaxPoolSize">50</configValue>
            <configValue key="C3p0-MinPoolSize">10</configValue> 
            <configValue key="C3p0-MaxIdleTime">0</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">60</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">3</configValue>
            <configValue key="C3p0.breakAfterAcquireFailure">false</configValue>
            <configValue key="C3p0.testConnectionOnCheckout">false</configValue>
            <configValue key="C3p0.testConnectionOnCheckin">false</configValue>
            <configValue key="C3p0.preferredTestQuery">select 1 from dual</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>

oracle

<group name="default">
            <configValue key="Database-Type">Oracle</configValue>
            <configValue key="Jdbc-Type">Oracle Driver(thin)(Type4)</configValue>
            <configValue key="C3p0-DriverClass">oracle.jdbc.driver.OracleDriver</configValue>
            <configValue key="C3p0-Url">jdbc:oracle:thin:@127.0.0.1:1521:orcl</configValue>
            <configValue key="C3p0-UserName">autotest_afc</configValue>
            <configValue key="C3p0-Password">autotest_afc</configValue>
            <configValue key="C3p0-PoolSize">30</configValue>
            <configValue key="C3p0-MaxPoolSize">300</configValue>
            <configValue key="C3p0-MinPoolSize">30</configValue>
            <configValue key="C3p0-MaxIdleTime">600</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">900</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">1</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>

sqlserver

<group name="default">
            <configValue key="Database-Type">SQL Server</configValue>
            <configValue key="Jdbc-Type"/>
            <configValue key="C3p0-DriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</configValue>
            <configValue key="C3p0-Url">jdbc:sqlserver://127.0.0.1:1433;DatabaseName=afcentertest;SelectMethod=Cursor;trustServerCertificate=true</configValue>
            <configValue key="C3p0-UserName">sa</configValue>
            <configValue key="C3p0-Password">sa</configValue>
            <configValue key="C3p0-PoolSize">10</configValue>
            <configValue key="C3p0-MaxPoolSize">50</configValue>
            <configValue key="C3p0-MinPoolSize">10</configValue>
            <configValue key="C3p0-MaxIdleTime">0</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">60</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">3</configValue>
            <configValue key="C3p0.breakAfterAcquireFailure">false</configValue>
            <configValue key="C3p0.testConnectionOnCheckout">false</configValue>
            <configValue key="C3p0.testConnectionOnCheckin">false</configValue>
            <configValue key="C3p0.preferredTestQuery">select 1 from dual</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>

dm（达梦）

<group name="default">
            <configValue key="Database-Type">DM</configValue>
            <configValue key="Jdbc-Type"/>
            <configValue key="C3p0-DriverClass">dm.jdbc.driver.DmDriver</configValue>
            <configValue key="C3p0-Url">jdbc:dm://127.0.0.1:5236</configValue>
            <configValue key="C3p0-UserName">AUTOTESTAFCENTER</configValue>
            <configValue key="C3p0-Password">AUTOTESTAFCENTER</configValue>
            <configValue key="C3p0-PoolSize">30</configValue>
            <configValue key="C3p0-MaxPoolSize">300</configValue>
            <configValue key="C3p0-MinPoolSize">30</configValue>
            <configValue key="C3p0-MaxIdleTime">600</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">900</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">1</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>

mysql

 <group name="default">
            <configValue key="Database-Type">MySql</configValue>
            <configValue key="Jdbc-Type"/>
            <configValue key="C3p0-DriverClass">com.mysql.jdbc.Driver</configValue>
            <configValue key="C3p0-Url">jdbc:mysql://127.0.0.1:3306/afcenter?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8&amp;useSSL=false</configValue>
            <configValue key="C3p0-UserName">root</configValue>
            <configValue key="C3p0-Password">root</configValue>
            <configValue key="C3p0-PoolSize">30</configValue>
            <configValue key="C3p0-MaxPoolSize">300</configValue>
            <configValue key="C3p0-MinPoolSize">30</configValue>
            <configValue key="C3p0-MaxIdleTime">600</configValue>
            <configValue key="C3p0-IdleConnectionTestPeriod">900</configValue>
            <configValue key="C3p0-MaxStatements">0</configValue>
            <configValue key="C3p0-NumHelperThreads">1</configValue>
            <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
            <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
            <configValue key="Retry-Connect-Count">-1</configValue>
        </group>