Announcement Announcement Module
No announcement yet.
Running SQL statement directly in Spring Roo Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Running SQL statement directly in Spring Roo

    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?