jboss

最新推荐文章于 2023-06-08 17:08:35 发布

scaling_heights

最新推荐文章于 2023-06-08 17:08:35 发布

阅读量180

点赞数

分类专栏：工具

本文链接：https://blog.csdn.net/jz1993/article/details/88879537

版权

工具专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<datasources>
                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
                    <driver>h2</driver>
                    <security>
                        <user-name>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                <datasource jndi-name="java:jboss/jdbc/fucdnRW" pool-name="fucdnRW" enabled="true" use-java-context="true">
                    <connection-url>jdbc:mysql://**.**.**.**:3306/**?characterEncoding=utf8&amp;autoReconnect=true&amp;generateSimpleParameterMetadata=true</connection-url>
                    <driver>com.mysql</driver>
                    <security>
                        <user-name>root</user-name>
                        <password>SuningRds@123</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="com.mysql" module="com.mysql">
                        <driver-class>com.mysql.jdbc.Driver</driver-class>
                    </driver>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                </drivers>
            </datasources>

<subsystem xmlns="urn:jboss:domain:datasources:2.0">
            <datasources>
                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                    <driver>h2</driver>
                    <pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>50</max-pool-size>
                        <prefill>false</prefill>
                    </pool>
                    <security>
                        <user-name>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                <datasource jndi-name="java:jboss/datasources/MySQLDS" pool-name="pcdn" enabled="true" use-java-context="true">
                    <connection-url>jdbc:mysql://**.**.**.**:3306/**?characterEncoding=utf8&amp;generateSimpleParameterMetadata=true&amp;useServerPrepStmts=true&amp;cachePrepStmts=true</connection-url>
                    <connection-property name="connectTimeout">
                        5000
                    </connection-property>
                    <connection-property name="useSSL">
                        False
                    </connection-property>
                    <driver>com.mysql</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <url-delimiter>|</url-delimiter>
                    <pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>100</max-pool-size>
                        <prefill>true</prefill>
                        <use-strict-min>true</use-strict-min>
                        <flush-strategy>FailingConnectionOnly</flush-strategy>
                    </pool>
                    <security>
                        <security-domain>securitydomain_pcdn_samsauto</security-domain>
                    </security>
                    <validation>
                        <check-valid-connection-sql>select 1</check-valid-connection-sql>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>true</background-validation>
                        <background-validation-millis>60000</background-validation-millis>
                    </validation>
                    <timeout>
                        <blocking-timeout-millis>500</blocking-timeout-millis>
                        <idle-timeout-minutes>10</idle-timeout-minutes>
                    </timeout>
                </datasource>
                <drivers>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                    <driver name="com.db2" module="com.db2">
                        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
                    </driver>
                    <driver name="com.mysql" module="com.mysql">
                        <driver-class>com.mysql.jdbc.Driver</driver-class>
                    </driver>
                    <driver name="oracle" module="com.oracle">
                        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                    </driver>
                    <driver name="sybase" module="com.sybase">
                        <driver-class>com.sybase.jdbc4.jdbc.SybDataSource</driver-class>
                    </driver>
                    <driver name="com.postgresql" module="com.postgresql">
                        <driver-class>org.postgresql.Driver</driver-class>
                    </driver>
                </drivers>
            </datasources>
        </subsystem>