Spring JDBC Template in Grails Application

import org.springframework.jdbc.core.JdbcTemplate
import org.apache.commons.dbcp.BasicDataSource

beans = {

//reference  of  dataSource is defined in Grails DataSource groovy file

mainDataSourceTemplate(JdbcTemplate) {
   dataSource = ref('dataSource')        
}

// use another datasource that is different from main dataSource 

SecondaryDataSourceConfig(BasicDataSource) {
   driverClassName = "com.mysql.jdbc.Driver"
   url = "jdbc:mysql://localhost:3306/testsecondary"
   username = "uname"
   password = "pass"
}

secondaryDataSourceTemplate(JdbcTemplate) {
   dataSource = SecondaryDataSourceConfig
   }
}

public class TestJDBCTemplateController {

def secondaryDataSourceTemplate
def mainDataSourceTemplate 

/*suppose we have two database main database name maintest and secondary database name testsecondary .
  both contains table test with some records.test  table contains id and name columns. 
  we are getting name from both database tables using jdbc template .*/

    def testMainJdbc(){

           String sqlQuery = "SELECT name FROM test; 
           def result = mainDataSourceTemplate.queryForList(sqlQuery) 
           println "result of Query is =====>"+result.name
           println "Size of Result ========> "result.size();
         }

def testSecondaryJdbc(){

          String sqlQuery = "SELECT name FROM test; 
          def result = secondaryDataSourceTemplate.queryForList(sqlQuery) 
          println "result of Query is =====>"+result.name
          println "Size of Result ========> "result.size();
    }

def testTemplateUsingPreparedStatment(){
          String sqlQuery = "SELECT name FROM test where id = ?;
          def id = 1
          def result = secondaryDataSourceTemplate.queryForList(sqlQuery,id) 
          println "result of Query is =====>"+result.name
          println "Size of Result ========> "result.size();
} }