This is the only context.xml file I got in the tomcat (5.5.26) directory: /tomcat/apache-tomcat-5.5.26/conf/context.xml:         WEB-INF/web.xml         > ----- Original Message ----- > From: David Smith > Sent: 03/09/08 01:49 am > To: Tomcat Users List > Subject: Re: Can't execute servlet project > > DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: > Cannot create JDBC driver of class '' for connect URL 'null'" > > This error typically indicates the JNDI db pool hasn't been setup > correctly. Some config option isn't setup. What's in this webapp's > context xml file? Also what's in it's WEB-INF/web.xml? Lastly, you > should have your database driver jar file in tomcat's common/lib (for > tomcat v 5.5) or /lib (tomcat v 6). > > You can also take a look at tomcat's JDBC Datasource howto's on the > tomcat website for your version of tomcat which offer a lot of help. > > --David > > sam wun wrote: > > Thanks David, > > > > > > > > After copied the jstl and standard dot jar files into the directory: > > > > linux:~/tomcat/apache-tomcat-5.5.26/webapps/DBTest/WEB-INF/lib # ls > > . .. jstl.jar mysql-connector-java-5.1.3-rc-bin.jar standard.jar > > > > > > > > I got the following different errors: > > > > (In line 4, what is jdbc/TestDB? I have database called javatest, and > table > > testdata. Should I rename it to jdbc/javatest? > > > > > > > > > > > > HTTP Status 500 - > > > > type Exception report > > > > message > > > > description The server encountered an internal error () that prevented > it > > from fulfilling this request. > > > > exception org.apache.jasper.JasperException: Exception in JSP: > > /testdb.jsp:4 > > > > 1: <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> > > 2: <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> > > 3: > > 4: > > 5: select id, foo, bar from testdata > > 6: > > 7: > > > > > > Stacktrace: > > > > > org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451) > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355) > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > > > root cause javax.servlet.ServletException: Unable to get connection, > > DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: > Cannot > > create JDBC driver of class '' for connect URL 'null'" > > > > > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841) > > > > > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774) > > org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:82) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > > > root cause javax.servlet.jsp.JspException: Unable to get connection, > > DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: > Cannot > > create JDBC driver of class '' for connect URL 'null'" > > > > > org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276) > > > > > org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159) > > > > > org.apache.jsp.testdb_jsp._jspx_meth_sql_005fquery_005f0(testdb_jsp.java:101) > > org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:58) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > > > > > > > > > > > > > >> ----- Original Message ----- > >> From: David Smith > >> Sent: 03/09/08 01:23 am > >> To: Tomcat Users List > >> Subject: Re: Can't execute servlet project > >> > >> Download the binary zip file and expand it. Within it is a lib > >> directory with just standard.jar and jstl.jar. > >> > >> --David > >> > >> sam wun wrote: > >> > >>> I just went to the website , very confused. > >>> > >>> The taglib file is not a jar file. they are binary or source file. > >>> > >>> And I couldn't find standard.jar file either. > >>> > >>> > >>> > >>> Thanks > >>> > >>> > >>> > >>> > >>> > >>>> ----- Original Message ----- > >>>> From: David Smith > >>>> Sent: 02/09/08 11:44 pm > >>>> To: Tomcat Users List > >>>> Subject: Re: Can't execute servlet project > >>>> > >>>> Hmmm... good question. I moved over to Maven and don't manually > >>>> download these any more. This looks like it should do the trick: > >>>> > >>>> Try > >>>> > >>>> > >> > http://jakarta.apache.org/site/downloads/downloads_taglibs-standard.cgi > >> > >>>> --David > >>>> > >>>> sam wun wrote: > >>>> > >>>> > >>>>> Hi David, > >>>>> > >>>>> > >>>>> > >>>>> No, I don't have this 2 jar files in the common/lib/ directory. > >>>>> > >>>>> where can I download it from? > >>>>> > >>>>> > >>>>> > >>>>> Thanks > >>>>> > >>>>> Sam > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>> ----- Original Message ----- > >>>>>> From: David Smith > >>>>>> Sent: 02/09/08 10:39 pm > >>>>>> To: Tomcat Users List > >>>>>> Subject: Re: Can't execute servlet project > >>>>>> > >>>>>> Do you have jstl.jar and standard.jar in your WEB-INF/lib > directory? > >>>>>> > >>>>>> --David > >>>>>> > >>>>>> sam wun wrote: > >>>>>> > >>>>>> > >>>>>> > >>>>>>> Hi, > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> I have added testdb.jsp in the following path in Suse linux (the > >>>>>>> > >>>>>>> > >>>> tomcat > >>>> > >>>> > >>>>>>> server): > >>>>>>> > >>>>>>> /tomcat/apache-tomcat-5.5.26/webapps/DBTest/ > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> The content of the testdb.jsp code is: > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> > >>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> > >>>>>>> > >>>>>>> > >>>>>>> select FIRST_NAME from DBTest.Customer > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> DB Test > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>

