I have been struggling with this problem for more than
a week. I did follow the JDBC datasource howto. And I
posted all the steps that I have taken to configure
the Tomcat 5.0.27 connection pool. Nobody has really
helped to look into the problem. Tomcat 5.0.27,
j2sdk1.4.2, Oracle 10i, Windows XP
I will post all my configuration steps again below the
error message. The Tomcat logs file shows:
==============================================
root cause
org.dhsinfo.content.exceptions.PageDAOSysException:
SQLException: Cannot create JDBC driver of class ''
for connect URL 'null'
org.dhsinfo.content.dao.OraclePageDAO.findPages(OraclePageDAO.java:51)
org.dhsinfo.content.PageService.getPages(PageService.java:18)
org.dhsinfo.content.SelectPage.execute(SelectPage.java:29)
=================================================
The configuration steps that I have taken are listed
below:
Step 1.
Jakarta-Commons DBCP 1.2.1
Jakarta-Commons Collections 2.1.1
Jakarta-Commons Pool 1.2
These jar files are installed in
$CATALINA_HOME/common/lib.
Step 2.
download classes12.zip rename it to classes12.jar and
place it in
TOMCAT_HOME\common\lib
Step 3. C:\jakarta-tomcat-5.0.27\conf\server.xml
configuration
I did put the driver and URL in the
C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
code shown below is inserted between
the <Logger
className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log."
suffix=".txt" timestamp="true"/> and the
closing </Host> tag).
<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true"
crossContext="true">
<Logger
className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log."
suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/OracleDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>password</name>
<value>cmis001</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@172.19.47.22:1521:devora2</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>cmis</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
Step 4. web.xml Configuration (the one in
MyApp/WEB-INF directory)
add these lines after the <taglib> element
**********************
<resource-ref>
<description>Oracle Datasource</description>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
**********************
--- Peng Tuck Kwok <[EMAIL PROTECTED]> wrote:
> On Tue, 14 Sep 2004 13:56:48 -0700 (PDT), Caroline
> Jen
> <[EMAIL PROTECTED]> wrote:
>
> > When I configured the Tomcat 5.0.27, I did put the
> > driver and URL in the
> > C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
>
> That's great, but did you actually put the driver in
> a location that
> tomcat could find it ?
> Like here: $CATALINA_HOME/common/lib ? Dump your
> driver there (make
> sure it's a jar file),
> restart tomcat. Check out the jdbc datasource howto
> if you've missed
> anything else.
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
