WM C wrote:
> Hi Mark - Thanks for the reply, here is the info you asked:
> 
>> Where is the oracle jdbc driver jar located?
> in web-inf/lib  (I am using ojdbc14.jar - btw, according to some forum 
> messages, seems it got problem with jdk5.0, but that's a different story) 
> 
>> Where are the commons-dbcp and commons-pool JARs located?
> in web-inf/lib
> 
>> Exactly which versions of Tomcat, commons-pool and commons-dbcp are you 
>> using?
> it's apache-tomcat-5.5.17
> commoms-dbcp version: Implementation-Version: 1.2.1 (got it from MENIFEST 
> file, Build-Jdk: 1.4.1_02 - maybe that's the reason)
> commons-pool version: Implementation-Version: 1.3
> 
>> What is the full stack trace?
> I did not have it, it went to IDE console, did not save. (but it did not 
> generate much info using e.printStackTrace)
> 
>> What is your complete resource definition?
> <Resource name="jdbc/myDS" auth="Container"
>         type="javax.sql.DataSource" 
>         maxActive="50" maxIdle="30" maxWait="10000" 
>         username="xxx" password="xxxxx"
>         driverClassName="oracle.jdbc.driver.OracleDriver"
>         factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>         url="jdbc:oracle:thin:@nnn.nnn.nnn.nn:1521:xxxx"
>         removeAbandoned="true" />
> 
>> Which file has this resource definition been placed in?
> at context.xml in META-INF
> 
> By the way, I am using Eclipse 3.2, jdk1.5.0_14 - I set compiler compliance 
> level 5.0, but set generated .class compatibility to 1.4 and source 
> compatibility to 1.4 .
> 
> Thanks a lot for the help!

Given all of that, stick with your working configuration and don't try
switching to the re-packaged Tomcat pooling (it is the same code so in
terms of functionality the only difference is the library versions).

I would consider upgrading to commons-pool-1.5.4 and the soon to be
released commons-dbcp 1.3 (1.4 will be released at the same time and is
the same code but with support for JDBC4 which requires a 1.6 JDK) for
some performance improvements but if you don't need the extra
performance and your config works you can happily stay where you are.

Mark

> 
> William
> 
> 
>> Date: Sat, 28 Nov 2009 10:29:25 +0000
>> From: ma...@apache.org
>> To: users@tomcat.apache.org
>> Subject: Re: data source factory
>>
>> WM C wrote:
>>> Hi -
>>>
>>> I am upgrading a working web app from Tomcat 5.0 to 5.5, and encounter the 
>>> following data source problem.
>>>
>>> According to Apache web site, for Tomcat 5.5 configuration, I should use
>>>
>>>        factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory
>>>
>>> in <Resource> for datasource configuration.
>>>
>>> It works okay for the most jdbc part, except that I got an exception of
>>>
>>>      java.lang.ClassCastException: oracle.sql.CLOB 
>>>
>>> at the line oracle.sql.CLOB clob = (oracle.sql.CLOB) rs.getClob(...) in one 
>>> DAO method.
>>>
>>> Since the code works in Tomcat5.0, so I changed factory attribute back to
>>>  
>>>      factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>>>
>>> and everything works fine now. No exception thrown anymore.
>>>
>>> Since this is a kind of a desperate "trail and error" after scratching my 
>>> head for a day (true Black Friday :( )
>>> so even though it works, I am wondering if I should use the 
>>> DataSourceFactory meant to be used for Tomcat 5.0, and if there will be any 
>>> bad consequences later on.
>>>
>>> Thanks a lot for any comments - I appreciate!
>> Where is the oracle jdbc driver jar located?
>> Where are the commons-dbcp and commons-pool JARs located?
>> Exactly which versions of Tomcat, commons-pool and commons-dbcp are you
>> using?
>> What is the full stack trace?
>> What is your complete resource definition?
>> Which file has this resource definition been placed in?
>>
>> Do you want to use Tomcat's built-in connection pool or are you happy
>> with anything as long as it works?
>>
>> Mark
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>
>                                         
> _________________________________________________________________
> Windows 7: I wanted simpler, now it's simpler. I'm a rock star.
> http://www.microsoft.com/Windows/windows-7/default.aspx?h=myidea?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:112009




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

Reply via email to