Results

> >>>>>>> > >>>>>>> > >>>>>>> Foo ${row.foo}
> >>>>>>> Bar ${row.bar}
> >>>>>>>
> >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> when I execute url 10.1.9.1:8080/testdb.jsp in firefox web > browser, > >>>>>>> > >>>>>>> > >>>> it > >>>> > >>>> > >>>>>>> shown the following error: > >>>>>>> > >>>>>>> HTTP Status 500 - > >>>>>>> > >>>>>>> type Exception report > >>>>>>> > >>>>>>> message > >>>>>>> > >>>>>>> description The server encountered an internal error () that > >>>>>>> > >>>>>>> > >>>> prevented > >>>> > >>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>> it > >>>>>> > >>>>>> > >>>>>> > >>>>>>> from fulfilling this request. > >>>>>>> > >>>>>>> exception org.apache.jasper.JasperException: The absolute uri: > >>>>>>> http://java.sun.com/jsp/jstl/sql cannot be resolved in either > >>>>>>> > >> web.xml > >> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>> or > >>>>>> > >>>>>> > >>>>>> > >>>>>>> the jar files deployed with this application > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:51) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:409) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:116) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLibraryInfoImpl.java:317) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.TagLibraryInfoImpl.(TagLibraryInfoImpl.java:148) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:424) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > org.apache.jasper.compiler.Parser.parseDirective(Parser.java:493) > >>>>>>> > org.apache.jasper.compiler.Parser.parseElements(Parser.java:1557) > >>>>>>> org.apache.jasper.compiler.Parser.parse(Parser.java:127) > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.ParserController.doParse(ParserController.java:212) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.compiler.ParserController.parse(ParserController.java:101) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >> org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:156) > >> > >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:296) > >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:277) > >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:265) > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >> > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) > >> > >>>> > >>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) > >>>>>>> > >>>>>>> Here is the web.xml file I got: > >>>>>>> > >>>>>>> (in the path > /tomcat/apache-tomcat-5.5.26/webapps/DBTest/WEB-INF/) > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> 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"> > >>>>>>> > >>>>>>> DBTest > >>>>>>> > >>>>>>> > >>>>>>> Create customer servlet > >>>>>>> > >>>>>>> CreateCustomerServlet > >>>>>>> > >>>>>>> CreateCustomerServlet > >>>>>>> > >>>>>>> > >>>>>>> servlet.CreateCustomerServlet > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> CreateCustomerServlet > >>>>>>> > >>>>>>> /CreateCustomerServlet > >>>>>>> > >>>>>>> > >>>>>>> index.html > >>>>>>> index.htm > >>>>>>> index.jsp > >>>>>>> default.html > >>>>>>> default.htm > >>>>>>> default.jsp > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> DB Connection > >>>>>>> > >>>>>>> jdbc/TestDB > >>>>>>> > >>>>>>> javax.sql.DataSource > >>>>>>> > >>>>>>> Container > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> Thanks > >>>>>>> > >>>>>>> Sam > >>>>>>> > >>>>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>> ----- Original Message ----- > >>>>>>>> From: Martin Gainty > >>>>>>>> Sent: 28/08/08 10:07 pm > >>>>>>>> To: sw2018@gmx.com > >>>>>>>> Subject: RE: Can't execute servlet project > >>>>>>>> > >>>>>>>> david's advice is correct.. > >>>>>>>> > >>>>>>>> configure ./META-INF/ApplicationContext.xml > >>>>>>>> >>>>>>>> debug="5" reloadable="true" crossContext="true"> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> >>>>>>>> type="javax.sql.DataSource" > >>>>>>>> maxActive="100" maxIdle="30" maxWait="10000" > >>>>>>>> username="javauser" password="javadude" > >>>>>>>> driverClassName="com.mysql.jdbc.Driver" > >>>>>>>> > >>>>>>>> url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/> > >>>>>>>> > >>>>>>>> > >>>>>>>> //sub in the username and password for the DB > >>>>>>>> also in /WEB-INF/web.xml you would need this entry > >>>>>>>> >>>>>>>> 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"> > >>>>>>>> MySQL Test App > >>>>>>>> > >>>>>>>> DB Connection > >>>>>>>> jdbc/TestDB > >>>>>>>> javax.sql.DataSource > >>>>>>>> Container > >>>>>>>> > >>>>>>>> > >>>>>>>> then put in this test code changing : > >>>>>>>> DBNAME to the name of your Database > >>>>>>>> TABLE to the name of the table in DBNAME you want to query > >>>>>>>> COLUMN for the specific attribute to query > >>>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" > %> > >>>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> > >>>>>>>> > >>>>>>>> > >>>>>>>> select COLUMN from DBNAME.TABLE > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> DB Test > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>

