RE: passing connection to ibatis

2006-09-22 Thread Patrick.Higgins
>> 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 >r

Re: passing connection to ibatis

2006-09-22 Thread Eugeny N Dzhurinsky
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 connecti

RE: passing connection to ibatis

2006-09-21 Thread Patrick.Higgins
MAIL PROTECTED] Sent: Thursday, September 21, 2006 1:08 AM To: user-java@ibatis.apache.org Subject: Re: passing connection to ibatis On Wed, Sep 20, 2006 at 09:59:12AM -0600, [EMAIL PROTECTED] wrote: > This sounds like it could be solved by a connection lifecycle event handler > that Clint

Re: passing connection to ibatis

2006-09-21 Thread Eugeny N Dzhurinsky
On Wed, Sep 20, 2006 at 09:59:12AM -0600, [EMAIL PROTECTED] wrote: > This sounds like it could be solved by a connection lifecycle event handler > that Clinton mentioned on Sept. 16th: > > http://www.mail-archive.com/user-java@ibatis.apache.org/msg06174.html > > Strangely, I've actually needed t

RE: passing connection to ibatis

2006-09-20 Thread Patrick.Higgins
use cases for that feature now. I'll see if I can free up some time to write a patch. :-) -Original Message- From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 6:41 AM To: user-java@ibatis.apache.org Subject: passing connection to ibatis Hell

Re: passing connection to ibatis

2006-09-20 Thread Larry Meadors
Well, I have never imagined that anyone would want to. ;-) Larry On 9/20/06, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: On Tue, Sep 19, 2006 at 03:40:43PM +0300, Eugeny N Dzhurinsky wrote: > Hello! > > I have a problem - my application creates temporary views for set of talbes > and then I

Re: passing connection to ibatis

2006-09-20 Thread Eugeny N Dzhurinsky
On Tue, Sep 19, 2006 at 03:40:43PM +0300, Eugeny N Dzhurinsky wrote: > Hello! > > I have a problem - my application creates temporary views for set of talbes > and then I would like to execute some queries on this view using iBATIS. For > postgresql the temporary view is alife unless the connectio

passing connection to ibatis

2006-09-19 Thread Eugeny N Dzhurinsky
Hello! I have a problem - my application creates temporary views for set of talbes and then I would like to execute some queries on this view using iBATIS. For postgresql the temporary view is alife unless the connection is closed, so my workflow might looks like this: 1) get the connection from