On Thu, Sep 21, 2006 at 10:31:02AM -0600, [EMAIL PROTECTED] wrote: > You're only going to want to create temporary tables when the connection is > created, not at the beginning of every transaction. > > Depending on what kind of connection pool you're using, you may be able to > use their connection lifecycle event handler to do this rather than rely on > iBATIS to expose this functionality, which it probably can't do for most > external pools, anyway (unless it wraps their mechanisms, but that assumes > the API each connection pool exposes would be directly mappable onto the API > that iBATIS would choose, which would probably not be true for many of > them). > > If you're using DBCP, you might be able to your own implementation of > org.apache.commons.dbcp.ConnectionFactory that creates the temporary tables > before returning the connection from the createConnection() method.
That might work in case if I need to create those tables/views for each request for database, which isn't my case. I need to create such views only in certain cases and don't create them in other cases. If it would be possible to pass a connection to iBATIS somehow - that would definitely solve my problem -- Eugene N Dzhurinsky
