jboss7是通过datasource subsystem来配置datasource的,声明一个datasource主要包括两步:提供JDBC driver 和定义一个跟这个driver关联的datasource.
例如在/configuration/standalong.xml定义下面的datasource:
添加了datasource,你可以用jboss的CLI:bin/jboss-cli.sh 来查看
具体步骤参考这里: DataSource configuration
例如在/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