Grails4.0.1版本以上多数据库配置
在项目的配置文件conf下的application.yml文件中,environment下分别有development、test、production三种数据库连接方式,在你需要的连接方式下配置如下:
例如:在development下
一、dataSource:为默认数据库连接,代码如下;
// An highlighted block
dataSource:
dbCreate: none
driverClassName: com.mysql.cj.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://192.168.0.10:3306/longistation?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
二、dataSources:为多数据源数据库配置信息,代码如下;
dataSources:
oracleTest:
dbCreate: none
dialect: org.hibernate.dialect.OracleDialect
driverClassName: oracle.jdbc.driver.OracleDriver
username: user
password: 123456
url: jdbc:oracle:thin:@192.168.0.172:1521:orcl
sqlServerTest:
dbCreate: none
pooled: true
jmxExport: true
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
username: sa
password: 123456
url: jdbc:sqlserver://192.168.0.14:1433;database=UFDATA_333_2017;
# url: jdbc:microsoft:sqlserver://192.168.2.157:1433;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
accessTest:
pooled: true
jmxExport: true
dialect: com.hxtt.support.hibernate.HxttAccessDialect
driverClassName: com.hxtt.sql.access.AccessDriver
username:
password: ''
dbCreate: none
url: jdbc:access:/d:/accessDataBase/syd.mdb
三、service:在service中调用,代码如下;
1、调用sqlServer数据库
#定义要使用的数据库
def dataSource_sqlServerTest
def getQueryInfo(){
Sql db = new Sql(dataSource_sqlServerTest)
...
}