How can I use the same SQL connection in different beans ?

[pierre]

Hi,
I have to perform a series of operations that have to be performed atomically as a single unit of work.

These operations are realized in different beans, and are linked with an Oracle database. I'm using a datasource to get a connection.

I have a problem because I don't manage to share the same connection between my beans. (A connection is not serializable, and then I can't write a bean manager that passed the connection as a parameter to the other beans)


Thanks,

[crypto]

Hey,

this is exactly what the "Session Facade" J2EE design pattern will bring you.

The book by Sun that presents these J2EE design patterns is :
Core J2EE Patterns: Best Practices and Design Strategies
Deepak Alur,John Crupi,Dan Malks
ISBN: 0-13-064884-1

Werner