使用Grails 3.1.5和Postgresql的多个数据源

dataSources:
  dataSource1:
    pooled: true
    jmxExport: true
    driverClassName: org.postgresql.Driver
    username: your_username
    password: your_password
    dialect: org.hibernate.dialect.PostgreSQLDialect
    url: jdbc:postgresql://host1:port1/database1

  dataSource2:
    pooled: true
    jmxExport: true
    driverClassName: org.postgresql.Driver
    username: your_username
    password: your_password
    dialect: org.hibernate.dialect.PostgreSQLDialect
    url: jdbc:postgresql://host2:port2/database2

import groovy.sql.Sql

class MyService {
    def dataSource1
    def dataSource2

    def someMethod() {
        Sql sql1 = new Sql(dataSource1)
        Sql sql2 = new Sql(dataSource2)

        // 使用dataSource1进行数据库操作
        sql1.execute("SELECT * FROM table1")

        // 使用dataSource2进行数据库操作
        sql2.execute("SELECT * FROM table2")
    }
}