Mohammed, for driver value, try the following: <value>oracle.jdbc.OracleDriver</value>
-----Original Message----- From: Mohammed Zabin [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 22, 2007 4:33 AM To: Tomcat Users List Subject: Re: JDBC 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] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
