Re: JDBC

Tue, 22 May 2007 03:40:11 -0700

It sounds like you need to read up on both the Servlet Spec and basic Tomcat configuration. There are plenty of tutorials to be found via basic Google searches. This list is usually more able/inclined to help people with problems, rather than basic tutorials. 


As the previous reply pointed out, your Resource is incorrectly named 
'Name' when it should be 'jdbc/myoracledb'.



FYI:

  conf/server.xml  - configures hosts & server
  conf/web.xml     - configures application environment(& more)
  conf/context.xml - configures default Context attributes

  your/WEB-INF/web.xml      - your application config
  your/META-INF/context.xml - your Context config



Each of the above files serves a different purpose, although there are 
some intentional overlaps.  At this stage I'd suggest that all of your 
testing should be done in the latter two files.


rgds


p



Mohammed Zabin wrote:

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]









Attachment:
smime.p7s

Description: S/MIME Cryptographic Signature






















					Reply via email to