You might be sick of hearing this, but Spring can help here...
The iBATIS DAO framework is deprecated and we really encourage moving DAOs to the Spring implementation. With an implementation based on Spring, I believe that Spring could inject the same datasource (connection pool) into multiple SqlMapConfig files. Of course, this would all need to be in the same JVM. If you want to cross JVM boundaries, using a JNDI based datasource is a better option (your batch process could access the datasource from the web application's JNDI server). Jeff Butler On 1/30/07, scott.w.sinclair <[EMAIL PROTECTED]> wrote:
Hi, I have Java a webapplication which uses IBBATIS DAO and SQLMAP technologies. I have moved common DAO logic to an external module (JAR file) so that batch proccesses and the website can share common DAO logic. This means I have 2 sqlmap.xml files and 2 dao.xml files. But I want to try and coardinate the connection settings, as we are restrcted to a maximum of three connections to the database for the webserver. I would like to have some connection pooling between both "instances" of the ibbatis framework, does anyone know if this is possible. I don't really want to use JNDI as the common modulle would also be used in simple batch processes. -- View this message in context: http://www.nabble.com/Sharing-transaction-manager-across-multipe-sqlmap.xml-files-tf3144578.html#a8716919 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
