• Post Reply Bookmark Topic Watch Topic
  • New Topic

CMP EJB 2.0 with Stored Procs??

 
clement valentine
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
Is it possible to use stored procedures in a CMP ejb? The primary keys for our database tables are encoded and timestamp generated using stored procs. It would be very handy if we could somehow use stored procs. instead of the container generated jdbc calls. Are there any resources available on this?
Thanks a lot
Cheers
 
Peter Kristensson
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you define a CMP bean that is defined from a view instead of a table, then this might be possible. Then you can define the view using your stored procedures.
Please note that i haven't tried this, but if you make it work, please post a note on whether it was possible or not.
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As with any CMP question, it will depend entirely on the vendor's discretion. I know that in WebSphere we're considering making this a feature for a future version of WebSphere, but that it will not be supported in WebSphere 5.0.
Kyle
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!