How to obtain handle to Grails datasource

I want a handle to connection object in grails controller class (written in groovy). I read somewhere that I need to first obtain datasource object and call a method getConnection on it to get the connection object.

I am unable to find how to obtain the datasource object in开发者_开发知识库 grails controller. Kindly help.

The datasource is simply a bean. It can be injected by Spring into pretty much anything.

    def dataSource

But I would recommend that you inject the dataSource into a Service, do your getConnection call there and whatever work you need done. I think that's a better separation of responsibilities.

Then inject your service into your controller and call it.