aspose file tools*
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CMP 2.0 Oracle Dates