Meaningless Drivel is fun!*
The moose likes EJB and other Java EE Technologies and the fly likes CMP 2.0   Oracle Dates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "CMP 2.0   Oracle Dates" Watch "CMP 2.0   Oracle Dates" New topic
Author

CMP 2.0 Oracle Dates

Justin Krettabull
Greenhorn

Joined: Sep 08, 2004
Posts: 26
I'm new to EJB. I have several finders that are dependent on date values. I'm using Oracle 9i

I've read that CMP 2.0 does not support Dates. Are there any workarounds for this or am I stuck using BMP?

thanks,

Justin
Yuan Ye
Ranch Hand

Joined: Mar 05, 2003
Posts: 172
You can let the session bean to generate the Date (Server date) then insert to your EJB field, or you can create a seperate SQL Call to get the Date (DB date) then insert to your EJB field. Use the Timestamp as sql type so that it will support at hour:minute:second level.
Justin Krettabull
Greenhorn

Joined: Sep 08, 2004
Posts: 26
I tried passing a Timestamp to the finder and it didn't work.

I'm using Websphere 5.1 App. Server with Oracle 9i. I think Websphere only supports Timestamp with DB2.

Looks like I'm gonna have to write BMP's for the queries that return results based on date range.

thanks for your help
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: CMP 2.0 Oracle Dates
 
Similar Threads
Entity Beans must use CMP?
CMP to Map multiple tables
Mapping 4 database tables using single CMP bean
Batch update in EJB
Entity EJB Question...