HI, Im using
java ee 5. i want to send database inserts to the database throught a message queue to ensure the order of insertions.
clients invokes a stateful session bean to send the data. and the bean will access the message driven bean which is responsible for the actual db insert. all the calls through a single stateful bean is in one transaction. if one of the inserts fail the transaction should rollback.
but the problem im facing here is the SQL connection used to the updates cannot be passed from the session bean to the message driven bean since the conncetion is not serializable.
Can any one help me with a solution to this problem.