tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edas Pazera" <e...@usa.net>
Subject SQL Taglib error with MySQL
Date Sat, 13 Jan 2001 07:06:46 GMT
I am getting this error when using Apache's SQL taglib.  If I test the same
query by using some basic Java DB access code it works just fine, so I
conclude that there's something in a taglib or Tomcat setup?  Anyone has any
ideas?

Thanks,

Edas

------------
Tomcat 3.2.1
mm.mysql.jdbc-2.0pre5
MySQL 2.23.28-gamma


Internal Servlet Error:

javax.servlet.ServletException: Couldn't open database:
jdbc:mysql://localhost/myDB
    SQLException: Cannot disable AUTO_COMMIT
	at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
	at
servlets._0002fservlets_0002fsql_0002ejspsql_jsp_8._jspService(_0002fservlet
s_0002fsql_0002ejspsql_jsp_8.java:337)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
	at org.apache.tomcat.core.Handler.service(Handler.java:286)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at
org.apache.tomcat.service.connector.Ajp13ConnectionHandler.processConnection
(Ajp13ConnectionHandler.java:160)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:484)

Root cause:
javax.servlet.jsp.JspException: Couldn't open database:
jdbc:mysql://localhost/myDB
    SQLException: Cannot disable AUTO_COMMIT
	at
org.apache.taglibs.sql.ConnectionTag.makeConnection(ConnectionTag.java:103)
	at
org.apache.taglibs.sql.ConnectionTag.getConnection(ConnectionTag.java:136)
	at org.apache.taglibs.sql.ConnectionTag.doAfterBody(ConnectionTag.java:159)
	at
servlets._0002fservlets_0002fsql_0002ejspsql_jsp_8._jspService(_0002fservlet
s_0002fsql_0002ejspsql_jsp_8.java:275)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
	at org.apache.tomcat.core.Handler.service(Handler.java:286)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at
org.apache.tomcat.service.connector.Ajp13ConnectionHandler.processConnection
(Ajp13ConnectionHandler.java:160)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:484)


Mime
View raw message