Bonita 5.3 + Jboss 5.1.0.GA - Exception: Cannot open connection

Transmit's picture
Post submitted by Transmit Mon, 11/29/2010 - 11:32

Hi all.



We have setup Bonita 5.3 in a Jboss 5.1.0.GA with MySQL as RDBMS.



The setup of hibernate and the datasources are as followed:



in conf directory: hibernate-core.properties:

  1. <br>
  2. hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect<br>
  3. hibernate.connection.datasource bonitaCoreDS<br>
  4. hibernate.cache.use_second_level_cache false<br>
  5. hibernate.cache.use_query_cache false<br>
  6. hibernate.cache.region.factory_class net.sf.ehcache.hibernate.EhCacheRegionFactory<br>
  7. hibernate.show_sql false<br>
  8. hibernate.format_sql false<br>
  9. hibernate.use_sql_comments false<br>
  10. bonita.search.use true<br>





hibernate-history.properties: same as hibernate-core.properties except hibernate.connection.datasource -> bonitaHistoryDS





in deploy directory: bonita-ds.xml

  1. <br>
  2. <datasources><br>
  3. <local-tx-datasource><br>
  4. <jndi-name>bonitaCoreDS</jndi-name><br>
  5. <use-java-context>false</use-java-context><br>
  6. <connection-url>jdbc:mysql://127.0.0.1:3306/bonita_core</connection-url><br>
  7. <driver-class>com.mysql.jdbc.Driver</driver-class><br>
  8. <user-name>***</user-name><br>
  9. <password>***</password><br>
  10. </local-tx-datasource><br>
  11. <local-tx-datasource><br>
  12. <jndi-name>bonitaHistoryDS</jndi-name><br>
  13. <use-java-context>false</use-java-context><br>
  14. <connection-url>jdbc:mysql://127.0.0.1:3306/bonita_history</connection-url><br>
  15. <driver-class>com.mysql.jdbc.Driver</driver-class><br>
  16. <user-name>***</user-name><br>
  17. <password>***</password><br>
  18. </local-tx-datasource><br>
  19. </datasources><br>
  20. <br>





The following exception occurs when logging in to UserXP:

