Second, are there any exceptions in your logs related to the problem below outside the "Cannot create JDBC driver of ....."
Third, please post the segment of code responsible for actually doing the lookup and getting a DataSource object.
Fourth, check your file permissions and be sure Tomcat has read access to your class12.jar.
Lastly, is this the most recent version of the Oracle JDBC driver?
--David
Caroline Jen wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
