Stateless EJB calling stored procedures

[veera maria]

Hi,
I have a following situation. I should make stateless session bean as
a interface to stored procedures which are stored in database. Session
bean should call one stored procedure and that procedure might call
also another stored procedure to handle database actions and then
return resultset to session bean.

So, my questions are:
- is stateless session bean suitable for this kind of usage?
- session bean should handle transactions, so what kind of transaction
type
it should use? Some that is handled by container or JTA based?
- as I mentioned, there could be a 'chain' of stored procedure calls
after
session bean has called the first stored procedure, so can session
bean's transaction type handle this kind of chained stored procedure
calls or how to handle commits or rollbacks?

Br

Vera

 

[Jon Martin Solaas]

Perhaps you should consider BMP Entity Beans?

 

[Sudsy]

Hi,
I have a following situation. I should make stateless session bean as
a interface to stored procedures which are stored in database. Session
bean should call one stored procedure and that procedure might call
also another stored procedure to handle database actions and then
return resultset to session bean.

So, my questions are:
- is stateless session bean suitable for this kind of usage?
Certainly.

- session bean should handle transactions, so what kind of transaction
type
it should use? Some that is handled by container or JTA based?

I would obtain a javax.transaction.UserTransaction, typically
via JNDI lookup.

- as I mentioned, there could be a 'chain' of stored procedure calls
after
session bean has called the first stored procedure, so can session
bean's transaction type handle this kind of chained stored procedure
calls or how to handle commits or rollbacks?

Invoke begin() on the UserTransaction and then invoke your methods
within a try block. If an Exception is thrown then invoke rollback()
on the UserTransaction else invoke commit(). Everything should then
be appropriately handled by JTA.