mysql与tomcat连接的问题

显示全部楼层 · 2007-1-6 21:14:12

我用eclipse发布一个简单的连接mysql显示表中名字的例子,但搞了两天,查了很多资料修复了很多bug终于快弄出来的时候,一个bug终结了我的希望的曙光!搞了很长时间都没结果.只是tomcat下异常是这样的:
11:06:39 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file

\Tomcat 5.0\conf\Catalina\localhost\hello.xml
java.sql.SQLException: Column 'name' not found.

at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2320)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1826)

at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:216)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:59)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)

at java.lang.Thread.run(Thread.java:536)

千问 · 2007-1-6 21:14:12

问题市name我根本没用到啊,mysql表中的数据名是username

千问 · 2007-1-6 21:14:12

查一下你的select语句，应该是含有name字段，可事实上这个NAME字段不存在

千问 · 2007-1-6 21:14:12

非常感谢,问题解决了