Nice one! One thing you should be able to do is either: - make a Java EE specific Transaction; or - hold a Transaction as an object associated in your sesssion
(ie if you want to get this done today - can we make a separate email thread to sort out the details?) We do this for uDig (each map has a session and the user presses the commit buttton; rather then any specific code) and we have done it for some Java EE apps in the past. Cheers, Jody > I am using geotools since version 2.3.0 and wanted to use all the jdbc stuff > in an ejb container. (Especially the db2 extension from Dave Adler) > > It is simply not possible to have a global Transaction and to register a > geotools spatial jdbc extension to the transaction manager. If you have to > modifiy spatial data in one db and to modifiy classic data in another within > a transaction using the global transaction manager, the game is over. > > The primary reason for this is that the plugins do commit and rollback > statements against the db. For container managed transactions this is > forbidden, for bean managed transactions it is simply not right. > > No db mapping tool/plugin should make decisions about transaction > boundaries. As an example, if you look at the EJB 3.0 mapping, there is no > interface for transaction handling. (What they call commit is simply > executing an sql insert,update,delete to synchronize the cache to the db ), > not a db commit. > > The business logic makes decisions about transaction boundaries, never does > a mapping tool/plugin. > > Summary: > At the moment, the jdbc plugins are usefull for client apps (UDIG) and for > simple Server Apps, Deployment in an ejb container or web container with a > global transaction requirement ist not possible. > > > > > > > > ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
