Re: Can't execute servlet project

Tue, 02 Sep 2008 08:31:35 -0700

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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to