Petals SE KPI

Unable to store into files

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.2
  • Fix Version/s: 1.0.4, 1.1.1
  • Component/s: None
  • Security Level: Public
  • Description:
    Hide

    I can't use the "file" mode to store the notifications. The "mysql database" mode is ok.
    My configuration:

    ############

        1. Petals View properties
          ############

    ##Globals Informations
    jdbc.hibernate.hbm2ddl.auto = update
    jdbc.hibernate.show_sql = false
    jdbc.initialSize = 0
    jdbc.maxActive = 8
    jdbc.maxIdle = 8
    jdbc.minIdle = 0
    jdbc.maxWait = -1

      1. In File (mixed mode) H2 Datasource
        jdbc.driverClassName = org.h2.Driver
        jdbc.url = jdbc:h2:~/test/db/petalsview;AUTO_SERVER=TRUE
        jdbc.username = sa
        jdbc.password = sa
        jdbc.hibernate.dialect = org.hibernate.dialect.H2Dialect

    And the stack trace:
    11:49:47,709 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-hibernate.xml]
    11:49:47,896 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-jdbc.xml]
    11:49:48,155 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-annotation.xml]
    11:49:48,285 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-transaction.xml]
    11:49:49,120 INFO org.springframework.core.io.support.PropertiesLoaderSupport:177 - Loading properties file from URL file:/exec/applis/ros/petals/G04R01C00/conf/server.properties
    11:49:49,228 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory:538 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3ba102ef: defining beans sessionFactory,dataSource,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,flowDAO,flowStepDAO,flowRefDAO,flowStepErrorRefDAO,flowStepRefDAO,notificationProcessor,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor; root of factory hierarchy
    11:49:49,366 INFO org.hibernate.cfg.annotations.Version:43 - Hibernate Annotations 3.5.1-Final
    11:49:49,378 INFO org.hibernate.cfg.Environment:564 - Hibernate 3.5.1-Final
    11:49:49,380 INFO org.hibernate.cfg.Environment:597 - hibernate.properties not found
    11:49:49,383 INFO org.hibernate.cfg.Environment:775 - Bytecode provider name : javassist
    11:49:49,386 INFO org.hibernate.cfg.Environment:656 - using JDK 1.4 java.sql.Timestamp handling
    11:49:49,495 INFO org.hibernate.annotations.common.Version:37 - Hibernate Commons Annotations 3.2.0.Final
    11:49:49,919 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flow.Flow
    11:49:49,948 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flow.Flow on table FLOW
    11:49:50,036 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flow.FlowStep
    11:49:50,036 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flow.FlowStep on table FLOWSTEP
    11:49:50,071 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowRef
    11:49:50,071 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowRef on table FLOWREF
    11:49:50,075 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepErrorRef
    11:49:50,077 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepErrorRef on table FLOWSTEPERRORREF
    11:49:50,079 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef
    11:49:50,080 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef on table FLOWSTEPREF
    11:49:50,154 INFO org.hibernate.cfg.annotations.CollectionBinder:729 - Mapping collection: com.ebmwebsourcing.petalsview.persistence.model.flow.Flow.listFlowStep -> FLOWSTEP
    11:49:50,155 INFO org.hibernate.cfg.annotations.CollectionBinder:729 - Mapping collection: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef.errorMessages -> FLOWSTEPERRORREF
    11:49:50,160 INFO org.hibernate.cfg.AnnotationConfiguration:450 - Hibernate Validator not found: ignoring
    11:49:50,164 INFO org.springframework.orm.hibernate3.LocalSessionFactoryBean:772 - Building new Hibernate SessionFactory
    11:49:50,220 INFO org.hibernate.connection.ConnectionProviderFactory:95 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
    11:49:52,054 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
    11:49:52,057 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114])
    11:49:52,058 WARN org.hibernate.cfg.SettingsFactory:137 - Could not obtain connection to query metadata
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114])
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
    at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62)
    at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73)
    at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467)
    at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101)
    at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110)
    Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114]
    at org.h2.message.Message.getSQLException(Message.java:105)
    at org.h2.message.Message.getSQLException(Message.java:116)
    at org.h2.tools.Server.start(Server.java:359)
    at org.h2.engine.Database.startServer(Database.java:674)
    at org.h2.engine.Database.open(Database.java:557)
    at org.h2.engine.Database.openDatabase(Database.java:219)
    at org.h2.engine.Database.<init>(Database.java:214)
    at org.h2.engine.Engine.openSession(Engine.java:58)
    at org.h2.engine.Engine.openSession(Engine.java:140)
    at org.h2.engine.Engine.getSession(Engine.java:120)
    at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
    at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
    at org.h2.Driver.connect(Driver.java:58)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 31 more
    11:49:52,081 INFO org.hibernate.dialect.Dialect:222 - Using dialect: org.hibernate.dialect.H2Dialect
    11:49:52,088 INFO org.hibernate.engine.jdbc.JdbcSupportLoader:70 - Disabling contextual LOB creation as connection was null
    11:49:52,089 INFO org.hibernate.transaction.TransactionFactoryFactory:62 - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
    11:49:52,091 INFO org.hibernate.transaction.TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
    11:49:52,091 INFO org.hibernate.cfg.SettingsFactory:169 - Automatic flush during beforeCompletion(): disabled
    11:49:52,092 INFO org.hibernate.cfg.SettingsFactory:173 - Automatic session close at end of transaction: disabled
    11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:188 - Scrollable result sets: disabled
    11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:196 - JDBC3 getGeneratedKeys(): disabled
    11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:204 - Connection release mode: auto
    11:49:52,094 INFO org.hibernate.cfg.SettingsFactory:231 - Default batch fetch size: 1
    11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:235 - Generate SQL with comments: disabled
    11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:239 - Order SQL updates by primary key: disabled
    11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:243 - Order SQL inserts for batching: disabled
    11:49:52,096 INFO org.hibernate.cfg.SettingsFactory:410 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
    11:49:52,098 INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
    11:49:52,098 INFO org.hibernate.cfg.SettingsFactory:251 - Query language substitutions: {}
    11:49:52,098 INFO org.hibernate.cfg.SettingsFactory:256 - JPA-QL strict compliance: disabled
    11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:261 - Second-level cache: enabled
    11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:265 - Query cache: disabled
    11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:395 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
    11:49:52,100 INFO org.hibernate.cfg.SettingsFactory:275 - Optimize cache for minimal puts: disabled
    11:49:52,100 INFO org.hibernate.cfg.SettingsFactory:284 - Structured second-level cache entries: disabled
    11:49:52,105 INFO org.hibernate.cfg.SettingsFactory:313 - Statistics: disabled
    11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:317 - Deleted entity synthetic identifier rollback: disabled
    11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:332 - Default entity-mode: pojo
    11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:336 - Named query checking : enabled
    11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:340 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
    11:49:52,129 INFO org.hibernate.search.Version:40 - Hibernate Search 3.2.0.Final
    11:49:52,564 INFO org.hibernate.impl.SessionFactoryImpl:199 - building session factory
    11:49:52,775 INFO org.hibernate.impl.SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
    11:49:52,781 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:155 - Running hbm2ddl schema update
    11:49:52,781 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:167 - fetching database metadata
    11:49:54,427 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
    11:49:54,427 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114])
    11:49:54,428 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:175 - could not get database metadata
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114])
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62)
    at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73)
    at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467)
    at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101)
    at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110)
    Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114]
    at org.h2.message.Message.getSQLException(Message.java:105)
    at org.h2.message.Message.getSQLException(Message.java:116)
    at org.h2.tools.Server.start(Server.java:359)
    at org.h2.engine.Database.startServer(Database.java:674)
    at org.h2.engine.Database.open(Database.java:557)
    at org.h2.engine.Database.openDatabase(Database.java:219)
    at org.h2.engine.Database.<init>(Database.java:214)
    at org.h2.engine.Engine.openSession(Engine.java:58)
    at org.h2.engine.Engine.openSession(Engine.java:140)
    at org.h2.engine.Engine.getSession(Engine.java:120)
    at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
    at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
    at org.h2.Driver.connect(Driver.java:58)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 31 more
    11:49:54,428 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:222 - could not complete schema update
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114])
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76)
    at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62)
    at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73)
    at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467)
    at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101)
    at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110)
    Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114]
    at org.h2.message.Message.getSQLException(Message.java:105)
    at org.h2.message.Message.getSQLException(Message.java:116)
    at org.h2.tools.Server.start(Server.java:359)
    at org.h2.engine.Database.startServer(Database.java:674)
    at org.h2.engine.Database.open(Database.java:557)
    at org.h2.engine.Database.openDatabase(Database.java:219)
    at org.h2.engine.Database.<init>(Database.java:214)
    at org.h2.engine.Engine.openSession(Engine.java:58)
    at org.h2.engine.Engine.openSession(Engine.java:140)
    at org.h2.engine.Engine.getSession(Engine.java:120)
    at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
    at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
    at org.h2.Driver.connect(Driver.java:58)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 31 more
    11:49:54,655 INFO org.springframework.orm.hibernate3.HibernateTransactionManager:415 - Using DataSource [org.apache.commons.dbcp.BasicDataSource@2ed4e99c] of Hibernate SessionFactory for HibernateTransactionManage

    Show
    I can't use the "file" mode to store the notifications. The "mysql database" mode is ok. My configuration: ############
        1. Petals View properties ############
    ##Globals Informations jdbc.hibernate.hbm2ddl.auto = update jdbc.hibernate.show_sql = false jdbc.initialSize = 0 jdbc.maxActive = 8 jdbc.maxIdle = 8 jdbc.minIdle = 0 jdbc.maxWait = -1
      1. In File (mixed mode) H2 Datasource jdbc.driverClassName = org.h2.Driver jdbc.url = jdbc:h2:~/test/db/petalsview;AUTO_SERVER=TRUE jdbc.username = sa jdbc.password = sa jdbc.hibernate.dialect = org.hibernate.dialect.H2Dialect
    And the stack trace: 11:49:47,709 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-hibernate.xml] 11:49:47,896 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-jdbc.xml] 11:49:48,155 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-annotation.xml] 11:49:48,285 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [petals-view-transaction.xml] 11:49:49,120 INFO org.springframework.core.io.support.PropertiesLoaderSupport:177 - Loading properties file from URL file:/exec/applis/ros/petals/G04R01C00/conf/server.properties 11:49:49,228 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory:538 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3ba102ef: defining beans sessionFactory,dataSource,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,flowDAO,flowStepDAO,flowRefDAO,flowStepErrorRefDAO,flowStepRefDAO,notificationProcessor,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor; root of factory hierarchy 11:49:49,366 INFO org.hibernate.cfg.annotations.Version:43 - Hibernate Annotations 3.5.1-Final 11:49:49,378 INFO org.hibernate.cfg.Environment:564 - Hibernate 3.5.1-Final 11:49:49,380 INFO org.hibernate.cfg.Environment:597 - hibernate.properties not found 11:49:49,383 INFO org.hibernate.cfg.Environment:775 - Bytecode provider name : javassist 11:49:49,386 INFO org.hibernate.cfg.Environment:656 - using JDK 1.4 java.sql.Timestamp handling 11:49:49,495 INFO org.hibernate.annotations.common.Version:37 - Hibernate Commons Annotations 3.2.0.Final 11:49:49,919 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flow.Flow 11:49:49,948 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flow.Flow on table FLOW 11:49:50,036 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flow.FlowStep 11:49:50,036 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flow.FlowStep on table FLOWSTEP 11:49:50,071 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowRef 11:49:50,071 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowRef on table FLOWREF 11:49:50,075 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepErrorRef 11:49:50,077 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepErrorRef on table FLOWSTEPERRORREF 11:49:50,079 INFO org.hibernate.cfg.AnnotationBinder:522 - Binding entity from annotated class: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef 11:49:50,080 INFO org.hibernate.cfg.annotations.EntityBinder:501 - Bind entity com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef on table FLOWSTEPREF 11:49:50,154 INFO org.hibernate.cfg.annotations.CollectionBinder:729 - Mapping collection: com.ebmwebsourcing.petalsview.persistence.model.flow.Flow.listFlowStep -> FLOWSTEP 11:49:50,155 INFO org.hibernate.cfg.annotations.CollectionBinder:729 - Mapping collection: com.ebmwebsourcing.petalsview.persistence.model.flowref.FlowStepRef.errorMessages -> FLOWSTEPERRORREF 11:49:50,160 INFO org.hibernate.cfg.AnnotationConfiguration:450 - Hibernate Validator not found: ignoring 11:49:50,164 INFO org.springframework.orm.hibernate3.LocalSessionFactoryBean:772 - Building new Hibernate SessionFactory 11:49:50,220 INFO org.hibernate.connection.ConnectionProviderFactory:95 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider 11:49:52,054 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null 11:49:52,057 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114]) 11:49:52,058 WARN org.hibernate.cfg.SettingsFactory:137 - Could not obtain connection to query metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114]) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62) at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73) at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467) at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101) at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110) Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:40374) (port may be in use), cause: timeout [90061-114] at org.h2.message.Message.getSQLException(Message.java:105) at org.h2.message.Message.getSQLException(Message.java:116) at org.h2.tools.Server.start(Server.java:359) at org.h2.engine.Database.startServer(Database.java:674) at org.h2.engine.Database.open(Database.java:557) at org.h2.engine.Database.openDatabase(Database.java:219) at org.h2.engine.Database.<init>(Database.java:214) at org.h2.engine.Engine.openSession(Engine.java:58) at org.h2.engine.Engine.openSession(Engine.java:140) at org.h2.engine.Engine.getSession(Engine.java:120) at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245) at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89) at org.h2.Driver.connect(Driver.java:58) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 31 more 11:49:52,081 INFO org.hibernate.dialect.Dialect:222 - Using dialect: org.hibernate.dialect.H2Dialect 11:49:52,088 INFO org.hibernate.engine.jdbc.JdbcSupportLoader:70 - Disabling contextual LOB creation as connection was null 11:49:52,089 INFO org.hibernate.transaction.TransactionFactoryFactory:62 - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory 11:49:52,091 INFO org.hibernate.transaction.TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 11:49:52,091 INFO org.hibernate.cfg.SettingsFactory:169 - Automatic flush during beforeCompletion(): disabled 11:49:52,092 INFO org.hibernate.cfg.SettingsFactory:173 - Automatic session close at end of transaction: disabled 11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:188 - Scrollable result sets: disabled 11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:196 - JDBC3 getGeneratedKeys(): disabled 11:49:52,093 INFO org.hibernate.cfg.SettingsFactory:204 - Connection release mode: auto 11:49:52,094 INFO org.hibernate.cfg.SettingsFactory:231 - Default batch fetch size: 1 11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:235 - Generate SQL with comments: disabled 11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:239 - Order SQL updates by primary key: disabled 11:49:52,095 INFO org.hibernate.cfg.SettingsFactory:243 - Order SQL inserts for batching: disabled 11:49:52,096 INFO org.hibernate.cfg.SettingsFactory:410 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 11:49:52,098 INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory 11:49:52,098 INFO org.hibernate.cfg.SettingsFactory:251 - Query language substitutions: {} 11:49:52,098 INFO org.hibernate.cfg.SettingsFactory:256 - JPA-QL strict compliance: disabled 11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:261 - Second-level cache: enabled 11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:265 - Query cache: disabled 11:49:52,099 INFO org.hibernate.cfg.SettingsFactory:395 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory 11:49:52,100 INFO org.hibernate.cfg.SettingsFactory:275 - Optimize cache for minimal puts: disabled 11:49:52,100 INFO org.hibernate.cfg.SettingsFactory:284 - Structured second-level cache entries: disabled 11:49:52,105 INFO org.hibernate.cfg.SettingsFactory:313 - Statistics: disabled 11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:317 - Deleted entity synthetic identifier rollback: disabled 11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:332 - Default entity-mode: pojo 11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:336 - Named query checking : enabled 11:49:52,106 INFO org.hibernate.cfg.SettingsFactory:340 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled 11:49:52,129 INFO org.hibernate.search.Version:40 - Hibernate Search 3.2.0.Final 11:49:52,564 INFO org.hibernate.impl.SessionFactoryImpl:199 - building session factory 11:49:52,775 INFO org.hibernate.impl.SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured 11:49:52,781 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:155 - Running hbm2ddl schema update 11:49:52,781 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate:167 - fetching database metadata 11:49:54,427 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null 11:49:54,427 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114]) 11:49:54,428 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:175 - could not get database metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114]) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62) at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73) at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467) at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101) at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110) Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114] at org.h2.message.Message.getSQLException(Message.java:105) at org.h2.message.Message.getSQLException(Message.java:116) at org.h2.tools.Server.start(Server.java:359) at org.h2.engine.Database.startServer(Database.java:674) at org.h2.engine.Database.open(Database.java:557) at org.h2.engine.Database.openDatabase(Database.java:219) at org.h2.engine.Database.<init>(Database.java:214) at org.h2.engine.Engine.openSession(Engine.java:58) at org.h2.engine.Engine.openSession(Engine.java:140) at org.h2.engine.Engine.getSession(Engine.java:120) at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245) at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89) at org.h2.Driver.connect(Driver.java:58) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 31 more 11:49:54,428 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:222 - could not complete schema update org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114]) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) at org.ow2.petals.engine.kpi.listener.NotificationStorage.createNotificationProcessor(NotificationStorage.java:81) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:76) at org.ow2.petals.engine.kpi.listener.NotificationStorage.<init>(NotificationStorage.java:62) at org.ow2.petals.engine.kpi.ServiceEngine.doInit(ServiceEngine.java:73) at org.ow2.petals.component.framework.AbstractComponent.init(AbstractComponent.java:467) at org.ow2.petals.container.thread.ComponentLifeCycleThread.doTask(ComponentLifeCycleThread.java:101) at org.ow2.petals.container.thread.AbstractThread.run(AbstractThread.java:110) Caused by: org.h2.jdbc.JdbcSQLException: Exception opening port H2 TCP Server (tcp://localhost:22658) (port may be in use), cause: timeout [90061-114] at org.h2.message.Message.getSQLException(Message.java:105) at org.h2.message.Message.getSQLException(Message.java:116) at org.h2.tools.Server.start(Server.java:359) at org.h2.engine.Database.startServer(Database.java:674) at org.h2.engine.Database.open(Database.java:557) at org.h2.engine.Database.openDatabase(Database.java:219) at org.h2.engine.Database.<init>(Database.java:214) at org.h2.engine.Engine.openSession(Engine.java:58) at org.h2.engine.Engine.openSession(Engine.java:140) at org.h2.engine.Engine.getSession(Engine.java:120) at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245) at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89) at org.h2.Driver.connect(Driver.java:58) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 31 more 11:49:54,655 INFO org.springframework.orm.hibernate3.HibernateTransactionManager:415 - Using DataSource [org.apache.commons.dbcp.BasicDataSource@2ed4e99c] of Hibernate SessionFactory for HibernateTransactionManage
  • Environment:
    RHEL 5, JDK 1.6, Petals ESB 3.2-SNAPSHOT

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 09:02:54 +0200 - edited

The h2 default mode try to use connections on port 22658. The default classic security policy allow only to use port lower than 8900. So a solution is to break this security configuration (by default on RHEL 4, Fedora, CentOS). Another solution is to use the h2 'file' mode: no port to open, storage directly into a file. The new url to use under kpi and petals view is for example:
"jdbc.url = jdbc:h2:file:~/test/db/petalsview".
Add this into the documentation to close this track?

Show
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 09:02:54 +0200 - edited The h2 default mode try to use connections on port 22658. The default classic security policy allow only to use port lower than 8900. So a solution is to break this security configuration (by default on RHEL 4, Fedora, CentOS). Another solution is to use the h2 'file' mode: no port to open, storage directly into a file. The new url to use under kpi and petals view is for example: "jdbc.url = jdbc:h2:file:~/test/db/petalsview". Add this into the documentation to close this track?
Hide
Permalink
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 09:21:40 +0200

Fred,

I don't understand what you mean.
You had initially a problem using the file mode of H2 database and activating the H2 server. The problem was about the default port of the H2 server.
In your last comment you speak about HSQLDB but JDBC URL for H2. Have you mixed HSQLDB and H2 in your comment or have you mixed them into your configuration ?

Show
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 09:21:40 +0200 Fred, I don't understand what you mean. You had initially a problem using the file mode of H2 database and activating the H2 server. The problem was about the default port of the H2 server. In your last comment you speak about HSQLDB but JDBC URL for H2. Have you mixed HSQLDB and H2 in your comment or have you mixed them into your configuration ?
Hide
Permalink
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 09:41:23 +0200

Sorry, I only talked about H2: I rename the track.

Show
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 09:41:23 +0200 Sorry, I only talked about H2: I rename the track.
Hide
Permalink
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 11:23:12 +0200 - edited

Using H2, the server activation can't be removed because the Petals View UI needs to be connected to the database.
So the documentation of Petals View updated to document your problem with its solutions: see section "Installing Petals View" / "Known problems".

Show
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 11:23:12 +0200 - edited Using H2, the server activation can't be removed because the Petals View UI needs to be connected to the database. So the documentation of Petals View updated to document your problem with its solutions: see section "Installing Petals View" / "Known problems".
Hide
Permalink
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 11:41:59 +0200 - edited

I added my solution to your list: check at Petals Link if it's ok. Finished for me

Show
Frédéric Gardes added a comment - Fri, 24 Sep 2010 - 11:41:59 +0200 - edited I added my solution to your list: check at Petals Link if it's ok. Finished for me
Hide
Permalink
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 12:10:57 +0200

Are you sure that your solution is working using the Petals View UI ? It seems to me that the server activation is need to Petals View to create connection to retrieve data.

Show
Christophe DENEUX added a comment - Fri, 24 Sep 2010 - 12:10:57 +0200 Are you sure that your solution is working using the Petals View UI ? It seems to me that the server activation is need to Petals View to create connection to retrieve data.

People

Dates

  • Created:
    Tue, 31 Aug 2010 - 09:07:20 +0200
    Updated:
    Fri, 5 Nov 2010 - 10:19:18 +0100
    Resolved:
    Fri, 24 Sep 2010 - 11:33:14 +0200
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.