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 connection

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 this

RE: passing connection to ibatis

2006-09-21 Thread Patrick.Higgins
: 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 Clinton mentioned on Sept. 16th: http

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 connection is

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 Patrick.Higgins
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 Hello! I have a problem - my

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