XXXXX
C/C++ 		XXXXX
C#/.net 		XXXXX
js 		java
java 		开发导航 开发导航 www.endv.cn
天云

jdbc:h2 to jdbc:mysql

 

原

 1         <subsystem xmlns="urn:jboss:domain:datasources:6.0">
 2         
 3         
 4             <datasources>
 5                 <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
 6                     <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
 7                     <driver>h2</driver>
 8                     <security>
 9                         <user-name>sa</user-name>
10                         <password>sa</password>
11                     </security>
12                 </datasource>
13                 <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
14                     <connection-url>jdbc:h2:${jboss.server.data.dir}/keycloak;AUTO_SERVER=TRUE</connection-url>
15                     <driver>h2</driver>
16                     <security>
17                         <user-name>sa</user-name>
18                         <password>sa</password>
19                     </security>
20                 </datasource>
21                 <drivers>
22                     <driver name="h2" module="com.h2database.h2">
23                         <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
24                     </driver>
25                 </drivers>
26             </datasources>
27             
28             
29         </subsystem>
30

替换为

 

 1             <datasources>
 2                 <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
 3                     <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
 4                     <driver>h2</driver>
 5                     <security>
 6                         <user-name>sa</user-name>
 7                         <password>sa</password>
 8                     </security>
 9                 </datasource>
10                 
11                 <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true">
12                     <connection-url>jdbc:mysql://192.168.1.6:3306/keycloak?useSSL=false&amp;serverTimezone=GMT%2B8&amp;characterEncoding=UTF-8</connection-url>
13                     <driver>mysql</driver>
14                     <security>
15                         <user-name>root</user-name>
16                         <password>12345678</password>
17                     </security>
18                 </datasource>
19                 <drivers>
20                     <driver name="h2" module="com.h2database.h2">
21                         <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
22                     </driver>
23                     <driver name="mysql" module="com.mysql">
24                         <xa-datasource-class>com.mysql.cj.jdbc.MysqlXADataSource</xa-datasource-class>
25                     </driver>
26                 </drivers>
27             </datasources>

 

 

0.0.0.0
1     <interfaces>
2         <interface name="management">
3             <inet-address value="${jboss.bind.address.management:0.0.0.0}"/>
4         </interface>
5         <interface name="public">
6             <inet-address value="${jboss.bind.address:0.0.0.0}"/>
7         </interface>
8     </interfaces>

 

posted @ 2021-02-27 14:11  Endv  阅读(212)  评论(0)  编辑  收藏  举报