如何在Wildfly 10中以编程方式创建数据源?
答
以下示例已使用JBoss-EAP 7.0(使用Wildfly)进行了测试。 Pure Wildfly可能会有不同的maven dependency,提供ModelControllerClient
。这个例子是使用以下Maven依赖关系(从库https://maven.repository.redhat.com/ga):
<dependency>
<groupId>org.wildfly.core</groupId>
<artifactId>wildfly-controller-client</artifactId>
<version>2.1.13.Final-redhat-1</version>
</dependency>
我假设你已经手动配置数据源和驱动模块就位jboss/modules/system/layers
,下面的示例使用MySQL
驱动程序。要将驱动程序添加到JBoss配置 ,你必须执行的follwowing代码:
ModelControllerClient client = ModelControllerClient.Factory.create(InetAddress.getByName("localhost"), 9990);
ModelNode request = new ModelNode();
request.get(ClientConstants.OP).set(ClientConstants.ADD);
request.get(ClientConstants.OP_ADDR).add("subsystem","datasources");
request.get(ClientConstants.OP_ADDR).add("jdbc-driver","mysql");
request.get("driver-name").set("mysql");
request.get("driver-module-name").set("com.mysql");
request.get("driver-xa-datasource-class-name").set("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");
client.execute(new OperationBuilder(request).build());
client.close();
这将驱动程序添加到您的配置:
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
添加数据源是不是添加驱动器颇为相似:
ModelControllerClient client = ModelControllerClient.Factory.create(InetAddress.getByName("localhost"), 9990);
ModelNode request = new ModelNode();
request.get(ClientConstants.OP).set(ClientConstants.ADD);
request.get(ClientConstants.OP_ADDR).add("subsystem","datasources");
request.get(ClientConstants.OP_ADDR).add("data-source","TestDs");
request.get("jta").set(true);
request.get("jndi-name").set("java:jboss/datasources/TestDs");
request.get("pool-name").set("TestDs");
request.get("use-java-context").set(true);
request.get("use-ccm").set(true);
request.get("connection-url").set("jdbc:mysql://localhost/test");
request.get("driver-name").set("mysql");
request.get("transaction-isolation").set("TRANSACTION_READ_COMMITTED");
request.get("min-pool-size").set(5);
request.get("max-pool-size").set(20);
request.get("pool-prefill").set(true);
request.get("pool-use-strict-min").set(false);
request.get("flush-strategy").set("FailingConnectionOnly");
request.get("user-name").set("test");
request.get("password").set("test");
request.get("prepared-statements-cache-size").set(32);
request.get("share-prepared-statements").set(true);
client.execute(new OperationBuilder(request).build());
client.close();
利用该代码的数据源被编程创建:
<datasource jta="true" jndi-name="java:jboss/datasources/TestDs" pool-name="TestDs" use-java-context="true" use-ccm="true">
<connection-url>jdbc:mysql://localhost/test</connection-url>
<driver>mysql</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<prefill>true</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<statement>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>