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 >> >> > > -- David Smith Programmer/Analyst College of Agriculture and Life Sciences Cornell University B32 Morrison Hall Ithaca, NY 14853 Phone: (607) 255-4521 --------------------------------------------------------------------- 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