Configuring Tomcat's Resource Factory...

[Atanu Dey]

Hi,
When Iam trying to configure tomcat's resource factory , it is giving error:
----- Root Cause -----
javax.servlet.ServletException: java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc racle:thin@132.132.1.22:1521 bform'
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:497)
at org.apache.jsp.Cricket_jsp._jspService(Cricket_jsp.java:636)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)

where 132.132.1.22 is my database server url and dbform is the database service name. Iam configuring with the following parameter:
<Resource name="jdbc/SPAppDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SPAppDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>sportsprix</value>
</parameter>
<parameter>
<name>password</name>
<value>sportsprix</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc racle:thin@132.132.1.22:1521 bform</value>
</parameter>
Please somebody help me...this is urgent..
Thanks in advance..
Atanu

[Larry Henderson]

I am using windows 2000 and a Access database. Connection Pooling is working for me. This is what I have under <Host> in server.xml also add next node web.xml.
SERVER.XML
<DefaultContext>
<Resource name="jdbc/AnnuitiesDb" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/AnnuitiesDb">
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc dbc:annuities</value>
</parameter>
</ResourceParams>
</DefaultContext>
WEB.XML
<resource-ref>
<res-ref-name>jdbc/AnnuitiesDb</res-ref-name>
<res-type>jdbc/AnnuitiesDb</res-type>
<res-auth>jdbc/AnnuitiesDb</res-auth>
</resource-ref>