• Post Reply Bookmark Topic Watch Topic
  • New Topic

Stored Procedure and CMP  RSS feed

 
Alec Lee
Ranch Hand
Posts: 569
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When we write CMP beans, we do not have to concern about how the app server persist the bean instance. Does it means we cannot make use of db's stored procedures to enhance the performance?
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36446
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alec,
For simple operations the performance shouldn't be a problem. One or two database hits isn't likely to be optimized. For a complex query, you can still have your session bean call the stored procs through JDBC.
 
Chee Yong Foo
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you call stored procedure by JDBC by your session beans. Does it means it is BMT cos you use JDBC (sql statments). So does it means that you must handle the low level transaction/rollback using getUserTransaction().

Cheers
Chee Yong
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!