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
