主题 :为何我本机的MYSQL5.0可以连接服务器的MYSQL6.0就不能连接呢 |
发表于:2016-04-22 15:33:37
IP:221.235.*.*
折腾了很久,还是一堆XXXX 不过好坏可以看到界面运行了 就是只要一改成服务器的数据库就报错了 用本机的测试没有问题
et mars 版本根本调不了 换成了luna版的eclipse 好晕这个数据库的问题 真有的点头大了 [INFO] Scanning for projects... [WARNING] [WARNING] Some problems were encountered while building the effective model for com.pinhuba:bams:war:2.2 [WARNING] 'dependencies.dependency.systemPath' for com.oracle:ojdbc14:jar should not point at files within the project directory, ${project.basedir}/src/main/webapp/WEB-INF/lib/ojdbc14.jar will be unresolvable by dependent projects @ line 101, column 23 [WARNING] [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. [WARNING] [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. [WARNING] [INFO] [INFO] Using the builder org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder with a thread count of 1 [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building bams Maven Webapp 2.2 [INFO] ------------------------------------------------------------------------ [INFO] [INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) @ bams >>> [INFO] [INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bams --- [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 15 resources [INFO] [INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ bams --- [INFO] Nothing to compile - all classes are up to date [INFO] [INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) @ bams <<< [INFO] [INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bams --- [INFO] Running war on http://localhost:8080/bams [INFO] Using existing Tomcat server configuration at G:\workspace\bams\target\tomcat [INFO] create webapp with contextPath: /bams 四月 22, 2016 3:29:18 下午 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["http-bio-8080"] 四月 22, 2016 3:29:18 下午 org.apache.catalina.core.StandardService startInternal 信息: Starting service Tomcat 四月 22, 2016 3:29:18 下午 org.apache.catalina.core.StandardEngine startInternal 信息: Starting Servlet Engine: Apache Tomcat/7.0.37 四月 22, 2016 3:29:23 下午 org.apache.catalina.core.ApplicationContext log 信息: No Spring WebApplicationInitializer types detected on classpath 四月 22, 2016 3:29:23 下午 org.apache.catalina.core.ApplicationContext log 信息: Set web app root system property: 'bams' = [G:\workspace\bams\src\main\webapp\] 四月 22, 2016 3:29:23 下午 org.apache.catalina.core.ApplicationContext log 信息: Initializing log4j from [classpath:log/console.properties] 四月 22, 2016 3:29:23 下午 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext 2016-04-22 15:29:23 INFO - Root WebApplicationContext: initialization started 2016-04-22 15:29:23 INFO - Refreshing Root WebApplicationContext: startup date [Fri Apr 22 15:29:23 CST 2016]; root of context hierarchy 2016-04-22 15:29:23 INFO - Loading XML bean definitions from class path resource [springconf/spring-config-web.xml] 2016-04-22 15:29:23 INFO - Loading XML bean definitions from class path resource [springconf/spring-activiti.xml] 2016-04-22 15:29:23 INFO - Loading XML bean definitions from class path resource [springconf/spring-service.xml] 2016-04-22 15:29:24 INFO - Loading properties file from class path resource [proxool.properties] 2016-04-22 15:29:24 INFO - Loading properties file from class path resource [hbmconf/hibernateConfig.properties] 2016-04-22 15:29:24 INFO - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring 2016-04-22 15:29:24 INFO - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4b5686: defining beans [servletContextRealPathResolver,processAction,importAction,exportAction,loginAction,announceAction,workArrangeService,userLoginService,sysProcessService,personalOfficeSerivce,officeResourcesService,oaNewsService,oaDesktopSerivce,oaCompanyResourcesService,oaChartterService,netdiskService,moblieSmsService,mailService,hrmEmployeeService,hrmContractService,fileProcessService,approveProcessService,sysUserViewDaoImpl,sysUserMethodsDaoImpl,sysUserInfoDaoImpl,sysUserGroupDetailDaoImpl,sysUserGroupDaoImpl,sysUserBtnsDaoImpl,sysRoleDetailDaoImpl,sysRoleDaoImpl,sysRoleBtnDaoImpl,sysRoleBindDaoImpl,sysProcessTypeDaoImpl,sysProcessConfigDaoImpl,sysParamDaoImpl,sysMsgDaoImpl,sysMethodShortcutDaoImpl,sysMethodInfoDaoImpl,sysMethodHelpDaoImpl,sysMethodBtnDaoImpl,sysLogRuntimeDaoImpl,sysLogDaoImpl,sysLibraryStandardDaoImpl,sysLibraryInfoDaoImpl,sysImageInfoDaoImpl,sysHelpDaoImpl,sysExceptionDaoImpl,sysConfigDaoImpl,sysCompanyMethodsDaoImpl,sysCompanyInfoDaoImpl,sysColumnControlDaoImpl,sysAttachmentInfoDaoImpl,oaWorkLogDaoImpl,oaWaretypeRangeDaoImpl,oaWarehouseDaoImpl,oaWareTypeDaoImpl,oaVoteStatusDaoImpl,oaVoteOptionDaoImpl,oaVoteDaoImpl,oaTrsvelDaoImpl,oaToolsDaoImpl,oaSummaryDaoImpl,oaSmsSendDaoImpl,oaSmsInboxDaoImpl,oaRegulationsDaoImpl,oaPostsDaoImpl,oaPhotoDaoImpl,oaNoticeDaoImpl,oaNotebookDaoImpl,oaNetmailUidDaoImpl,oaNetmailSetDaoImpl,oaNetmailSendboxDaoImpl,oaNetmailPersonDaoImpl,oaNetmailInboxDaoImpl,oaNetdiskShareDaoImpl,oaNetdiskConfigDaoImpl,oaMeetapplyDaoImpl,oaMailSendDaoImpl,oaMailInboxDaoImpl,oaMailEmpDaoImpl,oaLeaveregistrationDaoImpl,oaJournalsTypeDaoImpl,oaJournalsDaoImpl,oaForumsDaoImpl,oaFormsDaoImpl,oaDesktopSetDaoImpl,oaChattersDaoImpl,oaChatGroupsDaoImpl,oaCarUseDaoImpl,oaCarMaintenDaoImpl,oaCarMaintainDaoImpl,oaCarDaoImpl,oaCarApplyDaoImpl,oaCalenderDaoImpl,oaBookTypeDaoImpl,oaBookDaoImpl,oaBookBrDaoImpl,oaBoardroomDaoImpl,oaAnnouncementDaoImpl,oaAlbumDaoImpl,oaAdversariaDaoImpl,hrmWorkareaDaoImpl,hrmTimedrecordDaoImpl,hrmPostDaoImpl,hrmEmployeeDaoImpl,hrmDepartmentDaoImpl,hrmContractTypeDaoImpl,hrmContractDaoImpl,applicationContextHelper,wordExport,excelExport,fileHelper,fileService,fileAction,dbDesignAction,codeAction,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,propertyConfigurer,proxoolDataSource,sessionFactory,jdbcTemplate,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,processEngineConfiguration,processEngine,repositoryService,runtimeService,formService,identityService,taskService,historyService,managementService,postTaskListener,leaveFinishProcessor,__dwrConfiguration,__dwrHrmEmployeeService,dwrHrmEmployeeService,__dwrHrmContractService,dwrHrmContractService,__dwrSysProcessService,dwrSysProcessService,__dwrCommonService,dwrCommonService,__dwrWorkArrangeService,dwrWorkArrangeService,__dwrOACompanyResourcesService,dwrOACompanyResourcesService,__dwrOaNewsService,dwrOaNewsService,__dwrOfficeResourcesService,dwrOfficeResourcesService,__dwrOaCommunicationService,dwrOaCommunicationService,__dwrMoblieSmsService,dwrMoblieSmsService,__dwrMailService,dwrMailService,__dwrApproveProcessService,dwrApproveProcessService,__dwrPersonalOfficeService,dwrPersonalOfficeService,__dwrPersonalProcessService,dwrPersonalProcessService,__dwrOADesktopService,dwrOADesktopService,__dwrNetdiskService,dwrNetdiskService,simpleAdvice,exceptionCatcherAdvice,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy 2016-04-22 15:29:25 INFO - Hibernate 3.3.2.GA 2016-04-22 15:29:25 INFO - hibernate.properties not found 2016-04-22 15:29:25 INFO - Bytecode provider name : javassist 2016-04-22 15:29:25 INFO - using JDK 1.4 java.sql.Timestamp handling 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNotebook -> oa_notebook 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmWorkarea -> hrm_workarea 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysAttachmentInfo -> sys_attachment_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysMethodInfo -> sys_method_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysMethodBtn -> sys_method_btn 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysMethodHelp -> sys_method_help 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysCompanyMethods -> sys_company_methods 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysMsg -> sys_msg 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysHelp -> sys_help 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysLog -> sys_log 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysLogRuntime -> sys_log_runtime 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysException -> sys_exception 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysUserInfo -> sys_user_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysColumnControl -> sys_column_control 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysImageInfo -> sys_image_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmPost -> hrm_post 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmEmployee -> hrm_employee 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysCompanyInfo -> sys_company_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysUserMethods -> sys_user_methods 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysUserBtns -> sys_user_btns 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysUserGroup -> sys_user_group 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysUserGroupDetail -> sys_user_group_detail 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysRole -> sys_role 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysRoleDetail -> sys_role_detail 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysRoleBtn -> sys_role_btn 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysRoleBind -> sys_role_bind 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysLibraryInfo -> sys_library_info 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysLibraryStandard -> sys_library_standard 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmDepartment -> hrm_department 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysConfig -> sys_config 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaWarehouse -> oa_warehouse 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaWareType -> oa_ware_type 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaWaretypeRange -> oa_waretype_range 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaAnnouncement -> oa_announcement 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaBoardroom -> oa_boardroom 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNotice -> oa_notice 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaWorkLog -> oa_work_log 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaForms -> oa_forms 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaAdversaria -> oa_adversaria 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaMeetapply -> oa_meetapply 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaJournalsType -> oa_journals_type 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaJournals -> oa_journals 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaSummary -> oa_summary 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCalender -> oa_calender 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCar -> oa_car 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCarUse -> oa_car_use 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaAlbum -> oa_album 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCarApply -> oa_car_apply 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaPhoto -> oa_photo 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaChatters -> oa_chatters 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaChatGroups -> oa_chat_groups 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCarMainten -> oa_car_mainten 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaSmsSend -> oa_sms_send 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaSmsInbox -> oa_sms_inbox 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaBook -> oa_book 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaRegulations -> oa_regulations 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaBookBr -> oa_book_br 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaForums -> oa_forums 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaPosts -> oa_posts 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaMailInbox -> oa_mail_inbox 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaMailSend -> oa_mail_send 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaMailEmp -> oa_mail_emp 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaBookType -> oa_book_type 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaVote -> oa_vote 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaVoteOption -> oa_vote_option 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaVoteStatus -> oa_vote_status 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaCarMaintain -> oa_car_maintain 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysParam -> sys_param 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaLeaveregistration -> oa_leaveregistration 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaTrsvel -> oa_trsvel 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaTools -> oa_tools 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetdiskShare -> oa_netdisk_share 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetdiskConfig -> oa_netdisk_config 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaDesktopSet -> oa_desktop_set 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmTimedrecord -> hrm_timedrecord 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetmailSet -> oa_netmail_set 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetmailPerson -> oa_netmail_person 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetmailSendbox -> oa_netmail_sendbox 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetmailInbox -> oa_netmail_inbox 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.OaNetmailUid -> oa_netmail_uid 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysMethodShortcut -> sys_method_shortcut 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmContract -> hrm_contract 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.HrmContractType -> hrm_contract_type 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysProcessConfig -> sys_process_config 2016-04-22 15:29:25 INFO - Mapping class: com.pinhuba.core.pojo.SysProcessType -> sys_process_type 2016-04-22 15:29:25 INFO - Building new Hibernate SessionFactory 2016-04-22 15:29:25 INFO - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider 2016-04-22 15:29:26 INFO - RDBMS: MySQL, version: 6.0.2-alpha-community-nt-debug 2016-04-22 15:29:26 INFO - JDBC driver: MySQL Connector Java, version: mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) 2016-04-22 15:29:27 INFO - Using dialect: org.hibernate.dialect.MySQLDialect 2016-04-22 15:29:27 INFO - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory 2016-04-22 15:29:27 INFO - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 2016-04-22 15:29:27 INFO - Automatic flush during beforeCompletion(): disabled 2016-04-22 15:29:27 INFO - Automatic session close at end of transaction: disabled 2016-04-22 15:29:27 INFO - JDBC batch size: 25 2016-04-22 15:29:27 INFO - JDBC batch updates for versioned data: disabled 2016-04-22 15:29:27 INFO - Scrollable result sets: enabled 2016-04-22 15:29:27 INFO - JDBC3 getGeneratedKeys(): enabled 2016-04-22 15:29:27 INFO - JDBC result set fetch size: 50 2016-04-22 15:29:27 INFO - Connection release mode: after_transaction 2016-04-22 15:29:27 INFO - Maximum outer join fetch depth: 2 2016-04-22 15:29:27 INFO - Default batch fetch size: 1 2016-04-22 15:29:27 INFO - Generate SQL with comments: disabled 2016-04-22 15:29:27 INFO - Order SQL updates by primary key: disabled 2016-04-22 15:29:27 INFO - Order SQL inserts for batching: disabled 2016-04-22 15:29:27 INFO - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 2016-04-22 15:29:27 INFO - Using ASTQueryTranslatorFactory 2016-04-22 15:29:27 INFO - Query language substitutions: {} 2016-04-22 15:29:27 INFO - JPA-QL strict compliance: disabled 2016-04-22 15:29:27 INFO - Second-level cache: enabled 2016-04-22 15:29:27 INFO - Query cache: disabled 2016-04-22 15:29:27 INFO - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge 2016-04-22 15:29:27 INFO - Cache provider: org.hibernate.cache.HashtableCacheProvider 2016-04-22 15:29:27 INFO - Optimize cache for minimal puts: disabled 2016-04-22 15:29:27 INFO - Structured second-level cache entries: disabled 2016-04-22 15:29:27 INFO - Echoing all SQL to stdout 2016-04-22 15:29:27 INFO - Statistics: disabled 2016-04-22 15:29:27 INFO - Deleted entity synthetic identifier rollback: disabled 2016-04-22 15:29:27 INFO - Default entity-mode: pojo 2016-04-22 15:29:27 INFO - Named query checking : enabled 2016-04-22 15:29:27 INFO - building session factory 2016-04-22 15:29:28 INFO - Not binding factory to JNDI, no JNDI name configured 2016-04-22 15:29:28 INFO - Using DataSource [org.logicalcobwebs.proxool.ProxoolDataSource@2afdba] of Hibernate SessionFactory for HibernateTransactionManager 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.StandardContext listenerStart 严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291) 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.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:353) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1015) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:443) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:417) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:559) at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304) ... 22 more Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62) at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:446) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:982) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1363) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25) at org.activiti.engine.impl.interceptor2016-04-22 15:29:30 INFO - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4b5686: defining beans [servletContextRealPathResolver,processAction,importAction,exportAction,loginAction,announceAction,workArrangeService,userLoginService,sysProcessService,personalOfficeSerivce,officeResourcesService,oaNewsService,oaDesktopSerivce,oaCompanyResourcesService,oaChartterService,netdiskService,moblieSmsService,mailService,hrmEmployeeService,hrmContractService,fileProcessService,approveProcessService,sysUserViewDaoImpl,sysUserMethodsDaoImpl,sysUserInfoDaoImpl,sysUserGroupDetailDaoImpl,sysUserGroupDaoImpl,sysUserBtnsDaoImpl,sysRoleDetailDaoImpl,sysRoleDaoImpl,sysRoleBtnDaoImpl,sysRoleBindDaoImpl,sysProcessTypeDaoImpl,sysProcessConfigDaoImpl,sysParamDaoImpl,sysMsgDaoImpl,sysMethodShortcutDaoImpl,sysMethodInfoDaoImpl,sysMethodHelpDaoImpl,sysMethodBtnDaoImpl,sysLogRuntimeDaoImpl,sysLogDaoImpl,sysLibraryStandardDaoImpl,sysLibraryInfoDaoImpl,sysImageInfoDaoImpl,sysHelpDaoImpl,sysExceptionDaoImpl,sysConfigDaoImpl,sysCompanyMethodsDaoImpl,sysCompanyInfoDaoImpl,sysColumnControlDaoImpl,sysAttachmentInfoDaoImpl,oaWorkLogDaoImpl,oaWaretypeRangeDaoImpl,oaWarehouseDaoImpl,oaWareTypeDaoImpl,oaVoteStatusDaoImpl,oaVoteOptionDaoImpl,oaVoteDaoImpl,oaTrsvelDaoImpl,oaToolsDaoImpl,oaSummaryDaoImpl,oaSmsSendDaoImpl,oaSmsInboxDaoImpl,oaRegulationsDaoImpl,oaPostsDaoImpl,oaPhotoDaoImpl,oaNoticeDaoImpl,oaNotebookDaoImpl,oaNetmailUidDaoImpl,oaNetmailSetDaoImpl,oaNetmailSendboxDaoImpl,oaNetmailPersonDaoImpl,oaNetmailInboxDaoImpl,oaNetdiskShareDaoImpl,oaNetdiskConfigDaoImpl,oaMeetapplyDaoImpl,oaMailSendDaoImpl,oaMailInboxDaoImpl,oaMailEmpDaoImpl,oaLeaveregistrationDaoImpl,oaJournalsTypeDaoImpl,oaJournalsDaoImpl,oaForumsDaoImpl,oaFormsDaoImpl,oaDesktopSetDaoImpl,oaChattersDaoImpl,oaChatGroupsDaoImpl,oaCarUseDaoImpl,oaCarMaintenDaoImpl,oaCarMaintainDaoImpl,oaCarDaoImpl,oaCarApplyDaoImpl,oaCalenderDaoImpl,oaBookTypeDaoImpl,oaBookDaoImpl,oaBookBrDaoImpl,oaBoardroomDaoImpl,oaAnnouncementDaoImpl,oaAlbumDaoImpl,oaAdversariaDaoImpl,hrmWorkareaDaoImpl,hrmTimedrecordDaoImpl,hrmPostDaoImpl,hrmEmployeeDaoImpl,hrmDepartmentDaoImpl,hrmContractTypeDaoImpl,hrmContractDaoImpl,applicationContextHelper,wordExport,excelExport,fileHelper,fileService,fileAction,dbDesignAction,codeAction,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,propertyConfigurer,proxoolDataSource,sessionFactory,jdbcTemplate,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,processEngineConfiguration,processEngine,repositoryService,runtimeService,formService,identityService,taskService,historyService,managementService,postTaskListener,leaveFinishProcessor,__dwrConfiguration,__dwrHrmEmployeeService,dwrHrmEmployeeService,__dwrHrmContractService,dwrHrmContractService,__dwrSysProcessService,dwrSysProcessService,__dwrCommonService,dwrCommonService,__dwrWorkArrangeService,dwrWorkArrangeService,__dwrOACompanyResourcesService,dwrOACompanyResourcesService,__dwrOaNewsService,dwrOaNewsService,__dwrOfficeResourcesService,dwrOfficeResourcesService,__dwrOaCommunicationService,dwrOaCommunicationService,__dwrMoblieSmsService,dwrMoblieSmsService,__dwrMailService,dwrMailService,__dwrApproveProcessService,dwrApproveProcessService,__dwrPersonalOfficeService,dwrPersonalOfficeService,__dwrPersonalProcessService,dwrPersonalProcessService,__dwrOADesktopService,dwrOADesktopService,__dwrNetdiskService,dwrNetdiskService,simpleAdvice,exceptionCatcherAdvice,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy 2016-04-22 15:29:30 INFO - Closing Hibernate SessionFactory 2016-04-22 15:29:30 INFO - closing 2016-04-22 15:29:30 ERROR - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291) 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.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sq.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.(ProcessEngineImpl.java:74) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:397) at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:66) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 41 more Caused by: java.sql.SQLException: Could not retrieve transation read-only status server at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3936) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3907) at com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1258) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1278) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.Statement$$EnhancerByProxool$$83a61b5c.execute() at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ... 60 more Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3930) ... 78 more l.SQLException: Could not retrieve transation read-only status server at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:353) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1015) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:443) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:417) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:559) at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304) ... 22 more Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62) at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:446) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:982) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1363) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.(ProcessEngineImpl.java:74) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:397) at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:66) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 41 more Caused by: java.sql.SQLException: Could not retrieve transation read-only status server at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3936) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3907) at com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1258) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1278) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.Statement$$EnhancerByProxool$$83a61b5c.execute() at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ... 60 more Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3930) ... 78 more 2016-04-22 15:29:30 INFO - =======初始化ERP系统(InitErp)================== 2016-04-22 15:29:30 INFO - 系统参数 2016-04-22 15:29:30 INFO - java.vendor =[ Oracle Corporation ] 2016-04-22 15:29:30 INFO - sun.java.launcher =[ SUN_STANDARD ] 2016-04-22 15:29:30 INFO - catalina.base =[ G:\workspace\bams\target\tomcat ] 2016-04-22 15:29:30 INFO - sun.management.compiler =[ HotSpot Client Compiler ] 2016-04-22 15:29:30 INFO - catalina.useNaming =[ true ] 2016-04-22 15:29:30 INFO - os.name =[ Windows 7 ] 2016-04-22 15:29:30 INFO - sun.boot.class.path =[ C:\Program Files\Java\jdk1.7.0_79\jre\lib\resources.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\rt.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\jce.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.7.0_79\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.7.0_79\jre\classes ] 2016-04-22 15:29:30 INFO - java.util.logging.config.file =[ G:\workspace\bams\target\tomcat\conf\logging.properties ] 2016-04-22 15:29:30 INFO - sun.desktop =[ windows ] 2016-04-22 15:29:30 INFO - java.vm.specification.vendor =[ Oracle Corporation ] 2016-04-22 15:29:30 INFO - java.runtime.version =[ 1.7.0_79-b15 ] 2016-04-22 15:29:30 INFO - user.name =[ GW3301492 ] 2016-04-22 15:29:30 INFO - shared.loader =[ ] 2016-04-22 15:29:30 INFO - guice.disable.misplaced.annotation.check =[ true ] 2016-04-22 15:29:30 INFO - tomcat.util.buf.StringCache.byte.enabled =[ true ] 2016-04-22 15:29:30 INFO - bams =[ G:\workspace\bams\src\main\webapp\ ] 2016-04-22 15:29:30 INFO - java.naming.factory.initial =[ org.apache.naming.java.javaURLContextFactory ] 2016-04-22 15:29:30 INFO - user.language =[ zh ] 2016-04-22 15:29:30 INFO - sun.boot.library.path =[ C:\Program Files\Java\jdk1.7.0_79\jre\bin ] 2016-04-22 15:29:30 INFO - classworlds.conf =[ G:\workspace\.metadata\.plugins\org.eclipse.m2e.launching\launches\m2conf1457407975265594775.tmp ] 2016-04-22 15:29:30 INFO - java.version =[ 1.7.0_79 ] 2016-04-22 15:29:30 INFO - java.util.logging.manager =[ org.apache.juli.ClassLoaderLogManager ] 2016-04-22 15:29:30 INFO - user.timezone =[ Asia/Shanghai ] 2016-04-22 15:29:30 INFO - sun.arch.data.model =[ 32 ] 2016-04-22 15:29:30 INFO - java.endorsed.dirs =[ C:\Program Files\Java\jdk1.7.0_79\jre\lib\endorsed ] 2016-04-22 15:29:30 INFO - sun.cpu.isalist =[ pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 ] 2016-04-22 15:29:30 INFO - sun.jnu.encoding =[ GBK ] 2016-04-22 15:29:30 INFO - file.encoding.pkg =[ sun.io ] 2016-04-22 15:29:30 INFO - package.access =[ sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper. ] 2016-04-22 15:29:30 INFO - file.separator =[ \ ] 2016-04-22 15:29:30 INFO - java.specification.name =[ Java Platform API Specification ] 2016-04-22 15:29:30 INFO - java.class.version =[ 51.0 ] 2016-04-22 15:29:30 INFO - org.slf4j.simpleLogger.defaultLogLevel =[ info ] 2016-04-22 15:29:30 INFO - user.country =[ CN ] 2016-04-22 15:29:30 INFO - java.home =[ C:\Program Files\Java\jdk1.7.0_79\jre ] 2016-04-22 15:29:30 INFO - java.vm.info =[ mixed mode, sharing ] 2016-04-22 15:29:30 INFO - os.version =[ 6.1 ] 2016-04-22 15:29:30 INFO - path.separator =[ ; ] 2016-04-22 15:29:30 INFO - java.vm.version =[ 24.79-b02 ] 2016-04-22 15:29:30 INFO - user.variant =[ ] 2016-04-22 15:29:30 INFO - java.awt.printerjob =[ sun.awt.windows.WPrinterJob ] 2016-04-22 15:29:30 INFO - sun.io.unicode.encoding =[ UnicodeLittle ] 2016-04-22 15:29:30 INFO - tomcat.util.scan.DefaultJarScanner.jarsToSkip =[ bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-*.jar,tomcat-api.jar,tomcat-util.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,commons-beanutils*.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,access-bridge.jar,access-bridge-64.jar,dnsns.jar,jaccess.jar,ldapsec.jar,localedata.jar,sunjce_provider.jar,sunmscapi.jar,sunpkcs11.jar,jhall.jar,tools.jar,sunec.jar,zipfs.jar,gnome-java-bridge.jar,pulse-java.jar,apple_provider.jar,AppleScriptEngine.jar,CoreAudio.jar,dns_sd.jar,j3daudio.jar,j3dcore.jar,j3dutils.jar,jai_core.jar,jai_codec.jar,mlibwrapper_jai.jar,MRJToolkit.jar,vecmath.jar,junit.jar,junit-*.jar,ant-launcher.jar ] 2016-04-22 15:29:30 INFO - awt.toolkit =[ sun.awt.windows.WToolkit ] 2016-04-22 15:29:30 INFO - package.definition =[ sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper. ] 2016-04-22 15:29:30 INFO - user.script =[ ] 2016-04-22 15:29:30 INFO - java.naming.factory.url.pkgs =[ org.apache.naming ] 2016-04-22 15:29:30 INFO - user.home =[ C:\Users\GW3301492 ] 2016-04-22 15:29:30 INFO - org.apache.catalina.startup.ContextConfig.jarsToSkip =[ ] 2016-04-22 15:29:30 INFO - java.specification.vendor =[ Oracle Corporation ] 2016-04-22 15:29:30 INFO - java.library.path =[ C:\Program Files\Java\jdk1.7.0_79\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Windows7Master;C:\Program Files\Java\jdk1.7.0_79\bin;C:\Program Files\Java\jdk1.7.0_79\jre\bin;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;D:\cloud_cms\apache-maven-3.3.9\bin;D:\Program Files\luna\eclipse;;. ] 2016-04-22 15:29:30 INFO - java.vendor.url =[ http://java.oracle.com/ ] 2016-04-22 15:29:30 INFO - org.apache.catalina.startup.TldConfig.jarsToSkip =[ ] 2016-04-22 15:29:30 INFO - java.vm.vendor =[ Oracle Corporation ] 2016-04-22 15:29:30 INFO - common.loader =[ ${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar ] 2016-04-22 15:29:30 INFO - maven.home =[ G:\workspace\bams\EMBEDDED ] 2016-04-22 15:29:30 INFO - java.runtime.name =[ Java(TM) SE Runtime Environment ] 2016-04-22 15:29:30 INFO - sun.java.command =[ org.codehaus.plexus.classworlds.launcher.Launcher -B -s D:\cloud_cms\apache-maven-3.3.9\conf\settings.xml tomcat7:run ] 2016-04-22 15:29:30 INFO - java.class.path =[ /D:/Program Files/luna/eclipse/plugins/org.eclipse.m2e.maven.runtime_1.5.1.20150109-1819/jars/plexus-classworlds-2.5.1.jar ] 2016-04-22 15:29:30 INFO - java.vm.specification.name =[ Java Virtual Machine Specification ] 2016-04-22 15:29:30 INFO - java.vm.specification.version =[ 1.7 ] 2016-04-22 15:29:30 INFO - catalina.home =[ G:\workspace\bams\target\tomcat ] 2016-04-22 15:29:30 INFO - sun.cpu.endian =[ little ] 2016-04-22 15:29:30 INFO - sun.os.patch.level =[ Service Pack 1 ] 2016-04-22 15:29:30 INFO - java.io.tmpdir =[ C:\Users\GW3301~1\AppData\Local\Temp\ ] 2016-04-22 15:29:30 INFO - java.vendor.url.bug =[ http://bugreport.sun.com/bugreport/ ] 2016-04-22 15:29:30 INFO - server.loader =[ ] 2016-04-22 15:29:30 INFO - os.arch =[ x86 ] 2016-04-22 15:29:30 INFO - java.awt.graphicsenv =[ sun.awt.Win32GraphicsEnvironment ] 2016-04-22 15:29:30 INFO - java.ext.dirs =[ C:\Program Files\Java\jdk1.7.0_79\jre\lib\ext;C:\Windows\Sun\Java\lib\ext ] 2016-04-22 15:29:30 INFO - user.dir =[ G:\workspace\bams ] 2016-04-22 15:29:30 INFO - line.separator =[ ] 2016-04-22 15:29:30 INFO - java.vm.name =[ Java HotSpot(TM) Client VM ] 2016-04-22 15:29:30 INFO - file.encoding =[ GBK ] 2016-04-22 15:29:30 INFO - java.specification.version =[ 1.7 ] 2016-04-22 15:29:30 INFO - 系统初始化开始 2016-04-22 15:29:30 INFO - 加载配置文件...... org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291) 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.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:353) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1015) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:443) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:417) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:559) at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304) ... 22 more Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62) at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:446) at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:982) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1363) at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.ProcessEngineImpl.(ProcessEngineImpl.java:74) at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:397) at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:66) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56) at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 41 more Caused by: java.sql.SQLException: Could not retrieve transation read-only status server at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3936) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3907) at com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1258) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1278) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.Statement$$EnhancerByProxool$$83a61b5c.execute() at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ... 60 more Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612) at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3930) ... 78 more 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.StandardContext startInternal 严重: Error listenerStart 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.StandardContext startInternal 严重: Context [/bams] startup failed due to previous errors 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.ApplicationContext log 信息: Closing Spring root WebApplicationContext 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.ApplicationContext log 信息: Shutting down log4j 2016-04-22 15:29:30 INFO - erp配置文件绑定完成.. 2016-04-22 15:29:30 INFO - 加载功能菜单模块.... 2016-04-22 15:29:30 ERROR - [init system error]:Error creating bean with name 'processAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server 2016-04-22 15:29:30 INFO - [success]Project init has been finished... 2016-04-22 15:29:30 INFO - 系统被关闭。。。 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc 严重: The web application [/bams] 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. 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [/bams] appears to have started a thread named [FileWatchdog] but has failed to stop it. This is very likely to create a memory leak. 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [/bams] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [/bams] appears to have started a thread named [HouseKeeper] but has failed to stop it. This is very likely to create a memory leak. 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [/bams] appears to have started a thread named [Prototyper] but has failed to stop it. This is very likely to create a memory leak. 四月 22, 2016 3:29:30 下午 org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks 严重: The web application [/bams] created a ThreadLocal with key of type [org.springframework.core.NamedThreadLocal] (value [Transactional resources]) and a value of type [java.util.HashMap] (value [{org.hibernate.impl.SessionFactoryImpl@19fb0c4=org.springframework.orm.hibernate3.SessionHolder@15006c9, org.logicalcobwebs.proxool.ProxoolDataSource@2afdba=org.springframework.jdbc.datasource.ConnectionHolder@ed8d5c}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. 四月 22, 2016 3:29:30 下午 org.apache.coyote.AbstractProtocol start 信息: Starting ProtocolHandler ["http-bio-8080"] |
|
---|---|
|
发表于:2016-04-22 15:35:35
IP:221.235.*.*
出错从这开始的
2016-04-22 15:29:27 INFO - building session factory 2016-04-22 15:29:28 INFO - Not binding factory to JNDI, no JNDI name configured 2016-04-22 15:29:28 INFO - Using DataSource [org.logicalcobwebs.proxool.ProxoolDataSource@2afdba] of Hibernate SessionFactory for HibernateTransactionManager 四月 22, 2016 3:29:30 下午 org.apache.catalina.core.StandardContext listenerStart 严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: Could not retrieve transation read-only status server ### The error may exist in org/activiti/db/mapping/entity/Property.xml ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLException: Could not retrieve transation read-only status server at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) |
|
---|---|
发表于:2016-04-22 21:52:27
IP:112.139.*.*
MYSQL6.0,没测试过。
看错误信息,应该是activity引擎出了问题,你可以去activity的官网看看有没有mysql6.0的升级脚本。 |
|
---|---|
发表于:2016-04-23 09:38:44
IP:221.235.*.*
回复第3楼谢谢 这几个都是刚刚学啊 现在正在把MYSQL换成5.5的 先跑起来学习一下 等了解了再去钻6.0的问题 现在也只能先降级数据库的版本了
|
|
---|---|
发表于:2016-04-28 13:14:20
IP:222.150.*.*
回复第3楼
可能不是数据库版本的问题, 因为我现在的数据库是5.5.49版本的 |
|
---|---|