Thanks ... the config in your context.xml and web.xml look normal enough. I would recommend you change your JDK from OpenJDK to Sun's JDK though.
Also was this installed from a Ubuntu's package or installed from a tomcat.apache.org download? If installed from Ubuntu, do a search of Ubuntu's docs on tomcat for how to configure database pooling. Each packager does little things different from the main tomcat distribution that may affect how you need to configure things. One last possibility, repackaged versions have a tendency to split things out into a gazillion different little pieces and you may be missing a package containing the tomcat dbcp jar. If that's the case, the logs should have something to the effect of "ClassNotFound" when you start the service. --David Stefan Riegel wrote: > Here it comes: > > ----------------------- > context.xml in META-INF > ----------------------- > > <Context unpackWAR="true" debug="5" reloadable="true" > crossContext="true"> > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="localhost_DBTest_log." suffix=".log" timestamp="true" /> > > <!-- Default set of monitored resources --> > <WatchedResource>WEB-INF/web.xml</WatchedResource> > > <Resource name="jdbc/TestDB" auth="Container" > type="javax.sql.DataSource" > maxActive="100" maxIdle="30" maxWait="10000" username="correct" > password="also-correct" > driverClassName="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/swex-products" /> > </Context> > > ------------------ > web.xml in 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> > swex-v2009.01</display-name> > <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> > > --------- > index.jsp > --------- > > <?xml version="1.0" encoding="UTF-8" ?> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > <%@ page language="java" contentType="text/html; charset=UTF-8" > pageEncoding="UTF-8"%> > <%@ taglib uri="http://java.sun.com/jsp/jstl/sql"; prefix="sql" %> > <%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> > <title>Insert title here</title> > </head> > <body> > <h1>${7+7}ÄÖ</h1> > > <sql:query var="rs" dataSource="jdbc/TestDB"> > select * from base LIMIT 30 > </sql:query> > > <html> > <head> > <title>DB Test</title> > </head> > <body> > > <h2>Results</h2> > > <c:forEach var="row" items="${rs.rows}"> > Name ${row.name}<br/> > </c:forEach> > > </body> > </html> > > </body> > </html> > > --- > JDK > --- > > OpenJDK Runtime Environment (build 1.6.0_0-b11) > OpenJDK 64-Bit Server VM (build 1.6.0_0-b11, mixed mode) > > Do You need any more information? > > I have no problems connecting to mysql (same database, same user, same > passwd, same port) on localhost with other clients. I use the latest, > fresh, stable mysql Connector/J. > > > David Smith schrieb: >> Can you post relevant parts of your config? Replace the username, >> password and hostnames with fakes, but otherwise post exactly what you >> have in your specific environment. >> >> --David >> >> Stefan Riegel wrote: >>> Hi all, >>> >>> I'm trying to connect to a MySQL database based on the Tomcat Docs >>> example. See the error message below. >>> >>> Similar to the Problem from Krapacs Ambrose, I'm using a standard >>> configured Ubuntu 8.04 Server with Tomcat 5.5. I did follow all hints >>> in the whole thread and reproduced exactly the example from the Tomcat >>> Docs. >>> >>> http://marc.info/?l=tomcat-user&m=122701096423437&w=2 >>> >>> http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html >>> >>> >>> >>> but did not succeed. My security manager is disabled. >>> >>> Hopefully someone can help me. I have spend a complete day without any >>> result. Very frustrating :-( >>> >>> ----------------------------------------------- >>> ---- error messages shown up in the browser --- >>> ----------------------------------------------- >>> >>> type Exception report >>> >>> message >>> >>> description The server encountered an internal error () that prevented >>> it from fulfilling this request. >>> >>> exception >>> >>> org.apache.jasper.JasperException: Exception in JSP: /index.jsp:15 >>> >>> 12: <body> >>> 13: <h1>${7+7}ÄÖ</h1> >>> 14: >>> 15: <sql:query var="rs" dataSource="jdbc/TestDB"> >>> 16: select * from base LIMIT 30; >>> 17: </sql:query> >>> 18: >>> >>> >>> Stacktrace: >>> >>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451) >>> >>> >>> >>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355) >>> >>> >>> >>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) >>> >>> >>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> >>> root cause >>> >>> javax.servlet.ServletException: Unable to get connection, DataSource >>> invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create >>> PoolableConnectionFactory (Unexpected exception encountered during >>> query.)" >>> >>> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841) >>> >>> >>> >>> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774) >>> >>> >>> org.apache.jsp.index_jsp._jspService(index_jsp.java:96) >>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> >>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) >>> >>> >>> >>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) >>> >>> >>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> >>> root cause >>> >>> javax.servlet.jsp.JspException: Unable to get connection, DataSource >>> invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create >>> PoolableConnectionFactory (Unexpected exception encountered during >>> query.)" >>> >>> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276) >>> >>> >>> >>> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159) >>> >>> >>> >>> org.apache.jsp.index_jsp._jspx_meth_sql_005fquery_005f0(index_jsp.java:115) >>> >>> >>> org.apache.jsp.index_jsp._jspService(index_jsp.java:70) >>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> >>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) >>> >>> >>> >>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) >>> >>> >>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) >>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> >>> note The full stack trace of the root cause is available in the Apache >>> Tomcat/5.5 logs. >>> >>> >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@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 unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
