tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sam wun" <sw2...@gmx.com>
Subject Re: Re: Can't execute servlet project
Date Tue, 02 Sep 2008 13:14:42 GMT
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
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message