Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 25156 invoked from network); 30 Dec 2008 00:08:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Dec 2008 00:08:11 -0000 Received: (qmail 43788 invoked by uid 500); 30 Dec 2008 00:07:58 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 43758 invoked by uid 500); 30 Dec 2008 00:07:58 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 43747 invoked by uid 99); 30 Dec 2008 00:07:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Dec 2008 16:07:58 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 128.253.83.141 is neither permitted nor denied by domain of dns4@cornell.edu) Received: from [128.253.83.141] (HELO authusersmtp.mail.cornell.edu) (128.253.83.141) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Dec 2008 00:07:48 +0000 Received: from [192.168.5.101] (cpe-69-202-69-218.twcny.res.rr.com [69.202.69.218]) (authenticated bits=0) by authusersmtp.mail.cornell.edu (8.13.1/8.12.10) with ESMTP id mBU07QeW017737 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Mon, 29 Dec 2008 19:07:27 -0500 (EST) Message-ID: <49596641.1020203@cornell.edu> Date: Mon, 29 Dec 2008 19:07:29 -0500 From: David Smith User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) MIME-Version: 1.0 To: Tomcat Users List Subject: Re: Cannot create PoolableConnectionFactory (Unexpected exception encountered during query.) References: <4959549B.5020306@telig.de> In-Reply-To: <4959549B.5020306@telig.de> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org 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: > 13:

${7+7}��

> 14: > 15: > 16: select * from base LIMIT 30; > 17: > 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-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org