主题 :为何我本机的MYSQL5.0可以连接服务器的MYSQL6.0就不能连接呢
级别:应届生
积分:30
关注  私信
精华:0  主题:2  回复:10
注册时间:2016-04-07
在线时长:0 min
  发表于:2016-04-22 15:33:37  IP:221.235.*.*
1#
折腾了很久,还是一堆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"]
引用     回复     举报 
级别:应届生
积分:30
关注  私信
精华:0  主题:2  回复:10
注册时间:2016-04-07
在线时长:0 min
  发表于:2016-04-22 15:35:35  IP:221.235.*.*
2#
出错从这开始的


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)
引用     回复     举报 
级别:版主
积分:572
关注  私信
精华:3  主题:57  回复:95
注册时间:2015-03-03
在线时长:578.17 h
  发表于:2016-04-22 21:52:27  IP:112.139.*.*
3#
MYSQL6.0,没测试过。
看错误信息,应该是activity引擎出了问题,你可以去activity的官网看看有没有mysql6.0的升级脚本。
引用     回复     举报 
级别:应届生
积分:30
关注  私信
精华:0  主题:2  回复:10
注册时间:2016-04-07
在线时长:0 min
  发表于:2016-04-23 09:38:44  IP:221.235.*.*
4#
回复第3楼谢谢  这几个都是刚刚学啊 现在正在把MYSQL换成5.5的 先跑起来学习一下 等了解了再去钻6.0的问题 现在也只能先降级数据库的版本了
引用     回复     举报 
级别:应届生
积分:30
关注  私信
精华:0  主题:2  回复:10
注册时间:2016-04-07
在线时长:0 min
  发表于:2016-04-28 13:14:20  IP:222.150.*.*
5#
回复第3楼
可能不是数据库版本的问题, 因为我现在的数据库是5.5.49版本的
引用     回复     举报 
级别:应届生
积分:30
关注  私信
精华:0  主题:2  回复:10
注册时间:2016-04-07
在线时长:0 min
  发表于:2016-04-28 13:15:24  IP:222.150.*.*
6#
回复第3楼
哦 看错了 6.0的连接不上 就是数据库的版本问题 换成5.5就可以正常连接
引用     回复     举报