• Post Reply Bookmark Topic Watch Topic
  • New Topic

Using CMP entity bean with stored procedure?  RSS feed

 
John King
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can we use cmp with stroed procedures? Which server (version) supports
it? WLS, WAS?
 
Valentin Tanase
Ranch Hand
Posts: 704
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi John,

I cannot give you a certain answer, but from my experience with weblogic I´┐Żll tell you that this is rather impossible. If you want to access your stored procedures from your ejbs, than you rather use a SLSB that uses straight jdbc to invoke the SP. As a rule of thumb you should also remember that stored procedure should be used only when necessary. On the other hand the result of mixing the transaction logic in your ejbs, as well as the stored procedures is highly unpredictable.
Regards.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!