启动Tomcat时遇到了SQLGrammarException，原因是尝试访问的'MDM_TOKEN'和'MDM_SYS_LOG'表不存在。错误堆栈显示了Hibernate和MySQL的相关异常。解决方案包括检查数据库表名的大小写敏感性，确保与数据库配置一致，或者修改MySQL配置文件以忽略大小写。此外，也提到了Java内存设置，特别是PermGen空间不足可能导致的OutOfMemoryError，可以通过调整JVM参数如-Xms, -Xmx和-XX:MaxPermSize来增大内存配额。"
2100545,199860,电话号码过滤神器V2.2：高效算法与批量处理,"['工具', '电话', 'java', '算法', 'jdk']
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.huawei.framework.dao.QuerySqlHibernateCallback.doInHibernate(QuerySqlHibernateCallback.java:81)
at com.huawei.framework.dao.QuerySqlHibernateCallback.doInHibernate(QuerySqlHibernateCallback.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 18 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'testmdm.MDM_TOKEN' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 27 more
log4j:ERROR Failed to excute sql
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'testmdm.MDM_SYS_LOG' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:218)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:289)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:186)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
at org.apache.log4j.Category.callAppenders(Category.java:210)
at org.apache.log4j.Category.forcedLog(Category.java:398)
at org.apache.log4j.Category.error(Category.java:331)
at com.huawei.mdm.module.interfaces.service.ClearTokenService.cleanToken(ClearTokenService.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Hibernate:
select
this_.id as id6_0_,
this_.AUTH_EFFICACY_LINK as AUTH2_6_0_,
this_.AUTH_NAME as AUTH3_6_0_,
this_.CODE as CODE6_0_,
this_.LEVEL as LEVEL6_0_,
this_.SHOW_FLAG as SHOW6_6_0_,
this_.TITLE as TITLE6_0_
from
MDM_AUTH this_
where
(
this_.CODE=?
)
2012-12-07 11:20:14 [localhost-startStop-1] ERROR com.huawei.framework.util.SystemInitListener.initSystemMenu(SystemInitListener.java:91) init error
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.AUTH_EFFICACY_LINK as AUTH2_6_0_, this_.AUTH_NAME as AUTH3_6_0_, this_.CODE as CODE6_0_, this_.LEVEL as LEVEL6_0_, this_.SHOW_FLAG as SHOW6_6_0_, this_.TITLE as TITLE6_0_ from MDM_AUTH this_ where (this_.CODE=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:1078)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:1062)
at com.huawei.mdm.model.dao.AuthDao.findbyCode(AuthDao.java:68)
at com.huawei.mdm.module.admin.service.LoginService.getAuthByCode(LoginService.java:80)
at com.huawei.framework.util.SystemInitListener.initSystemMenu(SystemInitListener.java:89)
at com.huawei.framework.util.SystemInitListener.contextInitialized(SystemInitListener.java:61)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:1090)
at org.springframework.orm.hibernate3.HibernateTemplate$37.doInHibernate(HibernateTemplate.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 17 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'testmdm.MDM_AUTH' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 25 more
2012-12-7 11:20:14 org.apache.catalina.core.StandardContext startInternal
严重: Error listenerStart
2012-12-7 11:20:14 org.apache.catalina.core.StandardContext startInternal
严重: Context [/mdm] startup failed due to previous errors
2012-12-07 11:20:14 [localhost-startStop-1] INFO org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1020) Closing Root WebApplicationContext: startup date [Fri Dec 07 11:20:12 CST 2012]; root of context hierarchy
2012-12-07 11:20:14 [localhost-startStop-1] INFO org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:433) Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@7336193e: defining beans [sessionFactory,transactionManager,dataSource,systemconf,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,com.huawei.mdm.model.dao.OuterSystemSummeryDao,com.huawei.mdm.model.dao.DeviceDao,com.huawei.mdm.model.dao.SrcurePolicyDao,com.huawei.mdm.model.dao.OutSystemDao,com.huawei.mdm.model.dao.AppGroupAppDao,com.huawei.mdm.model.dao.AppFlowDao,com.huawei.mdm.model.dao.AccountDao,com.huawei.mdm.model.dao.PasswordPolicyDao,com.huawei.mdm.model.dao.AppFileDao,com.huawei.mdm.model.dao.WebPolicyDao,com.huawei.mdm.model.dao.DeviceDynamicInfoDao,com.huawei.mdm.model.dao.AccGroupAccountDao,com.huawei.mdm.model.dao.PostionInfoDao,com.huawei.mdm.model.dao.MdmTokenDao,com.huawei.mdm.model.dao.AppGroupDao,com.huawei.mdm.model.dao.RoamPolicyDao,com.huawei.mdm.model.dao.AppRateDao,com.huawei.mdm.model.dao.AppInfoDao,com.huawei.mdm.model.dao.AdminUserDao,com.huawei.mdm.model.dao.AppGroupAccGroupDao,com.huawei.mdm.model.dao.AppBWListDao,com.huawei.mdm.model.dao.ApAccessDao,com.huawei.mdm.model.dao.AuthDao,com.huawei.mdm.model.dao.SysLogDao,com.huawei.mdm.model.dao.AccGroupDao,com.huawei.mdm.module.outsys.serive.OutSystemSerive,com.huawei.mdm.module.remotecontrol.service.RemoteControlService,com.huawei.mdm.module.account.service.AccountGroupService,com.huawei.mdm.module.account.service.AccountService,com.huawei.mdm.module.admin.service.LoginService,com.huawei.mdm.module.security.serive.PasswordPolicyService,com.huawei.mdm.module.security.serive.ApAccessService,com.huawei.mdm.module.security.serive.SrcurePolicySerive,com.huawei.mdm.module.security.serive.WebpageBWService,token,com.huawei.mdm.module.interfaces.service.MdmUserService,com.huawei.mdm.module.interfaces.service.TokenService,clearTokenService,com.huawei.mdm.module.interfaces.service.AppService,com.huawei.mdm.module.interfaces.service.PadService,upDataFace,policyCommandRestful,webPageBWRestful,appBWListRestful,apAccessRestful,roamingPolicyRestful,appFace,pwdPolicyRestful,mdmUser,com.huawei.mdm.module.devicemgr.service.DeviceService,com.huawei.mdm.module.outbound.CleanCache,com.huawei.mdm.module.outbound.OutBoundUtilService,com.huawei.mdm.module.outbound.PushServer,com.huawei.mdm.module.roamPolicy.service.RoamingPolicyService,com.huawei.mdm.module.appbwlist.service.AppBWListService,com.huawei.mdm.module.phonelocate.service.PhoneLocateService,com.huawei.mdm.module.admin.service.LoggerService,com.huawei.mdm.module.adminuser.service.AdminUserService,com.huawei.mdm.module.appstore.service.AppStoreService,org.springframework.context.annotation.internalAsyncAnnotationProcessor,org.springframework.context.annotation.internalScheduledAnnotationProcessor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy
2012-12-07 11:20:14 [localhost-startStop-1] INFO org.springframework.orm.hibernate3.AbstractSessionFactoryBean.destroy(AbstractSessionFactoryBean.java:223) Closing Hibernate SessionFactory
2012-12-7 11:20:14 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
严重: The web application [/mdm] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
2012-12-7 11:20:14 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
严重: The web application [/mdm] appears to have started a thread named [MySQL Statement Cancellation Timer] but has failed to stop it. This is very likely to create a memory leak.
log4j:ERROR setFile(null,false) call failed.
java.io.FileNotFoundException: /app/log/runtime.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.(FileOutputStream.java:194)
at java.io.FileOutputStream.(FileOutputStream.java:116)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:207)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307)
at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:295)
at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176)
at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191)
at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523)
at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:492)
at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1006)
at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872)
at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778)
at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
at org.apache.log4j.LogManager.(LogManager.java:127)
at org.apache.log4j.Logger.getLogger(Logger.java:104)
at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:289)
at org.apache.commons.logging.impl.Log4JLogger.(Log4JLogger.java:109)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1116)
at org.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:914)
at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:604)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:336)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:310)
at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:685)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:270)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
2012-12-07 11:20:15 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:273) Root WebApplicationContext: initialization started
2012-12-07 11:20:15 [localhost-startStop-1] INFO org.springframework.context.support.AbstractApplicationContext.prepareRefresh(AbstractApplicationContext.java:495) Refreshing Root WebApplicationContext: startup date [Fri Dec 07 11:20:15 CST 2012]; root of context hierarchy
2012-12-07 11:20:15 [localhost-startStop-1] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:315) Loading XML bean definitions from ServletContext resource [/WEB-INF/spring.xml]
2012-12-07 11:20:15 [localhost-startStop-1] INFO org.springframework.core.io.support.PropertiesLoaderSupport.loadProperties(PropertiesLoaderSupport.java:177) Loading properties file from URL [file:/opt/apache-tomcat-7.0.32/webapps/AppStore/WEB-INF/classes/appstore.properties]
2012-12-07 11:20:15 [localhost-startStop-1] INFO org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557) Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@730eb2f0: defining beans [propertyConfigurer,dataSource,sessionFactory,transactionManager,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,com.huawei.appstore.model.dao.AppGroupAppDao,com.huawei.appstore.model.dao.AccountDao,com.huawei.appstore.model.dao.FileGroupAccDao,com.huawei.appstore.model.dao.AppFileDao,com.huawei.appstore.model.dao.FileInfoDao,com.huawei.appstore.model.dao.FileGroupDao,com.huawei.appstore.model.dao.AppGroupDao,com.huawei.appstore.model.dao.LinkDao,com.huawei.appstore.model.dao.AppInfoDao,com.huawei.appstore.model.dao.AdminUserDao,com.huawei.appstore.model.dao.AppGroupAccGroupDao,com.huawei.appstore.model.dao.PublicKeyDao,com.huawei.appstore.model.dao.AuthDao,com.huawei.appstore.model.dao.SysLogDao,com.huawei.appstore.model.dao.AccGroupDao,com.huawei.appstore.module.fileInfo.service.FileInfoService,com.huawei.appstore.module.admin.service.LoginService,com.huawei.appstore.module.app.service.AppService,com.huawei.appstore.module.interfaces.service.UpdateAppService,com.huawei.appstore.module.interfaces.service.LinkService,com.huawei.appstore.module.interfaces.service.TokenService,com.huawei.appstore.module.interfaces.service.AppService,com.huawei.appstore.module.interfaces.service.FileGroupService,com.huawei.appstore.module.interfaces.service.AppGroupService,appGroupRestful,manageLink,updateAppRestful,fileGroupRestful,fileInfoRestful,publicKeyRestful,downFile,filesInGroupRestful,appStore,appRestful,com.huawei.appstore.module.logger.service.LoggerService,com.huawei.appstore.module.publickey.service.PublicKeyService,com.huawei.appstore.module.fileGroup.service.FileGroupAccountService,com.huawei.appstore.module.fileGroup.service.FileGroupService,com.huawei.appstore.module.managerlink.service.ManagerLinkService,org.springframework.context.annotation.internalAsyncAnnotationProcessor,org.springframework.context.annotation.internalScheduledAnnotationProcessor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,systemconf,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
2012-12-07 11:20:16 [localhost-startStop-1] INFO org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:777) Building new Hibernate SessionFactory
2012-12-07 11:20:16 [localhost-startStop-1] INFO org.springframework.orm.hibernate3.HibernateTransactionManager.afterPropertiesSet(HibernateTransactionManager.java:415) Using DataSource [org.apache.tomcat.dbcp.dbcp.BasicDataSource@3bb51db7] of Hibernate SessionFactory for HibernateTransactionManager
2012-12-07 11:20:16 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:302) Root WebApplicationContext: initialization completed in 1484 ms
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Parsing configuration file [struts-default.xml]
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Parsing configuration file [struts-plugin.xml]
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Parsing configuration file [struts.xml]
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (spring) for (com.opensymphony.xwork2.ObjectFactory)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.FileManager)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.conversion.impl.XWorkConverter)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.TextProvider)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (rest) for (com.opensymphony.xwork2.ActionProxyFactory)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.conversion.ObjectTypeDeterminer)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (rest) for (org.apache.struts2.dispatcher.mapper.ActionMapper)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (jakarta) for (org.apache.struts2.dispatcher.multipart.MultiPartRequest)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (org.apache.struts2.views.freemarker.FreemarkerManager)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (org.apache.struts2.components.UrlRenderer)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.validator.ActionValidatorManager)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.util.ValueStackFactory)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.util.reflection.ReflectionProvider)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.util.reflection.ReflectionContextFactory)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.util.PatternMatcher)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (org.apache.struts2.dispatcher.StaticContentLoader)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (com.opensymphony.xwork2.UnknownHandlerManager)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Choosing bean (struts) for (org.apache.struts2.views.util.UrlHelper)
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Loading global messages from resources
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Loading global messages from web
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Initializing Struts-Spring integration...
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) Setting autowire strategy to name
2012-12-07 11:20:17 [localhost-startStop-1] INFO com.opensymphony.xwork2.util.logging.commons.CommonsLogger.info(CommonsLogger.java:42) ... initialized Struts-Spring integration successfully
2012-12-7 11:20:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory /opt/apache-tomcat-7.0.32/webapps/docs
2012-12-7 11:20:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory /opt/apache-tomcat-7.0.32/webapps/ROOT
2012-12-7 11:20:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory /opt/apache-tomcat-7.0.32/webapps/host-manager
2012-12-7 11:20:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory /opt/apache-tomcat-7.0.32/webapps/manager
2012-12-7 11:20:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory /opt/apache-tomcat-7.0.32/webapps/examples
2012-12-7 11:20:17 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
2012-12-7 11:20:17 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
2012-12-7 11:20:17 org.apache.catalina.startup.Catalina start
信息: Server startup in 8671 ms
上面错误原因：linux下mysql严格区分大小写，导致在导入数据库时大小写敏感，tomcat启动会找不到大小写不匹配段表或列
解决办法：修改linux下mysql的配置文件 /etc/mysql/my.conf 搜索[mysqld]加入 lower_case_table_names=1
lower_case_table_names=1只不区分大小写 0表示区分 不配置默认为区分
tomcat启动时报内存泄露解决方案：
最近在开发的时候Tomcat时不时会报java.lang.OutOfMemoryError: PermGen异常，开始报的几次没有太在意，认为可能是误操作，报多了感觉不爽，上网查了下觉的这个异常有点怪，转个帖子。
原因：
PermGen
space的全称是Permanent Generation
space,是指内存的永久保存区域，这块内存主要是被JVM存放Class和Meta信息的,Class在被Loader时就会被放到PermGen
space中，它和存放类实例(Instance)的Heap区域不同,GC(Garbage
Collection)不会在主程序运行期对PermGen space进行清理，所以如果你的应用中有很CLASS的话,就很可能出现PermGen
space错误，这种错误常见在web服务器对JSP进行pre compile的时候。如果你的WEB APP下都用了大量的第三方jar,
其大小超过了jvm默认的大小(4M)那么就会产生此错误信息了。
解决方法：
1. 手动设置MaxPermSize大小
修改TOMCAT_HOME/bin/catalina.bat(Linux下为catalina.sh)，在“echo "Using CATALINA_BASE: $CATALINA_BASE"”上面加入以下行：
set JAVA_OPTS=%JAVA_OPTS% -server -XX:PermSize=128M -XX:MaxPermSize=512m
catalina.sh下为：
JAVA_OPTS="$JAVA_OPTS -server -XX:PermSize=128M -XX:MaxPermSize=512m"
2. 将相同的第三方jar文件移置到tomcat/shared/lib目录下，这样可以达到减少jar 文档重复占用内存的目的。
如果遇到这个异常：java.lang.OutOfMemoryError: Java heap space 是什么原因呢？
解释：
Heap size 设置
JVM堆的设置是指java程序运行过程中
JVM可以调配使用的内存空间的设置.JVM在启动的时候会自动设置Heap
size的值，其初始空间(即-Xms)是物理内存的1/64，最大空间(-Xmx)是物理内存的1/4。可以利用JVM提供的-Xmn -Xms
-Xmx等选项可进行设置。Heap size 的大小是Young Generation 和Tenured Generaion 之和。
提示：在JVM中如果98％的时间是用于GC且可用的Heap size 不足2％的时候将抛出此异常信息。
提示：Heap Size 最大不要超过可用物理内存的80％，一般的要将-Xms和-Xmx选项设置为相同，而-Xmn为1/4的-Xmx值。
解决方法：
手动设置Heap size
修改TOMCAT_HOME/bin/catalina.bat，在“echo "Using CATALINA_BASE: $CATALINA_BASE"”上面加入以下行：
set JAVA_OPTS=%JAVA_OPTS% -server -Xms800m -Xmx800m -XX:MaxNewSize=256m
或修改catalina.sh
在“echo "Using CATALINA_BASE: $CATALINA_BASE"”上面加入以下行：
JAVA_OPTS="$JAVA_OPTS -server -Xms800m -Xmx800m -XX:MaxNewSize=256m"
另外看到了另外一个帖子，觉得挺好，摘抄如下：
SUN JDK+Tomcat 5.5.20运行服务的时候遇到问题，服务器跑几天后就会挂掉，并报java.lang.OutOfMemoryError: PermGen space异常。
发现很多人把问题归因于：
spring,hibernate,tomcat，因为他们动态产生类,导致JVM中的permanent heap溢出
。然后解决方法众说纷纭，有人说升级
tomcat版本到最新甚至干脆不用tomcat。还有人怀疑spring的问题，在spring论坛上讨论很激烈，因为spring在AOP时使用
CBLIB会动态产生很多类。
但问题是为什么这些王牌的开源会出现同一个问题呢，那么是不是更基础的原因呢？tomcat在Q&A很隐晦的回答了这一点，我们知道这个问题，但这个问题是由一个更基础的问题产生。
于是有人对更基础的JVM做了检查，发现了问
题的关键。原来SUN
的JVM把内存分了不同的区，其中一个就是permenter区用来存放用得非常多的类和类描述。本来SUN设计的时候认为这个区域在JVM启动的时候就
固定了，但他没有想到现在动态会用得这么广泛。而且这个区域有特殊的垃圾收回机制，现在的问题是动态加载类到这个区域后，gc根本没办法回收！
2003年的时候就有一个bug报告给
sun，但是到现在，这个bug还没有close！有人在这个bug加了句评语：“A bug this critical is open since
2003? Absolutely shameful.” 我觉得SUN在这个BUG上确实有些丢脸。
对这个bug最彻底的解决办法就是不要用SUN的JDK，而改用BEA的 JRokit.
打不过，还逃不过吗？ 有众多的选择，这就是开源的好。 ：)
最后，给出几篇文章供大家学习参考：
7618
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
