You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Mohammed Zabin <jo...@gmail.com> on 2007/05/22 12:27:43 UTC
Oracle 10g with Tomcat 6
Hi All
I want to conigure DBCP to connect to Oracle 10g on my localhost on Tomcat6.
I did the following error, I don't know how to solve it, is there is a
third-party jar file that must be added to classpath???
*1. I put the following in server.xml*
*<Resource name="jbdc/myoracledb" auth="Container"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/myoracledb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:orcldb</value>
</parameter>
<parameter>
<name>username</name>
<value>hr</value>
</parameter>
<parameter>
<name>password</name>
<value>hr</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>*
*2. The following in web.xml:*
*<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracledb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>*
3. And here is my JSP Code:
<%@ page import="javax.sql.*, javax.naming.*, java.sql.*" %>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb");
Connection conn = ds.getConnection();
out.println( "Connection Established" );
%>
When running the page, i got the following error:
*org.apache.jasper.JasperException: An exception occurred processing
JSP page /jsp/testDBCP.jsp at line 7
4: Context initContext = new InitialContext();
5: Context envContext = (Context)initContext.lookup("java:/comp/env");
6: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb");
7: Connection conn = ds.getConnection();
8:
9: out.println( "Connection Established" );
10: %>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)*
**
*root cause *
*javax.servlet.ServletException:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.jsp.testDBCP_jsp._jspService(testDBCP_jsp.java:73)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)*
Re: Oracle 10g with Tomcat 6
Posted by David Smith <dn...@cornell.edu>.
You are using an old syntax for defining resource parameters.
Parameters of a resource are defined as attributes of the <Resource />
element since tomcat 5.5. See the following docs for the correct method:
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
--David
Mohammed Zabin wrote:
> Hi All
> I want to conigure DBCP to connect to Oracle 10g on my localhost on
> Tomcat6.
> I did the following error, I don't know how to solve it, is there is a
> third-party jar file that must be added to classpath???
>
> *1. I put the following in server.xml*
> *<Resource name="jbdc/myoracledb" auth="Container"
> type="javax.sql.DataSource" />
>
> <ResourceParams name="jdbc/myoracledb">
> <parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>oracle.jdbc.OracleDriver</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:oracle:thin:@127.0.0.1:1521:orcldb</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>hr</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>hr</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>20</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>10</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>-1</value>
> </parameter>
> </ResourceParams>*
>
> *2. The following in web.xml:*
> *<resource-ref>
> <description>Oracle Datasource example</description>
> <res-ref-name>jdbc/myoracledb</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>*
>
> 3. And here is my JSP Code:
>
> <%@ page import="javax.sql.*, javax.naming.*, java.sql.*" %>
>
> <%
> Context initContext = new InitialContext();
> Context envContext = (Context)initContext.lookup("java:/comp/env");
> DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb");
> Connection conn = ds.getConnection();
>
> out.println( "Connection Established" );
> %>
>
> When running the page, i got the following error:
>
> *org.apache.jasper.JasperException: An exception occurred processing
> JSP page /jsp/testDBCP.jsp at line 7
>
> 4: Context initContext = new InitialContext();
> 5: Context envContext = (Context)initContext.lookup("java:/comp/env");
> 6: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb");
> 7: Connection conn = ds.getConnection();
> 8:
> 9: out.println( "Connection Established" );
> 10: %>
>
>
> Stacktrace:
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)*
>
> **
>
> *root cause *
>
> *javax.servlet.ServletException:
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' for connect URL 'null'
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
>
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
>
> org.apache.jsp.jsp.testDBCP_jsp._jspService(testDBCP_jsp.java:73)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)*
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org