From server.log:


  1. <br>
  2. 2010-11-29 11:08:05,203 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 32s:499ms<br>
  3. 2010-11-29 11:08:32,243 INFO [org.ow2.bonita.util.AccessorUtil] (ajp-0.0.0.0-8009-1) API-Type: EJB3 has been specified through property: org.ow2.bonita.api-type<br>
  4. 2010-11-29 11:08:32,512 WARN [org.jboss.ejb3.interceptors.aop.InterceptorsFactory] (ajp-0.0.0.0-8009-1) EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container<br>
  5. 2010-11-29 11:08:32,514 WARN [org.jboss.ejb3.interceptors.aop.InterceptorsFactory] (ajp-0.0.0.0-8009-1) EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container<br>
  6. 2010-11-29 11:08:32,621 INFO [org.ow2.bonita.env.BonitaEnvironmentParser] (ajp-0.0.0.0-8009-1) parsing bindings from resource url: vfszip:/opt/jboss-5.1.0.GA/server/default/deploy/bonita.ear/bonita-ejbjar.jar/bonita.wire.bindings.xml<br>
  7. 2010-11-29 11:08:32,750 ERROR [STDERR] (ajp-0.0.0.0-8009-1) SLF4J: Class path contains multiple SLF4J bindings.<br>
  8. 2010-11-29 11:08:32,751 ERROR [STDERR] (ajp-0.0.0.0-8009-1) SLF4J: Found binding in [vfszip:/opt/jboss-5.1.0.GA/server/default/deploy/bonita.ear/lib/slf4j-jdk14-1.6.1.jar/org/slf4j/impl/StaticLoggerBinder.class]<br>
  9. 2010-11-29 11:08:32,751 ERROR [STDERR] (ajp-0.0.0.0-8009-1) SLF4J: Found binding in [vfszip:/opt/jboss-5.1.0.GA/common/lib/slf4j-jboss-logging.jar/org/slf4j/impl/StaticLoggerBinder.class]<br>
  10. 2010-11-29 11:08:32,751 ERROR [STDERR] (ajp-0.0.0.0-8009-1) SLF4J: Found binding in [vfszip:/opt/jboss-5.1.0.GA/server/default/lib/slf4j-jdk14-1.6.1.jar/org/slf4j/impl/StaticLoggerBinder.class]<br>
  11. 2010-11-29 11:08:32,751 ERROR [STDERR] (ajp-0.0.0.0-8009-1) SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.<br>
  12. 2010-11-29 11:08:32,774 INFO [org.hibernate.cfg.Environment] (ajp-0.0.0.0-8009-1) Hibernate 3.5.6-Final<br>
  13. 2010-11-29 11:08:32,778 INFO [org.hibernate.cfg.Environment] (ajp-0.0.0.0-8009-1) hibernate.properties not found<br>
  14. 2010-11-29 11:08:32,782 INFO [org.hibernate.cfg.Environment] (ajp-0.0.0.0-8009-1) Bytecode provider name : javassist<br>
  15. 2010-11-29 11:08:32,786 INFO [org.hibernate.cfg.Environment] (ajp-0.0.0.0-8009-1) using JDK 1.4 java.sql.Timestamp handling<br>
  16. 2010-11-29 11:08:32,872 INFO [org.hibernate.cfg.Configuration] (ajp-0.0.0.0-8009-1) Reading mappings from resource: bonita.definition.hbm.xml<br>
  17. <br>
  18. --- many, many Mapping messages ---<br>
  19. <br>
  20. 2010-11-29 11:08:33,592 INFO [org.hibernate.util.NamingHelper] (ajp-0.0.0.0-8009-1) JNDI InitialContext properties:{}<br>
  21. 2010-11-29 11:08:33,599 INFO [org.hibernate.connection.DatasourceConnectionProvider] (ajp-0.0.0.0-8009-1) Using datasource: bonitaCoreDS<br>
  22. 2010-11-29 11:08:33,778 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) RDBMS: MySQL, version: 5.0.51a-24+lenny4<br>
  23. 2010-11-29 11:08:33,778 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )<br>
  24. 2010-11-29 11:08:33,801 INFO [org.hibernate.dialect.Dialect] (ajp-0.0.0.0-8009-1) Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<br>
  25. 2010-11-29 11:08:33,805 INFO [org.hibernate.engine.jdbc.JdbcSupportLoader] (ajp-0.0.0.0-8009-1) Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4<br>
  26. 2010-11-29 11:08:33,807 INFO [org.hibernate.transaction.TransactionFactoryFactory] (ajp-0.0.0.0-8009-1) Using default transaction strategy (direct JDBC transactions)<br>
  27. 2010-11-29 11:08:33,809 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] (ajp-0.0.0.0-8009-1) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)<br>
  28. 2010-11-29 11:08:33,809 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Automatic flush during beforeCompletion(): disabled<br>
  29. 2010-11-29 11:08:33,810 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Automatic session close at end of transaction: disabled<br>
  30. 2010-11-29 11:08:33,810 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JDBC batch size: 15<br>
  31. 2010-11-29 11:08:33,810 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JDBC batch updates for versioned data: disabled<br>
  32. 2010-11-29 11:08:33,811 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Scrollable result sets: enabled<br>
  33. 2010-11-29 11:08:33,811 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JDBC3 getGeneratedKeys(): enabled<br>
  34. 2010-11-29 11:08:33,812 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Connection release mode: auto<br>
  35. 2010-11-29 11:08:33,813 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Maximum outer join fetch depth: 2<br>
  36. 2010-11-29 11:08:33,813 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Default batch fetch size: 1<br>
  37. 2010-11-29 11:08:33,813 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Generate SQL with comments: disabled<br>
  38. 2010-11-29 11:08:33,814 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Order SQL updates by primary key: disabled<br>
  39. 2010-11-29 11:08:33,814 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Order SQL inserts for batching: disabled<br>
  40. 2010-11-29 11:08:33,814 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory<br>
  41. 2010-11-29 11:08:33,816 INFO [org.hibernate.hql.ast.ASTQueryTranslatorFactory] (ajp-0.0.0.0-8009-1) Using ASTQueryTranslatorFactory<br>
  42. 2010-11-29 11:08:33,817 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query language substitutions: {}<br>
  43. 2010-11-29 11:08:33,817 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JPA-QL strict compliance: disabled<br>
  44. 2010-11-29 11:08:33,817 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Second-level cache: disabled<br>
  45. 2010-11-29 11:08:33,818 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query cache: disabled<br>
  46. 2010-11-29 11:08:33,818 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Cache region factory : net.sf.ehcache.hibernate.EhCacheRegionFactory<br>
  47. 2010-11-29 11:08:33,824 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Optimize cache for minimal puts: enabled<br>
  48. 2010-11-29 11:08:33,825 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Structured second-level cache entries: disabled<br>
  49. 2010-11-29 11:08:33,829 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Statistics: disabled<br>
  50. 2010-11-29 11:08:33,830 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Deleted entity synthetic identifier rollback: disabled<br>
  51. 2010-11-29 11:08:33,830 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Default entity-mode: pojo<br>
  52. 2010-11-29 11:08:33,830 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Named query checking : enabled<br>
  53. 2010-11-29 11:08:33,831 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Check Nullability in Core (should be disabled when Bean Validation is on): enabled<br>
  54. 2010-11-29 11:08:33,858 INFO [org.hibernate.search.Version] (ajp-0.0.0.0-8009-1) Hibernate Search 3.2.1.Final<br>
  55. 2010-11-29 11:08:33,870 INFO [org.hibernate.annotations.common.Version] (ajp-0.0.0.0-8009-1) Hibernate Commons Annotations 3.2.0.Final<br>
  56. 2010-11-29 11:08:34,178 INFO [org.hibernate.impl.SessionFactoryImpl] (ajp-0.0.0.0-8009-1) building session factory<br>
  57. 2010-11-29 11:08:34,186 WARNING [net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory] (ajp-0.0.0.0-8009-1) No TransactionManagerLookup found in Hibernate config, XA Caches will be participating in the two-phase commit!<br>
  58. 2010-11-29 11:08:34,195 WARNING [net.sf.ehcache.config.ConfigurationFactory] (ajp-0.0.0.0-8009-1) No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: vfszip:/opt/jboss-5.1.0.GA/server/default/deploy/bonita.ear/lib/ehcache-core-2.2.0.jar/ehcache-failsafe.xml<br>
  59. 2010-11-29 11:08:34,950 INFO [org.hibernate.impl.SessionFactoryObjectFactory] (ajp-0.0.0.0-8009-1) Not binding factory to JNDI, no JNDI name configured<br>
  60. 2010-11-29 11:08:35,865 INFO [org.hibernate.cfg.Configuration] (ajp-0.0.0.0-8009-1) Reading mappings from resource: bonita.definition.hbm.xml<br>
  61. <br>
  62. --- many, many Mapping messages ---<br>
  63. <br>
  64. 2010-11-29 11:08:36,158 INFO [org.hibernate.util.NamingHelper] (ajp-0.0.0.0-8009-1) JNDI InitialContext properties:{}<br>
  65. 2010-11-29 11:08:36,165 INFO [org.hibernate.connection.DatasourceConnectionProvider] (ajp-0.0.0.0-8009-1) Using datasource: bonitaHistoryDS<br>
  66. 2010-11-29 11:08:36,177 WARN [com.arjuna.ats.jta.logging.loggerI18N] (ajp-0.0.0.0-8009-1) [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@2a9c1149<br>
  67. 2010-11-29 11:08:36,184 WARNING [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Could not obtain connection to query metadata<br>
  68. 2010-11-29 11:08:36,187 INFO [org.hibernate.dialect.Dialect] (ajp-0.0.0.0-8009-1) Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<br>
  69. 2010-11-29 11:08:36,188 INFO [org.hibernate.engine.jdbc.JdbcSupportLoader] (ajp-0.0.0.0-8009-1) Disabling contextual LOB creation as connection was null<br>
  70. 2010-11-29 11:08:36,188 INFO [org.hibernate.transaction.TransactionFactoryFactory] (ajp-0.0.0.0-8009-1) Using default transaction strategy (direct JDBC transactions)<br>
  71. 2010-11-29 11:08:36,189 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] (ajp-0.0.0.0-8009-1) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)<br>
  72. 2010-11-29 11:08:36,189 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Automatic flush during beforeCompletion(): disabled<br>
  73. 2010-11-29 11:08:36,190 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Automatic session close at end of transaction: disabled<br>
  74. 2010-11-29 11:08:36,190 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Scrollable result sets: disabled<br>
  75. 2010-11-29 11:08:36,191 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JDBC3 getGeneratedKeys(): disabled<br>
  76. 2010-11-29 11:08:36,191 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Connection release mode: auto<br>
  77. 2010-11-29 11:08:36,192 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Maximum outer join fetch depth: 2<br>
  78. 2010-11-29 11:08:36,192 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Default batch fetch size: 1<br>
  79. 2010-11-29 11:08:36,192 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Generate SQL with comments: disabled<br>
  80. 2010-11-29 11:08:36,193 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Order SQL updates by primary key: disabled<br>
  81. 2010-11-29 11:08:36,193 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Order SQL inserts for batching: disabled<br>
  82. 2010-11-29 11:08:36,194 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory<br>
  83. 2010-11-29 11:08:36,194 INFO [org.hibernate.hql.ast.ASTQueryTranslatorFactory] (ajp-0.0.0.0-8009-1) Using ASTQueryTranslatorFactory<br>
  84. 2010-11-29 11:08:36,194 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query language substitutions: {}<br>
  85. 2010-11-29 11:08:36,195 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) JPA-QL strict compliance: disabled<br>
  86. 2010-11-29 11:08:36,195 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Second-level cache: disabled<br>
  87. 2010-11-29 11:08:36,196 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Query cache: disabled<br>
  88. 2010-11-29 11:08:36,196 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Cache region factory : net.sf.ehcache.hibernate.EhCacheRegionFactory<br>
  89. 2010-11-29 11:08:36,197 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Optimize cache for minimal puts: enabled<br>
  90. 2010-11-29 11:08:36,197 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Structured second-level cache entries: disabled<br>
  91. 2010-11-29 11:08:36,198 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Statistics: disabled<br>
  92. 2010-11-29 11:08:36,198 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Deleted entity synthetic identifier rollback: disabled<br>
  93. 2010-11-29 11:08:36,198 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Default entity-mode: pojo<br>
  94. 2010-11-29 11:08:36,199 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Named query checking : enabled<br>
  95. 2010-11-29 11:08:36,199 INFO [org.hibernate.cfg.SettingsFactory] (ajp-0.0.0.0-8009-1) Check Nullability in Core (should be disabled when Bean Validation is on): enabled<br>
  96. 2010-11-29 11:08:36,297 INFO [org.hibernate.impl.SessionFactoryImpl] (ajp-0.0.0.0-8009-1) building session factory<br>
  97. 2010-11-29 11:08:36,298 WARNING [net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory] (ajp-0.0.0.0-8009-1) No TransactionManagerLookup found in Hibernate config, XA Caches will be participating in the two-phase commit!<br>
  98. 2010-11-29 11:08:36,298 WARNING [net.sf.ehcache.config.ConfigurationFactory] (ajp-0.0.0.0-8009-1) No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: vfszip:/opt/jboss-5.1.0.GA/server/default/deploy/bonita.ear/lib/ehcache-core-2.2.0.jar/ehcache-failsafe.xml<br>
  99. 2010-11-29 11:08:36,415 WARNING [net.sf.ehcache.CacheManager] (ajp-0.0.0.0-8009-1) Creating a new instance of CacheManager using the diskStorePath "/tmp" which is already used by an existing CacheManager.<br>
  100. 2010-11-29 11:08:36,730 INFO [org.hibernate.impl.SessionFactoryObjectFactory] (ajp-0.0.0.0-8009-1) Not binding factory to JNDI, no JNDI name configured<br>
  101. 2010-11-29 11:08:37,170 INFO [org.ow2.bonita.runtime.event.EventExecutor] (ajp-0.0.0.0-8009-1) starting event executor threads for event executor 'EventExecutor-127.0.1.1-default'...<br>
  102. 2010-11-29 11:08:37,171 INFO [org.ow2.bonita.runtime.event.EventExecutor] (ajp-0.0.0.0-8009-1) starting dispatcher thread for event executor 'EventExecutor-127.0.1.1-default'...<br>
  103. 2010-11-29 11:08:37,198 INFO [org.ow2.bonita.runtime.event.EventDispatcherThread] (EventDispatcherThread-127.0.1.1-default) starting...<br>
  104. 2010-11-29 11:08:37,285 WARNING [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8009-1) SQL Error: 0, SQLState: null<br>
  105. 2010-11-29 11:08:37,285 SEVERE [org.hibernate.util.JDBCExceptionReporter] (ajp-0.0.0.0-8009-1) Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:97ae:4cf37b7b:63 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:97ae:4cf37b7b:63 status: ActionStatus.ABORT_ONLY >)<br>
  106. 2010-11-29 11:08:37,286 SEVERE [org.ow2.bonita.runtime.tx.HibernateSessionResource] (ajp-0.0.0.0-8009-1) hibernate transaction begin failed. closing hibernate session: org.hibernate.exception.GenericJDBCException: Cannot open connection<br>
  107. 2010-11-29 11:08:37,288 SEVERE [org.ow2.bonita.services.impl.DefaultCommandService] (ajp-0.0.0.0-8009-1) exception while executing command org.ow2.bonita.facade.APIInterceptor$APIInterceptorCommand@14b518dc: Cannot open connection<br>
  108. 2010-11-29 11:08:37,325 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bonita].[org.bonitasoft.console.security.server.CredentialsEncryptionServlet/security/credentialsencryption]] (ajp-0.0.0.0-8009-1) Servlet.service() for servlet org.bonitasoft.console.security.server.CredentialsEncryptionServlet/security/credentialsencryption threw exception<br>
  109. 2010-11-29 11:08:47,340 INFO [org.ow2.bonita.runtime.event.EventDispatcherThread] (EventDispatcherThread-127.0.1.1-default) EventDispatcherThread-127.0.1.1-default woke up, refresh=false<br>
  110. 2010-11-29 11:08:57,346 INFO [org.ow2.bonita.runtime.event.EventDispatcherThread] (EventDispatcherThread-127.0.1.1-default) EventDispatcherThread-127.0.1.1-default woke up, refresh=false<br>





