class TuneController {

def dataSource_ds2

def list = {


    String nameSql = "select name from emp where id=3345"
    Sql sql = new Sql(dataSource_ds2)
    String name = sql.rows(nameSql)
    println(name)
}

}

datasources = {

             datasource(name:'ds2') {
        domainClasses([com.Tune])
        readOnly(true)
        driverClassName('oracle.jdbc.driver.OracleDriver')
        url('jdbc:oracle:thin:@test-ofr.wellmanage.com:1521:OFRS1')
        username('test')
        password('test')
        environments(['development'])
        dbCreate('do-not-bother')
        logSql(true)
        dialect(org.hibernate.dialect.Oracle10gDialect)
        hibernate {
            cache {
                use_second_level_cache(false)
                use_query_cache(false)
            }
        }
    }
}

class MyController {

   def dataSource_foo

   def list = {
      String nameSql = "select name from emp where id=3345"
      Sql sql = new Sql(dataSource_foo)
      def rows = sql.rows(nameSql)
      ...
   }
}

environments {
development {
    dataSource {
        dbCreate = "create-drop"
        url = "jdbc:h2:mem:devDb"
    }
    dataSource_lookup {
        dialect = org.hibernate.dialect.MySQLInnoDBDialect
        driverClassName = 'com.mysql.jdbc.Driver'
        username = 'lookup'
        password = 'secret'
        url = 'jdbc:mysql://localhost/lookup'
        dbCreate = 'update'
    }
}

class ZipCode {

    String code

    static mapping = { datasource 'lookup' }
 }

try {
    Connection con = DriverManager.getConnection ("jdbc:xxxx", "username", "password")
    ResultSet resultSet = con.createStatement().executeQuery("SELECT * FROM the_table")
    while(resultSet.next()) {
        DomainObject domainObjectInstance = new DomainObject(attributeA: resultSet.getString('attributeA'), attributeB: resultSet.getString('attributeB'))
        if (!domainObjectInstance.save(flush: true)) {
            println "Unable to save DomainObject: ${domainObjectInstance.errors}"
        }
    }
} catch (SQLException e) {
    e.printStackTrace();
}

datasources = {

         datasource(name:'ds2') {
    domainClasses([com.Tune])
    readOnly(true)
    driverClassName('oracle.jdbc.driver.OracleDriver')
    url('jdbc:oracle:thin:@test-ofr.tnic.com:1521:OFRS1')
    username('test')
    password('test')
    environments(['development'])
    dbCreate('do-not-bother')
    logSql(true)
    dialect(org.hibernate.dialect.Oracle10gDialect)
    hibernate {
        cache {
           provider_class('net.sf.ehcache.hibernate.EhCacheProvider')
              use_second_level_cache(true)
              use_query_cache(true)
        }
    }
}
}