tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Gainty <mgai...@hotmail.com>
Subject RE: Down the rabbit hole with JDBC
Date Sun, 27 Jul 2008 13:58:47 GMT

http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-j2ee.html#connector-j-usagenotes-tomcat
specifies these configurationparameters
<Context ....>
  <Resource name="jdbc/MySQLDB"
               auth="Container"
               type="javax.sql.DataSource"/>
  <!-- The name you used above, must match _exactly_ here!

       The connection pool will be bound into JNDI with the name
       "java:/comp/env/jdbc/MySQLDB"
  -->
If the name you specify in java:/comp/env doesnt match the resource
then the container wont be able to locate the driver
Your best bet is to download AppServer, Taglibs and MYSQL with Sun App Server(now called Glassfish)
in other words everything at

http://java.sun.com/javaee/downloads/index.jsp

HTH
Martin Gainty 
______________________________________________ 
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. 


> Subject: Down the rabbit hole with JDBC
> From: mlb@imparisystems.com
> To: users@tomcat.apache.org
> Date: Thu, 24 Jul 2008 16:31:37 -0400
> 
> Sorry - I've been slogging through this...
> 
> Anyway, I'm trying to get an application working, but all of their
> documentation talks about is tomcat5.5 and I've got tomcat6
> 
> I have gotten the latest Connector/J binary from MySQL and installed in
> into <tomcat>/lib but I would like to test it.  So, I went to
> 
> http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
> 
> and followed the instructions to set up a DBTest - but I get this
> 
> 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:315)
> 	org.apache.jasper.compiler.TagLibraryInfoImpl.<init>(TagLibraryInfoImpl.java:148)
> 	org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:420)
> 	org.apache.jasper.compiler.Parser.parseDirective(Parser.java:483)
> 	org.apache.jasper.compiler.Parser.parseElements(Parser.java:1433)
> 	org.apache.jasper.compiler.Parser.parse(Parser.java:133)
> 	org.apache.jasper.compiler.ParserController.doParse(ParserController.java:216)
> 	org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
> 	org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:153)
> 	org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
> 	org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
> 	org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
> 	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
> 	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
> 	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
> 	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> 	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> 
> Here's the code that I'm running - are the taglibs incorrect?
> 
> <%@ 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 id, foo, bar from testdata
> </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>
> 
> 
> 
> Matt Burkhardt, MSTM
> President
> Impari Systems, Inc.
> 401 Rosemont Avenue
> Frederick, MD  21701
> mlb@imparisystems.com
> www.imparisystems.com
> (301) 644-3911
> 
> 

_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_mobile_072008
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message