I have a legacy Spring Roo application with domain classes and supports webservices.

Now I need to run several reporting queries against my DB directly, as each query involves many joins. I will not have a domain object to hold what is returned. From requirement standpoint, it would be OK if I can just run the query and process the JDBC resultset.

However, how do I get a connection in the Roo application, and how should I configure the system with connection pooling?