Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

CMP 2.0 Oracle Dates  RSS feed

 
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!