【Moqui框架】Moqui连接各种类型的数据库
Moqui连接mysql数据库
各种数据库的连接文本：
-- Derby
<datasource group-name="transactional" database-conf-name="derby" schema-name="MOQUI">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties databaseName="${moqui.runtime}/db/derby/MoquiDEFAULT" createDatabase="create"/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:derby:MoquiDEFAULT;create=true"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="5" pool-maxsize="50"/> - ->
</datasource>
-- DB2
<datasource group-name="transactional" database-conf-name="db2" schema-name="" startup-add-missing="true" runtime-add-missing="false">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties user="moqui" password="moqui" serverName="localhost" portNumber="5021" driverType="4"
databaseName="MoquiDEFAULT"/>
</inline-jdbc>
<inline-jdbc jdbc-uri="jdbc:db2://localhost:5021/MoquiDEFAULT"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2" pool-maxsize="50"/> - ->
</datasource>
-- H2
<datasource group-name="transactional" database-conf-name="h2" schema-name="">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties url="jdbc:h2:${moqui.runtime}/db/h2/MoquiDEFAULT" user="sa" password=""/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:h2:${moqui.runtime}/db/h2/MoquiDEFAULT"
jdbc-username="sa" jdbc-password="" pool-minsize="5" pool-maxsize="50"/> - ->
</datasource>
-- MS SQL Server
<datasource group-name="transactional" database-conf-name="mssql" schema-name="">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties user="moqui" password="moqui" serverName="localhost" portNumber="1433" databaseName="MoquiDEFAULT"/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:sqlserver://localhost:1433;databaseName=MoquiDEFAULT"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2" pool-maxsize="50"/> - ->
</datasource>
-->
-- MySQL
<datasource group-name="transactional" database-conf-name="mysql" schema-name="">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties user="moqui" password="moqui" pinGlobalTxToPhysicalConnection="true"
serverName="127.0.0.1" port="3306" databaseName="MoquiDEFAULT" autoReconnectForPools="true"
useUnicode="true" encoding="UTF-8"/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:mysql://127.0.0.1:3306/MoquiDEFAULT?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2" pool-maxsize="50"/> - ->
</datasource>
-- Oracle
<datasource group-name="transactional" database-conf-name="oracle" schema-name="MOQUI">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties user="moqui" password="moqui" URL="jdbc:oracle:thin:@127.0.0.1:1521:MoquiDEFAULT"/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:oracle:thin:@127.0.0.1:1521:MoquiDEFAULT"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2" pool-maxsize="50"/> - ->
</datasource>
-- PostgreSQL
<datasource group-name="transactional" database-conf-name="postgres" schema-name="public" startup-add-missing="true" runtime-add-missing="false">
<inline-jdbc pool-minsize="5" pool-maxsize="50">
<xa-properties user="moqui" password="moqui" serverName="localhost" portNumber="5432"
databaseName="MoquiDEFAULT"/>
</inline-jdbc>
<!- - <inline-jdbc jdbc-uri="jdbc:postgresql://127.0.0.1/MoquiDEFAULT"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2" pool-maxsize="50"/> - ->
</datasource>
1.修改moqui\runtime\conf\MoquiProductionConf.xml根据需要加入对应的文本：
<entity-facade crypt-pass="MoquiProductionDefaultPassword:CHANGEME">
<datasource group-name="transactional" database-conf-name="mysql" check-pks-on-start="true" schema-name="">
<inline-jdbc jdbc-uri="jdbc:mysql://127.0.0.1:3306/moquitransactional?autoReconnect=true&characterEncoding=UTF-8"
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"
pool-maxsize="50" />
</datasource>
</entity-facade>
2.用java -Dmoqui.conf=conf/MoquiProductionConf.xml -jar moqui-1.0.2.war -load 加载数据。
3.java -Dmoqui.conf=conf/MoquiProductionConf.xml -jar moqui-1.0.2.war 启动服务
最新文章
- Bringing Whoops Back to Laravel 5
- 微信公众号入门学习2_使用C#，ASP.NET APIController如何被动回复用户消息
- Mongodb在NUMA机器上的优化
- iOS YSAuth 第三方登录及分享
- JAVA组程序优化综合考试试题
- JavaScript要点 (二) 使用误区
- 分分钟教你集成沉浸式侧滑关闭Activity
- ASP.NET WebForm路由模拟
- Error Handling in ASP.NET Core
- 使用sql语句复制一张表
- java猜数字（实验任务五）
- Dagger2的基本概念与实际应用。
- SharePoint2010搜索的简单设置
- tensorflow-RNN和LSTM
- How to use “cat” command on “find” command's output?
- POJ1751 Highways【最小生成树】
- 使用 Edit + MASM 5.0 编译器 + Linker 连接器
- [SoapUI]怎样保存response到本地文件夹
- C#中的多线程 - 同步基础 z
- （转载）处理SQL解析失败导致share pool 的争用