Discussions

EJB programming & troubleshooting: cmp-oracle8i-date/time problem

  1. cmp-oracle8i-date/time problem (1 messages)

    I have written a cmp for an order management system. For ordered date i have taken java.sql.Date. we r using oracle8i
    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,
    Shiva
  2. cmp-oracle8i-date/time problem[ Go to top ]

    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)



    regards
    Debu Panda
    http://radio.weblogs.com/0135826/