I have very interesting situation. I have project in eclipse and when starts application from eclipse everything works fine. When I try to start same application from console (of course classpath is setuped correctly) I have exceptions shown bellow.

Any ideas how to resolve this problem and why it happens?

Thanks,
Jan.

Hibernate version: 2.1.6

Relevant hibernate.properties items are:

Mapping documents:
hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'
...
hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password
hibernate.connection.url jdbc:hsqldb:receptidb
...
hibernate.c3p0.max_size 2
hibernate.c3p0.min_size 2
hibernate.c3p0.timeout 5000
hibernate.c3p0.max_statements 100
hibernate.c3p0.idle_test_period 3000
hibernate.c3p0.acquire_increment 2
hibernate.c3p0.validate false
...
hibernate.proxool.pool_alias pool1
...
hibernate.show_sql true
...
hibernate.jdbc.batch_size 0
...
hibernate.jdbc.batch_versioned_data true
...
hibernate.jdbc.use_streams_for_binary true
...
hibernate.max_fetch_depth 1
...
hibernate.cache.region_prefix hibernate.test
...
hibernate.cache.use_query_cache true
...



Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
0 [Thread-1] INFO cfg.Environment - Hibernate 2.1.6
47 [Thread-1] INFO cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.connection.passwo
rd=, hibernate.c3p0.acquire_increment=2, hibernate.jdbc.batch_versioned_data=true, hibernate.query.substitutions=true 1,
false 0, yes 'Y', no 'N', hibernate.cache.region_prefix=hibernate.test, hibernate.c3p0.idle_test_period=3000, hibernate
.show_sql=true, hibernate.proxool.pool_alias=pool1, hibernate.c3p0.max_statements=100, hibernate.jdbc.batch_size=0, hibe
rnate.c3p0.validate=false, hibernate.c3p0.timeout=5000, hibernate.cache.use_query_cache=true, hibernate.max_fetch_depth=
1, hibernate.jdbc.use_streams_for_binary=true, hibernate.c3p0.min_size=2, hibernate.connection.pool_size=1, hibernate.co
nnection.username=sa, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cache.provider_class=net.sf.hib
ernate.cache.EhCacheProvider, hibernate.c3p0.max_size=2, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialec
t=net.sf.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:receptidb}
63 [Thread-1] INFO cfg.Environment - using java.io streams to persist binary types
63 [Thread-1] INFO cfg.Environment - using CGLIB reflection optimizer
94 [Thread-1] INFO cfg.Configuration - Mapping resource: com/jan/dz/recepti/common/Dodela.hbm.xml
594 [Thread-1] INFO cfg.Binder - Mapping class: com.jan.dz.recepti.common.Dodela -> dodela
672 [Thread-1] INFO cfg.Configuration - Mapping resource: com/jan/dz/recepti/common/Razduzenje.hbm.xml
703 [Thread-1] INFO cfg.Binder - Mapping class: com.jan.dz.recepti.common.Razduzenje -> razduzenje
719 [Thread-1] INFO cfg.Configuration - Mapping resource: com/jan/dz/recepti/common/Zaduzenje.hbm.xml
766 [Thread-1] INFO cfg.Binder - Mapping class: com.jan.dz.recepti.common.Zaduzenje -> zaduzenje
766 [Thread-1] INFO cfg.Configuration - Mapping resource: com/jan/dz/recepti/common/PrimalacRecepata.hbm.xml
797 [Thread-1] INFO cfg.Binder - Mapping class: com.jan.dz.recepti.common.PrimalacRecepata -> primalac
828 [Thread-1] INFO cfg.Binder - Mapping subclass: com.jan.dz.recepti.common.Doktor -> primalac
828 [Thread-1] INFO cfg.Binder - Mapping subclass: com.jan.dz.recepti.common.Stanica -> primalac
828 [Thread-1] INFO cfg.Configuration - processing one-to-many association mappings
828 [Thread-1] INFO cfg.Configuration - processing one-to-one association property references
828 [Thread-1] INFO cfg.Configuration - processing foreign key constraints
859 [Thread-1] INFO dialect.Dialect - Using dialect: net.sf.hibernate.dialect.HSQLDialect
859 [Thread-1] INFO cfg.SettingsFactory - Maximim outer join fetch depth: 1
859 [Thread-1] INFO cfg.SettingsFactory - Use outer join fetching: true
859 [Thread-1] INFO connection.C3P0ConnectionProvider - C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:re
ceptidb
859 [Thread-1] INFO connection.C3P0ConnectionProvider - Connection properties: {user=sa, password=}
906 [Thread-1] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA enviro
nment, use of process level read-write cache is not recommended)
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@13e0aba [ connectionPoolDataSource -> com.mchange.v2.
c3p0.WrapperConnectionPoolDataSource@18352d8 [ acquireIncrement -> 2, autoCommitOnClose -> false, connectionTesterClassN
ame -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions
-> false, idleConnectionTestPeriod -> 3000, initialPoolSize -> 2, maxIdleTime -> 5000, maxPoolSize -> 2, maxStatements
-> 100, minPoolSize -> 2, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@3257b8 [ description -> null,
driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:receptidb, properties -> {user=sa, password=}
] , propertyCycle -> 300, testConnectionOnCheckout -> false ] , factoryClassLocation -> null, numHelperThreads -> 3 ]
java.sql.SQLException: Wrong database file version
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.check(Trace.java:276)
at org.hsqldb.Trace.check(Trace.java:260)
at org.hsqldb.Log.open(Log.java:185)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:
76)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:66)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
at com.mchange.v2.resourcepool.BasicResourcePool.access$000(BasicResourcePool.java:35)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:972)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)
java.sql.SQLException: Wrong database file version
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.check(Trace.java:276)
at org.hsqldb.Trace.check(Trace.java:260)
at org.hsqldb.Log.open(Log.java:185)
at org.hsqldb.Database.<init>(Database.java:96)
at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:66)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:
76)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:66)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:787)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:548)
at com.mchange.v2.resourcepool.BasicResourcePool.access$000(BasicResourcePool.java:35)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:972)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:148)


Name and version of the database you are using:HSQLDB

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Actually, problem was that I had two hsqldb.jar files. Eclipse used correct version and from command line older version was used. I just didn't noticed that I had two versions of the same database.