should i have a hsqldb.xml?

[pedrosacosta]

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

[pedrosacosta]

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

[koen.aers]

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