EJB programming & troubleshooting: cmp-oracle8i-date/time problem
I have written a cmp for an order management system. For ordered date i have taken java.sql.Date. we r using oracle8i
- Posted by: Shiva Shankar
- Posted on: October 08 2004 09:32 EDT
database. If we take java.sql.Date time is not storing. Now
we need time also. I tried to change cmp field as java.util.Date and java.sql.Timestamp fields. both are not supporting. any body faced this type of problem. Please anser to my question.
Thanking you all,
What J2EE container are you using ? This may be an issue with your J2EE container.
EJB 2.0 spec does not support Date, Time, Timestamp, and SQRT in EJB-QL, however many vendors have added extenions to support these types For example, Oracle Application Server 10g 9.0.4 supports java.util.Date, java.sql.Date, java.sql.Time and java.sql.Timestamp (Reference to EJB doc: http://download-west.oracle.com/docs/cd/B10464_01/web.904/b10324/ql.htm#1010436)