tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Konstantin Kolinko <knst.koli...@gmail.com>
Subject Re: tomcat and DB oracle problem - only in higher versions
Date Fri, 17 Aug 2012 11:44:18 GMT
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


Mime
View raw message