Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-19 Thread Guillermo Fernandes
You're welcome On Thu, Dec 17, 2009 at 11:55 AM, Filip Hanik - Dev Lists devli...@hanik.com wrote: Thank you very much! On 12/17/2009 07:11 AM, Guillermo Fernandes wrote: I have attached the interceptor to the bugzilla ticket. Actually, it extends the AbstractStatementInterceptor.

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-17 Thread Guillermo Fernandes
I have attached the interceptor to the bugzilla ticket. Actually, it extends the AbstractStatementInterceptor. Guillermo. On Wed, Dec 16, 2009 at 4:47 PM, Filip Hanik - Dev Lists devli...@hanik.com wrote: correct, there is an AbstractStatementInterceptor that you would extend in order to

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-17 Thread Filip Hanik - Dev Lists
Thank you very much! On 12/17/2009 07:11 AM, Guillermo Fernandes wrote: I have attached the interceptor to the bugzilla ticket. Actually, it extends the AbstractStatementInterceptor. Guillermo. On Wed, Dec 16, 2009 at 4:47 PM, Filip Hanik - Dev Listsdevli...@hanik.com wrote:

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-16 Thread Guillermo Fernandes
Hi Filip, Yes, we are aware that the API allow us to write our own JdbcInterceptor so we are writing an interceptor to handle this issue by creating a proxy for the statement and resultSet. We will attach it to the bugzilla ticket as a workaround, but we think the issue should be fixed inside

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-16 Thread Filip Hanik - Dev Lists
correct, there is an AbstractStatementInterceptor that you would extend in order to write such an extension. Filip On 12/16/2009 06:02 AM, Guillermo Fernandes wrote: Hi Filip, Yes, we are aware that the API allow us to write our own JdbcInterceptor so we are writing an interceptor to handle

tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-15 Thread Guillermo Fernandes
Hi, I'm using ddlutils 1.0 and tomcat jdbc pool 1.0.7.1 and I getting an error due to a connection is closed and the pool is not aware of that. Basically the issue is that ddlutils has a resultset iterator and when it finishes it closes the connection by getting it from the *

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-15 Thread Mark Thomas
On 15/12/2009 17:34, Guillermo Fernandes wrote: Hi, I'm using ddlutils 1.0 and tomcat jdbc pool 1.0.7.1 and I getting an error due to a connection is closed and the pool is not aware of that. Basically the issue is that ddlutils has a resultset iterator and when it finishes it closes the

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-15 Thread Guillermo Fernandes
Ok, I agree it is a bug. I have created the ticket: https://issues.apache.org/bugzilla/show_bug.cgi?id=48392 https://issues.apache.org/bugzilla/show_bug.cgi?id=48392Actually I'm using commons-dbcp but were are not getting good performance results so I wanted to try out with the tomcat jdbc-pool.

Re: tomcat jdbc pool is not proxying resultSets and preparedStatements

2009-12-15 Thread Filip Hanik - Dev Lists
On 12/15/2009 10:34 AM, Guillermo Fernandes wrote: Hi, I'm using ddlutils 1.0 and tomcat jdbc pool 1.0.7.1 and I getting an error due to a connection is closed and the pool is not aware of that. Basically the issue is that ddlutils has a resultset iterator and when it finishes it closes the