https

JBoss7多数据源配置

Posted by Sunfy on 2022-04-03
Words 1.3k and Reading Time 7 Minutes
Viewed Times
Viewed Times
Visitors In Total

JBoss7数据源配置文件路径%JBossHome%/standalone/configuration/standalone.xml

配置内容如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<datasources>
    <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
        <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
        <driver>h2</driver>
        <security>
            <user-name>sa</user-name>
            <password>sa</password>
        </security>
    </datasource>
    <!-- 数据源配置 -->
    <datasource jndi-name="java:/oa" pool-name="oa" enabled="true" use-java-context="true">
        <connection-url>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=zjtzoa;SelectMethod=Cursor</connection-url>
        <driver>mssqlxa</driver>
        <!-- 数据库连接池的配置 -->
        <pool>
            <min-pool-size>500</min-pool-size>
            <max-pool-size>5000</max-pool-size>
            <prefill>true</prefill>
        </pool>
        <security>
            <user-name>sa</user-name>
            <password>sa123456!</password>
        </security>
        <!-- 连接超时时间的配置 -->
        <timeout>
            <blocking-timeout-millis>30000</blocking-timeout-millis>
            <idle-timeout-minutes>5</idle-timeout-minutes>
        </timeout>
    </datasource>
    <!-- 配置多个数据源、
 	此处jndi文件名称要在config-chx.xml文件中进行同步配置，且保证名称一直-->
    <datasource jndi-name="java:/4auser_db" pool-name="4auser_db" enabled="true" use-java-context="true">
        <connection-url>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=4auser;SelectMethod=Cursor</connection-url>
        <driver>mssqlxa</driver>
        <security>
            <user-name>sa</user-name>
            <password>sa123456!</password>
        </security>
    </datasource>
    <drivers>
        <driver name="h2" module="com.h2database.h2">
            <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
        </driver>
        <driver name="mssqlxa" module="com.microsoft.sqlserver.jdbc">
            <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
            <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
        </driver>
    </drivers>
</datasources>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?xml version="1.0" encoding="gb2312" ?>
<applications>
    <datasource>java:/oa</datasource>
    <debug>true</debug>
    <right-class>cn.com.chx.ou.bo.Security</right-class>
    <right-method>SecurityCheck</right-method>

    <schema cycle="60" state="enable">
    	<task class="cn.com.chx.workflow.engine.Schedule" method="runSchedule" comment="计划任务运行引擎"/>
    	<task class="cn.com.chx.im.util.SMSService" method="smsQueueHandler" comment="消息服务"/>
    </schema>
    <schema cycle="86400" state="enable">
    	<task class="cn.com.chx.schedule.LicenseEarlyWarningTask" method="runTask" comment="license到期提醒"/>
    </schema>
    <dictionary>
    	<dict-file alias="frame-config" comment="平台框架配置表">frame-config.xml</dict-file>
		<dict-file alias="website-config" comment="内容管理系统配置表">website-config.xml</dict-file>
		<dict-file alias="ou-sysconfig" comment="组织用户系统配置表">ou-sysconfig.xml</dict-file>
		<dict-file alias="ou-dictionary" comment="组织用户系统字典表">ou-dictionary.xml</dict-file>
		<dict-file alias="eform-config" comment="电子表单系统配置表">eform-config.xml</dict-file>
		<dict-file alias="eform-dictionary" comment="电子表单系统字典表">eform-dictionary.xml</dict-file>
		<dict-file alias="workflow-config" comment="工作流管理系统配置表">workflow-config.xml</dict-file>
		<dict-file alias="im-dictionary" comment="即时通信系统配置表">im-dictionary.xml</dict-file>
		<dict-file alias="portal-config" comment="门户系统配置表">portal-config.xml</dict-file>
		<dict-file alias="index-config" comment="全文检索配置表">index-config.xml</dict-file>
		<dict-file alias="theme-config" comment="主题皮肤配置表">theme-config.xml</dict-file>
		<dict-file alias="secure-config" comment="系统安全配置表">secure-config.xml</dict-file>
    </dictionary>
    <iso2gb>true</iso2gb>
    <application-server>jboss</application-server>
    <recordperpage>20</recordperpage>
    <database>
		<type>sqlserver</type>
		<jdbcdriver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcdriver>
		<url>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=zjtzoa;SelectMethod=Cursor</url>
		<user>sa</user>
		<password>sa123456!</password>
    </database>
	<datasources>     
	  <datasource>
	   <datasourceid>DevelopSource</datasourceid>
	   <name>开发环境数据源</name>
	   <jndiname>DevelopSource</jndiname>
	   <type>sqlserver</type>
	   <jdbcdriver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcdriver>
	   <url>jdbc:sqlserver://218.241.83.19:1433;DatabaseName=zjtzoa;SelectMethod=Cursor</url>
	   <user>sa</user>
	   <password>sa123456!</password>
	  </datasource>
	  
	  <datasource>
	   <datasourceid>4auser_db</datasourceid>
	   <name>4A数据源</name>
	   <jndiname>4auser_db</jndiname>
	   <type>sqlserver</type>
	   <jdbcdriver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcdriver>
	   <url>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=4auser;SelectMethod=Cursor</url>
	   <user>sa</user>
	   <password>sa123456!</password>
	  </datasource>
	 </datasources>
    <form-config>
		<form-file>website-form.xml</form-file>
		<form-file>eform-form.xml</form-file>
		<form-file>workflow-form.xml</form-file>
		<form-file>im-form.xml</form-file>
    </form-config>
    <action-config>
		<action-file filter-class="cn.com.chx.website.util.appFilter" filter-handle="filterHandle" logger="enable">website-action.xml</action-file>
		<action-file logger="enable">ou-action.xml</action-file>
		<action-file >eform-action.xml</action-file>
		<action-file >workflow-action.xml</action-file>
		<action-file >im-action.xml</action-file>
		<action-file >component-action.xml</action-file>
		<action-file >portal-action.xml</action-file>
		<action-file >demo-action.xml</action-file>
    </action-config>
	<language>
		<lang name="中文">zh-cn</lang>
		<lang name="English">en</lang>
	</language>
    <system-language>zh-cn</system-language>
    <nodeid></nodeid>
    <index-path></index-path>
</applications>

Copyright 2021 sunfy.top ALL Rights Reserved

...

...

00:00
00:00
FEATURED TAGS
https
FRIENDS