Results

> >>>>>>>> > >>>>>>>> > >>>>>>>> Foo ${row.foo}
> >>>>>>>> Bar ${row.bar}
> >>>>>>>>
> >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> if you need UNICODE support or Character Large Object (strings > > >>>>>>>> > >> 64k > >> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> in > >>>>>> > >>>>>> > >>>>>> > >>>>>>>> length) download JDBC 4 driver > >>>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html > >>>>>>>> > >>>>>>>> personally I am using the 'older' version of MYSQL so I use the > >>>>>>>> > >> 3.1 > >> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> jar > >>>>>> > >>>>>> > >>>>>> > >>>>>>>> which you can acquire here > >>>>>>>> http://dev.mysql.com/downloads/connector/j > >>>>>>>> > >>>>>>>> location of driver classes: > >>>>>>>> > >>>>>>>> is located in $TOMCAT_HOME/common/lib > >>>>>>>> personally I dont like putting anything in common since it will > >>>>>>>> > >>>>>>>> > >>>> affect > >>>> > >>>> > >>>>>>>> all webapps but i usually > >>>>>>>> place in /WEB-INF/lib > >>>>>>>> > >>>>>>>> and please follow david's advice and read the tutorial > >>>>>>>> > >>>>>>>> Martin > >>>>>>>> ______________________________________________ > >>>>>>>> Disclaimer and confidentiality note > >>>>>>>> Everything in this e-mail and any attachments relates to the > >>>>>>>> > >>>>>>>> > >>>> official > >>>> > >>>> > >>>>>>>> business of Sender. This transmission is of a confidential > nature > >>>>>>>> > >>>>>>>> > >>>> and > >>>> > >>>> > >>>>>>>> Sender does not endorse distribution to any party other than > >>>>>>>> > >>>>>>>> > >>>> intended > >>>> > >>>> > >>>>>>>> recipient. Sender does not necessarily endorse content contained > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> within > >>>>>> > >>>>>> > >>>>>> > >>>>>>>> this transmission. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>> Date: Thu, 28 Aug 2008 11:02:52 +0200 > >>>>>>>>> From: sw2018@gmx.com > >>>>>>>>> Subject: Re: Re: Can't execute servlet project > >>>>>>>>> To: users@tomcat.apache.org; users@tomcat.apache.org > >>>>>>>>> > >>>>>>>>> Hi, > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> I couldn't find an installation document about installing the > >>>>>>>>> > >>>>>>>>> > >>>> driver. > >>>> > >>>> > >>>>>>>>> I;ve downloaded the driver: > >>>>>>>>> > >>>>>>>>> linux:~/tomcat/apache-tomcat-5.5.26/common/lib # ls > >>>>>>>>> mysql-connector-java-5.1.3-rc-bin.jar > >>>>>>>>> mysql-connector-java-5.1.3-rc-bin.jar > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> Do you know how to configure tomcat to make use of it? > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> Thanks > >>>>>>>>> > >>>>>>>>> Sam > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > > > --------------------------------------------------------------------- > 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 >