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!
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
