I have a funky database (actually a JDBC/ODBC driver to an ISAM file based dataset) which doesn't like repeated open / closure of DB connections. After a while the servers send an error messages saying that we have exceeded the maximum number of connections.
I am looking for a way to keep a single connection open. I am using Spring with iBatis 2.0.8. Right now I moved the dataSource definition in the sqlMapConfig of iBatis and this seems to work.
What do I lose from moving the dataSource and transaction manager to iBatis. Is there a bean definition in the ApplicationContext that I could use that do the same?