Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of knst.kolinko@gmail.com
 designates 209.85.212.45 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <5019567329481D4B89004F8A89319897221BAD4D7D@AVMX1.at-work.local>
References: <5019567329481D4B89004F8A89319897221BAD4A7A@AVMX1.at-work.local>
	<7215BA462D00D343B2837F9113F0131F01277DAEC4@POSTOFFICE02.polydyne.com>
	<5019567329481D4B89004F8A89319897221BAD4D7D@AVMX1.at-work.local>
Date: Fri, 17 Aug 2012 15:44:18 +0400
Message-ID: 
 <CABzHfVmXmeaHow3U3rS+jVvx0tt0ieE=HwHdYEksJVKUMeBwrQ@mail.gmail.com>
Subject: Re: tomcat and DB oracle problem - only in higher versions
From: Konstantin Kolinko <knst.kolinko@gmail.com>
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

2012/8/17 Busfy,Peter <Peter.Busfy@drei.com>:
> Hi again,
>
> so I try ojdbc6.jar (version 11.2.0.3.0) with tomcat 6.0.35 and the same problem.
> With version 6.0.26 is everything fine.
>

6.0.26 and 6.0.35 include different versions of Apache Commons DBCP
library (http://commons.apache.org/dbcp/).  You may look into the
changelog or into build.properties in the source distributive to see
the version number.

Later DBCP versions implement wrapping of the underlying JDBC
connection object differently.

On this mailing list such issue has been discussed at least 3 times
during the last 2 years.
(I do not remember what the exact recipe was. I think that you have to
do the following two operations:
1. set a property on the pool to allow unwrapping,
2. call a method to get the wrapped connection.
 See the archives and see the DBCP site).

>From that Spring message -- I guess you have to look for
"NativeJdbcExtractor" implementations and find one that works with
DBCP.

See OracleLobHandler.etNativeJdbcExtractor(..)

http://static.springsource.org/spring/docs/3.1.x/javadoc-api/org/springframework/jdbc/support/lob/OracleLobHandler.html#setNativeJdbcExtractor%28org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractor%29

There exists "CommonsDbcpNativeJdbcExtractor" class. Maybe it will work for you.

If not, you may try debugging Tomcat (see "Developing" chapter in the
Tomcat FAQ for tips).

Best regards,
Konstantin Kolinko

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org