proxool对于四种数据的配置xml

来源：互联网发布：淘宝商品设置价格区间编辑：程序博客网时间：2024/06/15 21:32

1.access.xml

<proxool>
    <alias>converse</alias>
    <driver-url>Microsoft Access Driver (*.mdb)};DBQ=D://db1.mdb"</driver-url>
    <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
    <driver-properties>
      <property name="user" value=""/>
      <property name="password" value=""/>
    </driver-properties>
    <maximum-connection-count>100</maximum-connection-count>
    <minimum-connection-count>5</minimum-connection-count>
</proxool>

2.mysql.xml

<proxool>
    <alias>converse</alias>
    <driver-url>jdbc:mysql://localhost/test</driver-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="831128"/>
    </driver-properties>
    <maximum-connection-count>100</maximum-connection-count>
    <minimum-connection-count>5</minimum-connection-count>
</proxool>

3.oracle9.i.xml

<proxool>
    <alias>converse</alias>
    <driver-url>jdbc:oracle:thin:@127.0.0.1:1521:CNTC</driver-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <driver-properties>
      <property name="user" value="cntc"/>
      <property name="password" value="cntc"/>
    </driver-properties>
    <maximum-connection-count>100</maximum-connection-count>
    <minimum-connection-count>5</minimum-connection-count>
</proxool>

4.sqlserver200.xml

<proxool>
    <alias>converse</alias>
    <driver-url>jdbc:microsoft:sqlserver://192.168.1.158:1433;DatabaseName=triy</driver-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
    <driver-properties>
      <property name="user" value="sa"/>
      <property name="password" value="03774260113"/>
    </driver-properties>
    <maximum-connection-count>100</maximum-connection-count>
    <minimum-connection-count>5</minimum-connection-count>
</proxool>