• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CMP 2.0 Oracle Dates

 
Justin Krettabull
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic