4 Replies Latest reply on Mar 4, 2004 5:20 AM by Andrew May

    Need to use SQL in app that is using CMP

    davout Newbie

      I'm building my first JBoss app... it uses a mix of session and CMP based entity beans.

      Until now CMP has been fine for handling entity level CRUD operations, but now I need to add a flexible query facility that EQL can't really handle (i.e. dynamic WHERE clause building at run time).

      I'm presuming that I can use traditional JDBC SQL query set within a facade session bean method, but what I'm not sure about is how to obtain JDBC connections and queries. Are there any special JBoss facilities/services for handling JDBC queries?