tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: Can't execute servlet project
Date Tue, 02 Sep 2008 15:23:31 GMT
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" %>
>>>>>
>>>>> <sql:query var="rs" dataSource="jdbc/TestDB">
>>>>> select FIRST_NAME from DBTest.Customer
>>>>> </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>
>>>>>
>>>>>
>>>>>
>>>>> 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.<init>(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/)
>>>>>
>>>>>
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <web-app id="WebApp_ID" version="2.4" 
>>>>> 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">
>>>>>         <display-name>
>>>>>         DBTest</display-name>
>>>>>         <servlet>
>>>>>                 <description>
>>>>>                 Create customer servlet</description>
>>>>>                 <display-name>
>>>>>                 CreateCustomerServlet</display-name>
>>>>>                 
>>>>> <servlet-name>CreateCustomerServlet</servlet-name>
>>>>>                 <servlet-class>
>>>>>                 
>>>>> servlet.CreateCustomerServlet</servlet-class>
>>>>>         </servlet>
>>>>>         <servlet-mapping>
>>>>>                 
>>>>> <servlet-name>CreateCustomerServlet</servlet-name>
>>>>>                 
>>>>> <url-pattern>/CreateCustomerServlet</url-pattern>
>>>>>         </servlet-mapping>
>>>>>         <welcome-file-list>
>>>>>                 <welcome-file>index.html</welcome-file>
>>>>>                 <welcome-file>index.htm</welcome-file>
>>>>>                 <welcome-file>index.jsp</welcome-file>
>>>>>                 <welcome-file>default.html</welcome-file>
>>>>>                 <welcome-file>default.htm</welcome-file>
>>>>>                 <welcome-file>default.jsp</welcome-file>
>>>>>         </welcome-file-list>
>>>>>         <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>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 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 
>>>>>> <Context path="/DBTest" docBase="DBTest"
>>>>>>         debug="5" reloadable="true" crossContext="true">
>>>>>>
>>>>>>     <!-- maxActive: Maximum number of dB connections in pool.
Make 
>>>>>>         
>>>>>>             
>>>> sure 
>>>>     
>>>>         
>>>>>> you
>>>>>>          configure your mysqld max_connections large enough to 
>>>>>>             
>> handle
>>     
>>>>>>          all of your db connections. Set to 0 for no limit.
>>>>>>          -->
>>>>>>
>>>>>>     <!-- maxIdle: Maximum number of idle dB connections to retain
in 
>>>>>> pool.
>>>>>>          Set to -1 for no limit.  See also the DBCP documentation
on 
>>>>>>         
>>>>>>             
>>>> this
>>>>     
>>>>         
>>>>>>          and the minEvictableIdleTimeMillis configuration parameter.
>>>>>>          -->
>>>>>>
>>>>>>     <!-- maxWait: Maximum time to wait for a dB connection to
become 
>>>>>> available
>>>>>>          in ms, in this example 10 seconds. An Exception is thrown

>>>>>>             
>> if
>>     
>>>>>>          this timeout is exceeded.  Set to -1 to wait indefinitely.
>>>>>>          -->
>>>>>>
>>>>>>     <!-- username and password: MySQL dB username and password
for 
>>>>>>             
>> dB 
>>     
>>>>>> connections  -->
>>>>>>
>>>>>>     <!-- driverClassName: Class name for the old mm.mysql JDBC

>>>>>>             
>> driver 
>>     
>>>>>>         
>>>>>>             
>>>> is
>>>>     
>>>>         
>>>>>>          org.gjt.mm.mysql.Driver - we recommend using Connector/J

>>>>>>         
>>>>>>             
>>>> though.
>>>>     
>>>>         
>>>>>>          Class name for the official MySQL Connector/J driver is

>>>>>> com.mysql.jdbc.Driver.
>>>>>>          -->
>>>>>>
>>>>>>     <!-- url: The JDBC connection url for connecting to your MySQL

>>>>>>             
>> dB.
>>     
>>>>>>          The autoReconnect=true argument to the url makes sure that

>>>>>>         
>>>>>>             
>>>> the
>>>>     
>>>>         
>>>>>>          mm.mysql JDBC Driver will automatically reconnect if mysqld

>>>>>> closed the
>>>>>>          connection.  mysqld by default closes idle connections 
>>>>>>             
>> after 
>>     
>>>>>>         
>>>>>>             
>>>> 8 
>>>>     
>>>>         
>>>>>> hours.
>>>>>>          -->
>>>>>>
>>>>>>   <Resource name="jdbc/TestDB" auth="Container" 
>>>>>> 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"/>
>>>>>>
>>>>>> </Context>
>>>>>> //sub in the username and password for the DB
>>>>>> also in /WEB-INF/web.xml you would need this entry
>>>>>> <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>
>>>>>> 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"
%>
>>>>>>
>>>>>> <sql:query var="rs" dataSource="jdbc/TestDB">
>>>>>> select COLUMN from DBNAME.TABLE
>>>>>> </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>
>>>>>>
>>>>>> 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


Mime
View raw message