Where could be the problem? I think it has something to do with transactions, but i'm not sure...

IMO, the real shi* begins, when Bonita tries to connect to the History-DB...but i'm not sure...



Greetz,

PS

Comments

Submitted by bouquetf Mon, 12/06/2010 - 15:54

Hi,



What happens exactly ?

Submitted by wenhao.wang Mon, 12/20/2010 - 08:26

Is the deployment with muiti-tenancy?

Submitted by aurelien.pupier Mon, 12/27/2010 - 13:28

Hi,



can you try to use "no-tx-datasource" instead of "local-tx-datasource"



Regards,

Submitted by fmelossi Mon, 06/13/2011 - 01:59

I can not manage not to lose the connection with mysql. I use datasource



I show my configuration:



BOS 5.5

Glassfish 2.x

Netbeans



----------------------------

bonita-journal.properties

-----------------------------



hibernate.cache.use_second_level_cache false

hibernate.cache.use_query_cache false



hibernate.connection.shutdown true



hibernate.show_sql false

hibernate.format_sql false

hibernate.use_sql_comments false



bonita.search.use false

hibernate.search.default.indexBase ${BONITA_HOME}/server/default/work/indexes/journal


MYSQL



hibernate.connection.datasource jdbc/bonita_journal

hibernate.dialect org.hibernate.dialect.MySQL5InnoDBDialect

hibernate.connection.driver_class com.mysql.jdbc.Driver

hibernate.connection.username root

hibernate.connection.password **********



For this problem I can not use new versions of BOS



Appreciate your help



thanks

Submitted by bouquetf Wed, 06/15/2011 - 14:21

Hi,



Does this error comes at the launch of BOS or after a while ?

The problem may be that mysql close the connection after a timeout. A solution to this problem is to define a pool of connections to mysql.

Submitted by fmelossi Thu, 06/16/2011 - 04:41

Mysql lost connection, that I avoided using c3p0 to 5.2.4 BOS

To reproduce the error restart mysql and throws the error, this did not happen when using c3p0 to 5.2.4 BOS



I defined a pool of connections in mysql in glassfish but it throws the error. how I can fix this problem?

Submitted by fmelossi Wed, 06/22/2011 - 18:45

I want to use the version BOS 5.5 but C2P0 throws errors, then try creating a datasource on my server glassfish, but mysql loses connection.



I need you please help me

Submitted by edouard.lafon Fri, 09/23/2011 - 11:40

Hi,



Did you resolve your problem?



Thanks