2 Replies Latest reply on Dec 18, 2005 12:35 PM by Koen Aers

    should i have a hsqldb.xml?

    pedro costa Apprentice

      I don't know if i'm posting following the rules of good manners, but, i also don't know if this post should also be here, or simply in the hibernate forum.

      The post is in the link:
      http://forum.hibernate.org/viewtopic.php?p=2276312#2276312

      The question that i have is, should i have an hsqldb-ds.xml file in my jbpm project, besides the hibernate.cfg.xml and hibernate.properties?

      If anyone would like to asnwer to the questions posted in hibernate forums, i will be very very thankful.


      Thanks,
      Pedro

        • 1. Re: should i have a hsqldb.xml?
          pedro costa Apprentice

          How can i define my jbpm project to work in another port, beside 1701?
          I've tried to configure my hibernate.properties and hibernate.cfg.xml, and i get the error:

          
          15:02:24,694 INFO Environment:464 - Hibernate 3.0.5
          15:02:24,710 INFO Environment:482 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.format_sql=true, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:hsqldb:hsql://localhost:5432, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
          15:02:24,710 INFO Environment:509 - using java.io streams to persist binary types
          15:02:24,710 INFO Environment:510 - using CGLIB reflection optimizer
          15:02:24,710 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
          15:02:24,788 INFO Configuration:1110 - configuring from resource: /hibernate.cfg.xml
          15:02:24,788 INFO Configuration:1081 - Configuration resource: /hibernate.cfg.xml
          15:02:25,101 INFO Configuration:444 - Mapping resource: com/sample/jbpm/hibernate/TabelaGestaoOcorrencias.hbm.xml
          15:02:25,241 INFO HbmBinder:260 - Mapping class: com.sample.jbpm.hibernate.TabelaGestaoOcorrencias -> GESTAOOCORRENCIAS
          15:02:25,272 INFO Configuration:1222 - Configured SessionFactory: null
          15:02:25,272 INFO Configuration:875 - processing extends queue
          15:02:25,272 INFO Configuration:879 - processing collection mappings
          15:02:25,272 INFO Configuration:888 - processing association property references
          15:02:25,272 INFO Configuration:917 - processing foreign key constraints
          15:02:25,351 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
          15:02:25,351 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
          15:02:25,351 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
          15:02:25,351 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:5432
          15:02:25,351 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
          15:02:26,335 WARN SettingsFactory:103 - Could not obtain connection metadata
          java.sql.SQLException: socket creation error
           at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
           at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
           at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
           at org.hsqldb.jdbcDriver.connect(Unknown Source)
           at java.sql.DriverManager.getConnection(Unknown Source)
           at java.sql.DriverManager.getConnection(Unknown Source)
           at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
           at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
           at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
           at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
           at com.sample.jbpm.hibernate.util.HibernateUtil.<clinit>(HibernateUtil.java:23)
           at com.sample.jbpm.hibernate.GestorEntradas.createAndStoreEvent(GestorEntradas.java:12)
           at com.sample.jbpm.hibernate.GestorEntradas.main(GestorEntradas.java:39)
          15:02:26,351 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
          15:02:26,366 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
          15:02:26,366 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
          15:02:26,366 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
          15:02:26,366 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
          15:02:26,382 INFO SettingsFactory:144 - Scrollable result sets: disabled
          15:02:26,398 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
          15:02:26,413 INFO SettingsFactory:160 - Connection release mode: null
          15:02:26,413 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
          15:02:26,413 INFO SettingsFactory:187 - Default batch fetch size: 1
          15:02:26,413 INFO SettingsFactory:191 - Generate SQL with comments: disabled
          15:02:26,413 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
          15:02:26,413 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
          15:02:26,413 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
          15:02:26,413 INFO SettingsFactory:203 - Query language substitutions: {}
          15:02:26,413 INFO SettingsFactory:209 - Second-level cache: enabled
          15:02:26,413 INFO SettingsFactory:213 - Query cache: disabled
          15:02:26,413 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.HashtableCacheProvider
          15:02:26,413 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
          15:02:26,413 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
          15:02:26,413 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
          15:02:26,413 INFO SettingsFactory:257 - Echoing all SQL to stdout
          15:02:26,413 INFO SettingsFactory:261 - Statistics: disabled
          15:02:26,413 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
          15:02:26,413 INFO SettingsFactory:279 - Default entity-mode: pojo
          Exception in thread "main" 15:02:26,538 INFO SessionFactoryImpl:152 - building session factory
          15:02:26,554 WARN CacheFactory:43 - read-only cache configured for mutable class: hibernate.test.com.sample.jbpm.hibernate.TabelaGestaoOcorrencias
          15:02:26,851 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
          15:02:26,851 INFO SessionFactoryImpl:379 - Checking 0 named queries
          org.hibernate.HibernateException: No TransactionManagerLookup specified
           at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:503)
           at com.sample.jbpm.hibernate.GestorEntradas.createAndStoreEvent(GestorEntradas.java:12)
           at com.sample.jbpm.hibernate.GestorEntradas.main(GestorEntradas.java:39)
          


          hibernate.properties
          hibernate.dialect org.hibernate.dialect.HSQLDialect
          # jdbc connection properties
          hibernate.connection.driver_class org.hsqldb.jdbcDriver
          hibernate.connection.username sa
          hibernate.connection.password
          hibernate.connection.url jdbc:hsqldb:hsql://localhost:1701
          
          



          • 2. Re: should i have a hsqldb.xml?
            Koen Aers Master

            Pedro,

            The 1701 port is the default port of HSQLDB. If you want to work with HSQLDB on another port you should change the datasource configuration in the JBoss instance that hosts your HSQLDB. For the default jBPM server this is the %JBPM-SERVER-HOME%/jbpm/deploy folder. In this folder you will find the hsqldb-ds.xml file that you should edit.

            Regards,
            Koen