Are there some ways to map database type INTERVAL?
Directly using java.sql.Timestamp?
Or define in standardjbosscmp-jdbc.xml?
Or something else?
No. What type would you like it mapped to? I think intervals are a big missing point from CMP and EJB-QL, but there is no corresponding java class that I am aware of that we could map an interval.
I plan on making mapping easier to plug in 4.0, so you could define your own interval class, but it would be better to have a common representation.