When searching on Tomcat documentation, i found that it uses both server.xmland
web.xml, again, I got the same 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( "The Connection Gotted Fine" );
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)*
On 5/22/07, Foo Shyn <[EMAIL PROTECTED]> wrote:
Check out ur resource name, it is different from the one u use to get ur
connection pooling. The resource name must be the same as your lookup
name.
HTH
FooShyn
Mohammed Zabin wrote:
> Thank you Foo for your patience with me,
> I did imported all the needed classes, but i got the following
exception:
>
>
> *exception *
>
> *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( "The Connection Gotted Fine" );
> 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)*
>
> **
>
> *root cause*
>
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' for connect URL 'null'
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
BasicDataSource.java:780)
>
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:540)
>
> org.apache.jsp.jsp.testDBCP_jsp._jspService(testDBCP_jsp.java:62)
> 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)
>
> *root cause*
>
> java.lang.NullPointerException
> sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
> sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
> sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
> java.sql.DriverManager.getDriver(DriverManager.java:253)
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
BasicDataSource.java:773)
>
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:540)
>
> org.apache.jsp.jsp.testDBCP_jsp._jspService(testDBCP_jsp.java:62)
> 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)
>
>
>
>
> On 5/22/07, Foo Shyn <[EMAIL PROTECTED]> wrote:
>>
>> The jsp doesn't import the class for Context and Initial Context. Put
>> them in as how u inport the Datasource would do.
>>
>> HTH
>> FooShyn
>>
>> Mohammed Zabin wrote:
>> > Thank you Foo,
>> > I but the following in the context.xml:
>> >
>> > *<Resource name="Name"
>> > auth="Container"
>> > type="oracle.jdbc.pool.OracleDataSource"
>> > factory="oracle.jdbc.pool.OracleDataSourceFactory"
>> > user="hr"
>> > password="hr"
>> > driverClassName="oracle.jdbc.driver.OracleDriver"
>> > url="jdbc:oracle:thin:@localhost:1521:orcldb"
>> > maxActive="20" maxIdle="10" maxwait="-1"/>*
>> > **
>> > and I have this jsp code:
>> >
>> >
>> > *<%@ page import="javax.sql.DataSource" %>*
>> >
>> > *<%
>> > 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( "Got the connection" );
>> > %>*
>> >
>> > but, i got the following error:
>> >
>> > *org.apache.jasper.JasperException: Unable to compile class for JSP:
>> >
>> > An error occurred at line: 4 in the jsp file: /jsp/testDBCP.jsp
>> > Context cannot be resolved to a type
>> > 1: <%@ page import="javax.sql.DataSource" %>
>> > 2:
>> > 3: <%
>> > 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();
>> >
>> >
>> > An error occurred at line: 4 in the jsp file: /jsp/testDBCP.jsp
>> > InitialContext cannot be resolved to a type
>> > 1: <%@ page import="javax.sql.DataSource" %>
>> > *
>> >
>> > On 5/22/07, Foo Shyn <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Not both of them. It's context.xml if u're using Tomcat 5.0 or
above,
>> or
>> >> server.xml if u're using Tomcat 4.1 or below, which is located in
the
>> >> conf folder in Tomcat root path.
>> >>
>> >> check this link out :
>> >> http://forums.oracle.com/forums/thread.jspa?messageID=1489914
>> >>
>> >> Hope that helps.
>> >> FooShyn
>> >>
>> >> Mohammed Zabin wrote:
>> >> > Thank you buddy, I have another confusing question for me,
>> >> > I have two web.xml files, one in conf/web.xml and one in my
>> >> application
>> >> > under WEB-INF,
>> >> > When configuring connection pool, which one shall i use? or shall
i
>> >> > put the
>> >> > configuration parameters in both of them??
>> >> >
>> >> > Thank you
>> >> >
>> >> >
>> >> > On 5/22/07, ben short <[EMAIL PROTECTED]> wrote:
>> >> >>
>> >> >> Have a look here..
>> >> >>
>> >> >>
>> >> >>
>> >>
>>
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
>>
>> >>
>> >> >>
>> >> >>
>> >> >> On 5/22/07, Mohammed Zabin <[EMAIL PROTECTED]> wrote:
>> >> >> > Hi All
>> >> >> >
>> >> >> > Am new on this, i want to know how to configure Database
>> Connection
>> >> >> Pooling
>> >> >> > to use Oracle Database?? anyhelp will be appreciated.
>> >> >> >
>> >> >> > Jotnarta
>> >> >> >
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To start a new topic, e-mail: users@tomcat.apache.org
>> >> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >> >> For additional commands, e-mail: [EMAIL PROTECTED]
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>>
------------------------------------------------------------------------
>> >> >
>> >> > No virus found in this incoming message.
>> >> > Checked by AVG Free Edition.
>> >> > Version: 7.5.467 / Virus Database: 269.7.6/814 - Release Date:
>> >> 5/21/2007
>> >> 2:01 PM
>> >> >
>> >>
>> >>
>> >>
---------------------------------------------------------------------
>> >> To start a new topic, e-mail: users@tomcat.apache.org
>> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >> For additional commands, e-mail: [EMAIL PROTECTED]
>> >>
>> >>
>> >
>> >
>>
------------------------------------------------------------------------
>> >
>> > No virus found in this incoming message.
>> > Checked by AVG Free Edition.
>> > Version: 7.5.467 / Virus Database: 269.7.6/814 - Release Date:
>> 5/21/2007
>> 2:01 PM
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.467 / Virus Database: 269.7.6/814 - Release Date: 5/21/2007
2:01 PM
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
