Bonjour,
Quelqu’un pour me dire les étapes à suivre pour configurer bonita pour utiliser My SQL ?
Merci d’avance.
Bonjour,
Il me semble que c’est tout expliqué dans la doc :
http://documentation.bonitasoft.com/database-configuration-0#mysqlspec
Je n’ai pas testé mais il y a surement toutes les infos.
Re bonjour,
J’ai essayé étape par étape mais ça marche pas quand je lance Tomcat voila ce que j’ai sur mon fichier catalina :
Infos: Loading XML bean definitions from file [C:\BonitaBPMCommunity-6.2.5\workspace\tomcat\bonita\server\platform\conf\services\platform-cfg.xml]
juil. 15, 2014 9:37:11 AM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
Infos: Loading properties file from file [C:\BonitaBPMCommunity-6.2.5\workspace\tomcat\bonita\server\platform\conf\bonita-platform.properties]
juil. 15, 2014 9:37:11 AM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
Infos: Loading properties file from file [C:\BonitaBPMCommunity-6.2.5\workspace\tomcat\bonita\server\platform\conf\jdbc-h2.xml]
juil. 15, 2014 9:37:11 AM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
Infos: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@60c02319: defining beans [hbm-bos-actor-mapping,actorMappingService,db-bos-actor-mapping,archivingStrategy,archiveService,definitiveArchiveDescriptor,cacheConfigurations,connectorCacheConfig,processDefCacheConfig,userFilterCacheConfig,migrationPlanCacheConfig,breakpointCacheConfig,groovyScriptCacheConfig,synchroServiceCacheConfig,transientDataCacheConfig,platformCacheConfig,cacheService,platformCacheService,db-bos-category-model,hbm-bos-category-model,parentClassLoaderResolver,classLoaderService,db-bos-command-model,hbm-bos-command-model,hbm-bos-data-instance-model,hbm-bos-data-instance-model-arch,db-bos-data-instance-model,db-bos-data-instance-model-arch,hbm-bonita-data-model,db-bonita-data-model,deleteService,dependencyService,hbm-bonita-dependency-model,db-bonita-dependency-model,platformDependencyService,hbm-bonita-dependency-platform-model,db-bonita-dependency-platform-model,hbm-bonita-document-model,documentService,db-bonita-document-model,jndiTemplate,bonitaSequenceManagerDSJNDI,eventService,hbm-bos-external-identity-mapping,externalIdentityMappingService,db-bos-external-identity-mapping,identityService,hbm-bonita-identity-model,db-bonita-identity-model,incidentService,lockService,queriableLoggerStrategy,syncQueriableLoggerService,hbm-bonita-log-model,db-bonita-log,technicalLoggerService,nodeConfiguration,schedulerServiceRestartHandler,dbConfigurationsProvider,sequencecripts,platformPersistenceService,persistenceService,journalConfigurationProvider,hbmResourcesConfigurationProvider,platformService,platformAuthenticationService,platformCommandService,hbm-bos-platform-command-model,db-bos-platform-command-model,platformLoginService,hbm-bonita-platform-model,platformProperties,db-bonita-platform-model,platformSessionService,platformSessionProvider,commentService,hbm-bos-process-comment-model,hbm-bos-process-comment-model-arch,db-bos-process-comment-model,db-bos-process-comment-model-arch,hbm-bonita-process-definition-model,db-bonita-process-definition-model,processDocumentService,documentURLProvider,documentMappingService,hbm-bos-process-document-mapping-model,hbm-bos-process-document-mapping-model-arch,db-bos-process-document-mapping-model,db-bos-process-document-mapping-model-arch,hbm-bonita-process-instance-model,hbm-bonita-process-instance-model-arch,db-bonita-process-instance-model,db-bonita-process-instance-model-arch,hbm-bos-profile-model,db-bos-profile-model,db-bonita-reporting-model,hbm-bonita-scheduler,quartzSchedulerFactory,quartzProperties,loggerJobListener,jdbcJobListener,schedulerExecutor,jobService,scheduler,db-bonita-scheduler-quartz,db-bonita-scheduler,sequenceManager,sessionService,sessionProvider,hbm-bos-supervisor-mapping,supervisorMappingService,db-bos-supervisor-mapping,synchroService,hbm-bos-theme-model,db-bos-theme-model,transactionManager,transactionService,bonitaExecutorServiceFactory,workService,dbProperties,queriableLogSessionProvider,recorderSync,parserFactory,xmlValidatorFactory,xmlValidator,xmlWriter,transactionExecutor,servicesToStart]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory@1984db9e
juil. 15, 2014 9:37:27 AM org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory
Avertissement: Scoping types to session factory org.hibernate.impl.SessionFactoryImpl@37470c35 after already scoped org.hibernate.impl.SessionFactoryImpl@197287ed
juil. 15, 2014 9:37:33 AM net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
Avertissement: Cache ‘null’ is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache ‘null’ will be eternal=‘true’, timeToIdleSeconds=‘0’, timeToLiveSeconds=‘0’.
juil. 15, 2014 9:37:33 AM net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
Avertissement: Cache ‘null’ is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache ‘null’ will be eternal=‘true’, timeToIdleSeconds=‘0’, timeToLiveSeconds=‘0’.
juil. 15, 2014 9:37:34 AM net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
Avertissement: Cache ‘null’ is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache ‘null’ will be eternal=‘true’, timeToIdleSeconds=‘0’, timeToLiveSeconds=‘0’.
juil. 15, 2014 9:37:34 AM net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
Avertissement: Cache ‘null’ is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache ‘null’ will be eternal=‘true’, timeToIdleSeconds=‘0’, timeToLiveSeconds=‘0’.
juil. 15, 2014 9:37:39 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Avertissement: SQL Error: 1146, SQLState: 42S02
juil. 15, 2014 9:37:39 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Grave: Table ‘bonita.platform’ doesn’t exist
juil. 15, 2014 9:37:39 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Avertissement: SQL Error: 1146, SQLState: 42S02
juil. 15, 2014 9:37:39 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Grave: Table ‘bonita.platform’ doesn’t exist
juil. 15, 2014 9:37:40 AM org.apache.catalina.startup.HostConfig deployDescriptor
Infos: Déploiement du descripteur de configuration host-manager.xml
juil. 15, 2014 9:37:40 AM org.apache.catalina.startup.HostConfig deployDescriptor
Infos: Déploiement du descripteur de configuration manager.xml
juil. 15, 2014 9:37:41 AM org.apache.catalina.startup.HostConfig deployWAR
Infos: Déploiement de l’archive studio-watchdog-6.0.1.war de l’application web
juil. 15, 2014 9:37:41 AM org.apache.catalina.startup.HostConfig deployDirectory
Infos: Déploiement du répertoire docs de l’application web
juil. 15, 2014 9:37:41 AM org.apache.coyote.http11.Http11Protocol start
Infos: Démarrage de Coyote HTTP/1.1 sur http-8081
juil. 15, 2014 9:37:41 AM org.apache.jk.common.ChannelSocket init
Infos: JK: ajp13 listening on /0.0.0.0:8010
juil. 15, 2014 9:37:41 AM org.apache.jk.server.JkMain start
Infos: Jk running ID=0 time=1/42 config=null
juil. 15, 2014 9:37:41 AM org.apache.catalina.startup.Catalina start
Infos: Server startup in 43433 ms
juil. 15, 2014 9:37:42 AM org.apache.coyote.http11.Http11Protocol pause
Infos: Suspension de Coyote HTTP/1.1 sur http-8081
juil. 15, 2014 9:37:43 AM org.apache.catalina.core.StandardService stop
Infos: Arrêt du service Catalina
juil. 15, 2014 9:37:43 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
Grave: The web application [/studio-watchdog-6.0.1] appears to have started a thread named [Thread-5] but has failed to stop it. This is very likely to create a memory leak.
juil. 15, 2014 9:37:43 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Avertissement: SQL Error: 1146, SQLState: 42S02
juil. 15, 2014 9:37:43 AM org.hibernate.util.JDBCExceptionReporter logExceptions
Grave: Table ‘bonita.platform’ doesn’t exist
juil. 15, 2014 9:37:43 AM org.springframework.beans.factory.support.DefaultSingletonBeanRegistry destroySingletons
Infos: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@60c02319: defining beans [hbm-bos-actor-mapping,actorMappingService,db-bos-actor-mapping,archivingStrategy,archiveService,definitiveArchiveDescriptor,cacheConfigurations,connectorCacheConfig,processDefCacheConfig,userFilterCacheConfig,migrationPlanCacheConfig,breakpointCacheConfig,groovyScriptCacheConfig,synchroServiceCacheConfig,transientDataCacheConfig,platformCacheConfig,cacheService,platformCacheService,db-bos-category-model,hbm-bos-category-model,parentClassLoaderResolver,classLoaderService,db-bos-command-model,hbm-bos-command-model,hbm-bos-data-instance-model,hbm-bos-data-instance-model-arch,db-bos-data-instance-model,db-bos-data-instance-model-arch,hbm-bonita-data-model,db-bonita-data-model,deleteService,dependencyService,hbm-bonita-dependency-model,db-bonita-dependency-model,platformDependencyService,hbm-bonita-dependency-platform-model,db-bonita-dependency-platform-model,hbm-bonita-document-model,documentService,db-bonita-document-model,jndiTemplate,bonitaSequenceManagerDSJNDI,eventService,hbm-bos-external-identity-mapping,externalIdentityMappingService,db-bos-external-identity-mapping,identityService,hbm-bonita-identity-model,db-bonita-identity-model,incidentService,lockService,queriableLoggerStrategy,syncQueriableLoggerService,hbm-bonita-log-model,db-bonita-log,technicalLoggerService,nodeConfiguration,schedulerServiceRestartHandler,dbConfigurationsProvider,sequencecripts,platformPersistenceService,persistenceService,journalConfigurationProvider,hbmResourcesConfigurationProvider,platformService,platformAuthenticationService,platformCommandService,hbm-bos-platform-command-model,db-bos-platform-command-model,platformLoginService,hbm-bonita-platform-model,platformProperties,db-bonita-platform-model,platformSessionService,platformSessionProvider,commentService,hbm-bos-process-comment-model,hbm-bos-process-comment-model-arch,db-bos-process-comment-model,db-bos-process-comment-model-arch,hbm-bonita-process-definition-model,db-bonita-process-definition-model,processDocumentService,documentURLProvider,documentMappingService,hbm-bos-process-document-mapping-model,hbm-bos-process-document-mapping-model-arch,db-bos-process-document-mapping-model,db-bos-process-document-mapping-model-arch,hbm-bonita-process-instance-model,hbm-bonita-process-instance-model-arch,db-bonita-process-instance-model,db-bonita-process-instance-model-arch,hbm-bos-profile-model,db-bos-profile-model,db-bonita-reporting-model,hbm-bonita-scheduler,quartzSchedulerFactory,quartzProperties,loggerJobListener,jdbcJobListener,schedulerExecutor,jobService,scheduler,db-bonita-scheduler-quartz,db-bonita-scheduler,sequenceManager,sessionService,sessionProvider,hbm-bos-supervisor-mapping,supervisorMappingService,db-bos-supervisor-mapping,synchroService,hbm-bos-theme-model,db-bos-theme-model,transactionManager,transactionService,bonitaExecutorServiceFactory,workService,dbProperties,queriableLogSessionProvider,recorderSync,parserFactory,xmlValidatorFactory,xmlValidator,xmlWriter,transactionExecutor,servicesToStart]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory@1984db9e
juil. 15, 2014 9:37:43 AM org.springframework.beans.factory.support.DefaultSingletonBeanRegistry destroySingletons
Infos: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1984db9e: defining beans [sessionAccessor]; root of factory hierarchy
juil. 15, 2014 9:37:45 AM org.apache.coyote.http11.Http11Protocol destroy
Infos: Arrêt de Coyote HTTP/1.1 sur http-8081
juil. 15, 2014 9:37:45 AM bitronix.tm.integration.tomcat55.BTMLifecycleListener lifecycleEvent
Infos: Shutting down Bitronix Transaction Manager
juil. 15, 2014 9:37:45 AM bitronix.tm.BitronixTransactionManager shutdown
Infos: shutting down Bitronix Transaction Manager
Besoin d’une réponse svp
Oui merci je l’ai vu et je suis entrain de tester.