• Post Reply Bookmark Topic Watch Topic
  • New Topic

Calling database stored procedures using EJB

 
panchalee phookan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Can one call database stored procedures using EJBs? Is it also possible to handle REF CURSORs using EJB?
regards
panchalee
 
Raja Shekhar
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
YES Ucan
..USe PREPARE CALL
Raj
 
Avinash Naimpally
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you can use stored procedures in an EJB.
But I personally dont feel it is advisible to use any database specific or application specific code in your EJB. This woul;d prevent your EJB from being portable across different databases or across different application servers (incase either of them changes tomorrow).
However I am a novice to EJBs. I maybe wrong. Pls recheck on this.
Regards,
Avinash
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!