Comments on: A Grails Plugin for Multiple DataSources

By: rene

rene — Thu, 26 Aug 2010 12:11:31 +0000

Hi Burt,

thank you for your quick reply. It works just perfectly!
Greetings from Switzerland
rene

By: rene

rene — Thu, 26 Aug 2010 12:10:32 +0000

Hi Burt,

thank you for your quick reply. It works perfectly!
Greetings from Switzerland
rene

By: Burt

Burt — Wed, 25 Aug 2010 20:20:15 +0000

@rene the bean name would be ‘dataSource_ds2′, so use ‘def dataSource_ds2′. You can also use DatasourcesUtils.getDataSource(‘ds2′)

By: rene

rene — Wed, 25 Aug 2010 20:00:49 +0000

Hi Burt,
Is there a possibility to auto-inject datasources defined in DataSources.groovy?
I would like to use something like this for a read-only database access without domain classes
class MyFancySqlController {
def ds2 // like Spring-Bean? “ds2″ is auto-injected
def list = {
sql = “select * from test_table”
def db = new Sql(ds2)
def result = db.rows(sql)

[ result: result ]
}
}

This will end up in a null pointer exception because ds2 has not been auto-injected as excpected by me

regards rene

By: Burt

Burt — Wed, 25 Aug 2010 01:59:42 +0000

@Krish it’d be helpful to know what your configuration is. Please send a descriptive email to the grails-user mailing list (http://www.grails.org/Mailing+lists) or create a JIRA issue at http://jira.codehaus.org/browse/GRAILSPLUGINS