Hi-
I am just getting started with JBoss and EJB2.0. While reading through the CMP and EJBQL docs, I saw that a lot of basic SQL functionality was missing from EJBQL. So much so that I am unable to see any sane way of using CMP for my little application.
If my application requires the use of SQL constructs like MIN, MAX, COUNT, and ORDER BY, does that mean I cannot use CMP?
It seems like any non-trivial application would need this functionality, so what is the Sun-sponsored best practice for this? BMP? JDOQL? Or should I just get a nice JDBC connection pool and code my SQL by hand like I've been doing for years?