<!-- 第一个数据库 -->
<
bean
id
=
"dataSource"
class
=
"com.atomikos.jdbc.SimpleDataSourceBean"
init-method
=
"init"
destroy-method
=
"close"
>
<
property
name
=
"uniqueResourceName"
value
=
"mysql/main"
/>
<
property
name
=
"xaDataSourceClassName"
value
=
"com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"
/>
<
property
name
=
"xaDataSourceProperties"
value
=
"URL=${jdbc.url.a};user=${jdbc.username.a};password=${jdbc.password.a}"
/>
<
property
name
=
"exclusiveConnectionMode"
value
=
"true"
/>
<
property
name
=
"connectionPoolSize"
value
=
"10"
/>
<
property
name
=
"validatingQuery"
>
<
value
>SELECT 1</
value
>
</
property
>
</
bean
>
<!-- 第二个数据库 -->
<
bean
id
=
"dataSourceB"
class
=
"com.atomikos.jdbc.SimpleDataSourceBean"
init-method
=
"init"
destroy-method
=
"close"
>
<
property
name
=
"uniqueResourceName"
value
=
"mysql/news"
/>
<
property
name
=
"xaDataSourceClassName"
value
=
"com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"
/>
<
property
name
=
"xaDataSourceProperties"
value
=
"URL=${jdbc.url.b};user=${jdbc.username.b};password=${jdbc.password.b}"
/>
<
property
name
=
"exclusiveConnectionMode"
value
=
"true"
/>
<
property
name
=
"connectionPoolSize"
value
=
"10"
/>
<
property
name
=
"validatingQuery"
>
<
value
>SELECT 1</
value
>
</
property
>
</
bean
>
联系客服