Hi Chaps, I have an CMP that returns a date object as one of the fields. When I include the CMP field in the ejb-jar.xml descriptor then access a finder method on the bean, a NumberFormatException is thrown. I've tried changing the field to be a Timestamp but it has the same effect. I've also tried Orion 1.4.5 and 1.4.7. If I deploy the bean without the date field, it all works fine. This is the mysql.xml line for date (please note I have tried date and datetime in both the db and mysql.xml): <type-mapping type="java.util.Date" name="datetime" /> <type-mapping type="java.util.Timestamp" name="datetime" /> Could someone tell me what I'm missing? I'm using MySQL 3.23.32, Orion 1.4.7, RH Linux 7.0 and mm mysql jdbc driver v2.0.4. The error thrown is com.evermind.server.rmi.OrionRemoteException: Database error: java.lang.NumberFormatException; nested exception is: java.sql.SQLException: java.lang.NumberFormatException Thanks, Tim. Tim Squires Wireless Data Services ---------------------------------------- It's not what you know, it's who you tell.
