JBoss7配置datasource

xiaoxiao2021-02-27  233

jboss7是通过datasource subsystem来配置datasource的,声明一个datasource主要包括两步:提供JDBC driver 和定义一个跟这个driver关联的datasource. 例如在/configuration/standalong.xml定义下面的datasource: <subsystem xmlns="urn:jboss:domain:datasources:1.0">     <datasources>         <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS">             <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>20</max-pool-size>                 <prefill>true</prefill>             </pool>             <security>                 <user-name>sa</user-name>                 <password>sa</password>             </security>         </datasource>         <xa-datasource jndi-name="java:jboss/datasources/ExampleXADS" pool-name="ExampleXADS">            <driver>h2</driver>            <xa-datasource-property name="URL">jdbc:h2:mem:test</xa-datasource-property>            <xa-pool>                 <min-pool-size>10</min-pool-size>                 <max-pool-size>20</max-pool-size>                 <prefill>true</prefill>            </xa-pool>            <security>                 <user-name>sa</user-name>                 <password>sa</password>            </security>         </xa-datasource>         <drivers>             <driver name="h2" module="com.h2database.h2">                 <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>             </driver>         </drivers>   </datasources>   </subsystem> 添加了datasource,你可以用jboss的CLI:bin/jboss-cli.sh 来查看 [standalone@localhost:9999 /] /subsystem=datasources:read-resource(recursive=true) {     "outcome" => "success",     "result" => {         "data-source" => {"java:/H2DS" => {             "connection-url" => "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1",             "jndi-name" => "java:/H2DS",             "driver-name" => "h2",             "pool-name" => "H2DS",             "use-java-context" => true,             "enabled" => true,             "jta" => true,             "pool-prefill" => true,             "pool-use-strict-min" => false,             "user-name" => "sa",             "password" => "sa",             "flush-strategy" => "FailingConnectionOnly",             "background-validation" => false,             "use-fast-fail" => false,             "validate-on-match" => false,             "use-ccm" => true         }},         "xa-data-source" => undefined,         "jdbc-driver" => {"h2" => {             "driver-name" => "h2",             "driver-module-name" => "com.h2database.h2",             "driver-xa-datasource-class-name" => "org.h2.jdbcx.JdbcDataSource"         }}     } }     [standalone@localhost:9999 /] /subsystem=datasources:installed-drivers-list {     "outcome" => "success",     "result" => [{         "driver-name" => "h2",         "deployment-name" => undefined,         "driver-module-name" => "com.h2database.h2",         "module-slot" => "main",         "driver-xa-datasource-class-name" => "org.h2.jdbcx.JdbcDataSource",         "driver-class-name" => "org.h2.Driver",         "driver-major-version" => 1,         "driver-minor-version" => 2,         "jdbc-compliant" => true     }] } 具体步骤参考这里: DataSource configuration
转载请注明原文地址: https://www.6miu.com/read-8532.html

最新回复(0)