HTTP Status 500 -  -------------------------------------------------------------------------------- type Exception report message  description The server encountered an internal error () that prevented it from fulfilling this request. exception  org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ show tables ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38) root cause  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ show tables ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:498) com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl.listTables(CmsDataBackDaoImpl.java:69) com.jeecms.cms.manager.assist.impl.CmsDataBackMngImpl.listTabels(CmsDataBackMngImpl.java:35) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy62.listTabels(Unknown Source) com.jeecms.cms.action.admin.assist.DataAct.list(DataAct.java:72) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38) root cause  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) java.lang.reflect.Constructor.newInstance(Unknown Source) com.mysql.jdbc.Util.handleNewInstance(Util.java:406) com.mysql.jdbc.Util.getInstance(Util.java:381) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1451) com.mysql.jdbc.Field.getCollation(Field.java:475) com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:561) com.sun.rowset.CachedRowSetImpl.initMetaData(Unknown Source) com.sun.rowset.CachedRowSetImpl.populate(Unknown Source) org.springframework.jdbc.core.SqlRowSetResultSetExtractor.createSqlRowSet(SqlRowSetResultSetExtractor.java:63) org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:46) org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:1) org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:445) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:498) com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl.listTables(CmsDataBackDaoImpl.java:69) com.jeecms.cms.manager.assist.impl.CmsDataBackMngImpl.listTabels(CmsDataBackMngImpl.java:35) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy62.listTabels(Unknown Source) com.jeecms.cms.action.admin.assist.DataAct.list(DataAct.java:72) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.32 logs. MySQL版本是： Server version: *.25a MySQL Community Server (GPL)

你是不是改了数据库？或使用的是以前的数据库? Unknown table 'table_names' in information_schema 
?

<br/>19:13:*143 INFO  com.jeecms.cms.service.CmsSiteFlowCacheImpl - refresh cache flows to DB: 0 <br/>19:22:40.125 INFO  org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer - ClassTemplateLoader for Spring macros added to FreeMarker configuration <br/>19:25:47.887 INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] <br/>19:25:47.919 INFO  org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase] <br/>2013-1-27 19:25:47 org.apache.catalina.core.StandardWrapperValve invoke <br/>严重: Servlet.service() for servlet [JeeCmsAdmin] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ show tables ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema] with root cause <br/>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema <br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) <br/> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) <br/> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) <br/> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) <br/> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) <br/> at com.mysql.jdbc.Util.getInstance(Util.java:386) <br/> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) <br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) <br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) <br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) <br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) <br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2728) <br/> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2678) <br/> at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612) <br/> at com.mysql.jdbc.Field.getCollation(Field.java:493) <br/> at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:567) <br/> at com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:704) <br/> at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:621) <br/> at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.createSqlRowSet(SqlRowSetResultSetExtractor.java:63) <br/> at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:46) <br/> at org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:1) <br/> at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:445) <br/> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) <br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) <br/> at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:498) <br/> at com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl.listTables(CmsDataBackDaoImpl.java:69) <br/> at com.jeecms.cms.manager.assist.impl.CmsDataBackMngImpl.listTabels(CmsDataBackMngImpl.java:35) <br/> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br/> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br/> at java.lang.reflect.Method.invoke(Method.java:597) <br/> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) <br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) <br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) <br/> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) <br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) <br/> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) <br/> at $Proxy63.listTabels(Unknown Source) <br/> at com.jeecms.cms.action.admin.assist.DataAct.list(DataAct.java:72) <br/> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br/> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br/> at java.lang.reflect.Method.invoke(Method.java:597) <br/> at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) <br/> at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) <br/> at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) <br/> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) <br/> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) <br/> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) <br/> at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) <br/> at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) <br/> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) <br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) <br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) <br/> at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) <br/> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) <br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) <br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) <br/> at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) <br/> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) <br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) <br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) <br/> at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38) <br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) <br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) <br/> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) <br/> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) <br/> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) <br/> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) <br/> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) <br/> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) <br/> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) <br/> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) <br/> at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) <br/> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) <br/> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) <br/> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) <br/> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) <br/> at java.lang.Thread.run(Thread.java:662) <br/>



mysql 数据库版本*.29

奇怪了 换成这样就可以通过

public List<String> listTables() {
String sql = "  SELECT TABLE_NAME FROM information_schema.`TABLES` where  TABLE_SCHEMA ='jeecms'";
List<String> tables = new ArrayList<String>();
SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
while (set.next()) {
tables.add(set.getString(1));
}
return tables;
}