Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: error (idunn.apache.osuosl.org: domain redwerk.com from
 85.90.206.104 cause and error)
Date: Fri, 22 Sep 2006 12:35:45 +0300
From: Eugeny N Dzhurinsky <bofh@redwerk.com>
To: user-java@ibatis.apache.org
Subject: Re: passing connection to ibatis
Message-ID: <20060922093545.GD40646@office.redwerk.com>
Mail-Followup-To: user-java@ibatis.apache.org
References: <20060921070823.GC982@office.redwerk.com>
 <446CAC4FA9FEF14FB0F3E7A507769EB008F8EE1E@USCOBRMFA-SE-70.northamerica.cexp.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
In-Reply-To: 
 <446CAC4FA9FEF14FB0F3E7A507769EB008F8EE1E@USCOBRMFA-SE-70.northamerica.cexp.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Thu, Sep 21, 2006 at 10:31:02AM -0600, Patrick.Higgins@cexp.com 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