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