I'm using EJB CMP in my first JBoss project against a MySQL database.
As standard EQL cannot employ DATE types as part of its query am I right in thinking that I should be storing my dates as Long values? that way I use standard numeric operands to enable EQL retrievals, right?
I can use the 'Calendar.getTimeInMillis' to find the date 'Long' value and then store this to the MySQL table.
By the way is a Java 'Long' equivalent to a MySQL 'Integer'?