You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by deepak suldhal <de...@yahoo.com> on 2005/02/21 07:22:48 UTC
JDBC connection - Please help
Please help me make my first JDBC connection
My web.xml
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
-------------------------------------------------------------------------------
In server.xml I have the following context ( trying to connect to Sybase database)
<Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude"
driverClassName="com.sybase.jdbc2.jdbc.SybDriver"
url="jdbc:sybase:Tds:re2unx188:2025"/>
</Context>
-------------------------------------------------------------------------------
I have copied the JDCB drive Jar under
commons/lib
I have a test.jsp as follows
-------------------------------------------------------------------------------
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<sql:query var="rs" dataSource="jdbc/TestDB">
select id, foo, bar from testdata
</sql:query>
<html>
<head>
<title>DB Test</title>
</head>
<body>
<h2>Results</h2>
<c:forEach var="row" items="${rs.rows}">
Foo ${row.foo}<br/>
Bar ${row.bar}<br/>
</c:forEach>
</body>
</html>
-------------------------------------------------------------------------------
My directory structue is as follows
webapps/DBTest/WEB-INF/web.mxl
/DBTest/test.jsp
-------------------------------------------------------------------------------
And when I try the url
http://localhost:8080/DBTest/test.jsp
I am getting the following errors
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.test_jsp._jspService(test_jsp.java:82)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown Source)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown Source)
org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:101)
org.apache.jsp.test_jsp._jspService(test_jsp.java:58)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802
-------------------------------------------------------------------------------
My console server display is as follows
eb 20, 2005 10:31:08 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Feb 20, 2005 10:31:08 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1422 ms
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.28
Feb 20, 2005 10:31:09 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Feb 20, 2005 10:31:10 PM org.apache.catalina.core.StandardHost getDeployer
INFO: Create Host deployer for direct deployment ( non-jmx )
Feb 20, 2005 10:31:10 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\admin.xml
Feb 20, 2005 10:31:10 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Feb 20, 2005 10:31:10 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Feb 20, 2005 10:31:11 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
Feb 20, 2005 10:31:13 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\balancer.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\CurrencyConverter.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\expressionLanguage.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Fin46.xml
Feb 20, 2005 10:31:14 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Fupload.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Hangman.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\helloworld.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\Interactivehelloworld.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\jstltest.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\manager.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\ServletExamples.xml
Feb 20, 2005 10:31:15 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\jakarta-tomcat-5.0.28\conf\Catalina\localhost\store.xml
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /sample from URL file:C:/jakarta-tomcat-5.0.28/webapps/sample
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /jsp-examples from URL file:C:\jakarta-tomcat-5.0.28\webapps\jsp-examples
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path from URL file:C:\jakarta-tomcat-5.0.28\webapps\ROOT
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /servlets-examples from URL file:C:\jakarta-tomcat-5.0.28\webapps\servlets-examples
Feb 20, 2005 10:31:16 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /tomcat-docs from URL file:C:\jakarta-tomcat-5.0.28\webapps\tomcat-docs
Feb 20, 2005 10:31:17 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /webdav from URL file:C:\jakarta-tomcat-5.0.28\webapps\webdav
Feb 20, 2005 10:31:17 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Feb 20, 2005 10:31:17 PM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Feb 20, 2005 10:31:17 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=10/40 config=C:\jakarta-tomcat-5.0.28\conf\jk2.properties
Feb 20, 2005 10:31:17 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 8835 ms
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com