Hi all,
I am trying to install the last version of BASE, the 2.9.3. When I run
initdb.sh, I get this error:
ERROR [main] (Application.java:571) - Exception when starting...
net.sf.basedb.core.BaseException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData
item
WHERE NOT item.systemId IS NULL]
(details in the attached command output. I can send the whole log in
case it's needed).
I tried to pass this to the java command:
-Dhibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory
but apparently it is ignored. Does anyone have any idea on how to fix it?
Thanks in advance.
Marco.
INFO [main] (ConnectionProviderFactory.java:95) - Initializing
connection provider: org.hibernate.connection.C3P0ConnectionProvider
INFO [main] (C3P0ConnectionProvider.java:103) - C3P0 using driver:
com.mysql.jdbc.Driver at URL:
jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true
INFO [main] (C3P0ConnectionProvider.java:104) - Connection properties:
{user=base2, password=****, release_mode=after_transaction}
INFO [main] (C3P0ConnectionProvider.java:107) - autocommit mode: false
WARN [main] (C3P0ConnectionProvider.java:232) - Both hibernate-style
property 'hibernate.c3p0.max_size' and c3p0-style property
'c3p0.max_size' have been set in hibernate.properties. Hibernate-style
property 'hibernate.c3p0.max_size' will be used and c3p0-style property
'c3p0.max_size' will be ignored!
WARN [main] (C3P0ConnectionProvider.java:232) - Both hibernate-style
property 'hibernate.c3p0.min_size' and c3p0-style property
'c3p0.min_size' have been set in hibernate.properties. Hibernate-style
property 'hibernate.c3p0.min_size' will be used and c3p0-style property
'c3p0.min_size' will be ignored!
WARN [main] (C3P0ConnectionProvider.java:232) - Both hibernate-style
property 'hibernate.c3p0.timeout' and c3p0-style property 'c3p0.timeout'
have been set in hibernate.properties. Hibernate-style property
'hibernate.c3p0.timeout' will be used and c3p0-style property
'c3p0.timeout' will be ignored!
INFO [main] (AbstractPoolBackedDataSource.java:462) - Initializing
c3p0 pool... com.mchange.v2.c3p0.poolbackeddatasou...@14b29324 [
connectionPoolDataSource ->
com.mchange.v2.c3p0.wrapperconnectionpooldatasou...@a1a5e7e8 [
acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay ->
1000, autoCommitOnClose -> false, automaticTestTable -> null,
breakAfterAcquireFailure -> false, checkoutTimeout -> 0,
connectionCustomizerClassName -> null, connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
debugUnreturnedConnectionStackTraces -> false, factoryClassLocation ->
null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
hd590u7z18fnsz218eblcc|1988d36, idleConnectionTestPeriod -> 0,
initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge
-> 0, maxIdleTime -> 3600, maxIdleTimeExcessConnections -> 0,
maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0,
minPoolSize -> 1, nestedDataSource ->
com.mchange.v2.c3p0.drivermanagerdatasou...@529deeab [ description ->
null, driverClass -> null, factoryClassLocation -> null, identityToken
-> hd590u7z18fnsz218eblcc|1fa157c, jdbcUrl ->
jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true,
properties -> {user=******, password=******,
release_mode=after_transaction} ], preferredTestQuery -> null,
propertyCycle -> 0, testConnectionOnCheckin -> false,
testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0,
usesTraditionalReflectiveProxies -> false; userOverrides: {} ],
dataSourceName -> null, factoryClassLocation -> null, identityToken ->
hd590u7z18fnsz218eblcc|5f0e7d, numHelperThreads -> 3 ]
INFO [main] (SettingsFactory.java:116) - RDBMS: MySQL, version: 5.0.58
INFO [main] (SettingsFactory.java:117) - JDBC driver: MySQL-AB JDBC
Driver, version: mysql-connector-java-5.0.7 ( $Date: 2007-03-09 22:13:57
+0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
INFO [main] (Dialect.java:175) - Using dialect:
org.hibernate.dialect.MySQLInnoDBDialect
INFO [main] (TransactionFactoryFactory.java:59) - Using default
transaction strategy (direct JDBC transactions)
INFO [main] (TransactionManagerLookupFactory.java:80) - No
TransactionManagerLookup configured (in JTA environment, use of
read-write or transactional second-level cache is not recommended)
INFO [main] (SettingsFactory.java:170) - Automatic flush during
beforeCompletion(): disabled
INFO [main] (SettingsFactory.java:174) - Automatic session close at
end of transaction: disabled
INFO [main] (SettingsFactory.java:189) - Scrollable result sets: enabled
INFO [main] (SettingsFactory.java:197) - JDBC3 getGeneratedKeys(): enabled
INFO [main] (SettingsFactory.java:205) - Connection release mode:
after_transaction
INFO [main] (SettingsFactory.java:229) - Maximum outer join fetch depth: 2
INFO [main] (SettingsFactory.java:232) - Default batch fetch size: 1
INFO [main] (SettingsFactory.java:236) - Generate SQL with comments:
disabled
INFO [main] (SettingsFactory.java:240) - Order SQL updates by primary
key: disabled
INFO [main] (SettingsFactory.java:244) - Order SQL inserts for
batching: disabled
INFO [main] (SettingsFactory.java:420) - Query translator:
org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO [main] (ASTQueryTranslatorFactory.java:47) - Using
ASTQueryTranslatorFactory
INFO [main] (SettingsFactory.java:252) - Query language substitutions: {}
INFO [main] (SettingsFactory.java:257) - JPA-QL strict compliance:
disabled
INFO [main] (SettingsFactory.java:262) - Second-level cache: enabled
INFO [main] (SettingsFactory.java:266) - Query cache: enabled
INFO [main] (SettingsFactory.java:405) - Cache region factory :
org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
INFO [main] (RegionFactoryCacheProviderBridge.java:61) - Cache
provider: org.hibernate.cache.EhCacheProvider
INFO [main] (SettingsFactory.java:276) - Optimize cache for minimal
puts: disabled
INFO [main] (SettingsFactory.java:285) - Structured second-level cache
entries: disabled
INFO [main] (SettingsFactory.java:384) - Query cache factory:
org.hibernate.cache.StandardQueryCacheFactory
INFO [main] (SettingsFactory.java:314) - Statistics: disabled
INFO [main] (SettingsFactory.java:318) - Deleted entity synthetic
identifier rollback: disabled
INFO [main] (SettingsFactory.java:333) - Default entity-mode: pojo
INFO [main] (SettingsFactory.java:337) - Named query checking : enabled
INFO [main] (SessionFactoryImpl.java:187) - building session factory
INFO [main] (SessionFactoryObjectFactory.java:105) - Not binding
factory to JNDI, no JNDI name configured
INFO [main] (UpdateTimestampsCache.java:57) - starting update
timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
WARN [main] (EhCacheProvider.java:93) - Could not find configuration
[org.hibernate.cache.UpdateTimestampsCache]; using defaults.
INFO [main] (StandardQueryCache.java:75) - starting query cache at
region: org.hibernate.cache.StandardQueryCache
WARN [main] (EhCacheProvider.java:93) - Could not find configuration
[org.hibernate.cache.StandardQueryCache]; using defaults.
INFO [main] (PredefinedQuery.java:109) - Loaded predefined queries
from file: /common-queries.xml
INFO [main] (PredefinedQuery.java:113) - Loaded predefined queries
from file: /mysql-queries.xml
ERROR [main] (Application.java:571) - Exception when starting...
net.sf.basedb.core.BaseException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
at net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1460)
at
net.sf.basedb.core.HibernateUtil.getPredefinedQuery(HibernateUtil.java:1635)
at
net.sf.basedb.core.HibernateUtil.getPredefinedQuery(HibernateUtil.java:1621)
at net.sf.basedb.core.SystemItems.init(SystemItems.java:76)
at net.sf.basedb.core.Application.start(Application.java:491)
at net.sf.basedb.core.Install.initDatabase(Install.java:180)
at net.sf.basedb.install.InitDB.main(InitDB.java:74)
Caused by: org.hibernate.QueryException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:80)
at antlr.CharScanner.setTokenObjectClass(CharScanner.java:340)
at org.hibernate.hql.ast.HqlLexer.setTokenObjectClass(HqlLexer.java:54)
at antlr.CharScanner.<init>(CharScanner.java:51)
at antlr.CharScanner.<init>(CharScanner.java:60)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:56)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:53)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:50)
at org.hibernate.hql.ast.HqlLexer.<init>(HqlLexer.java:49)
at org.hibernate.hql.ast.HqlParser.getInstance(HqlParser.java:67)
at
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:265)
at
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:180)
at
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
at net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1456)
... 6 more
INFO [main] (Application.java:590) - Stopping BASE
INFO [main] (SessionFactoryImpl.java:805) - closing
INFO [main] (Application.java:612) - BASE has been stopped
Database initialisation failed: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
net.sf.basedb.core.BaseException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
at net.sf.basedb.core.Application.start(Application.java:574)
at net.sf.basedb.core.Install.initDatabase(Install.java:180)
at net.sf.basedb.install.InitDB.main(InitDB.java:74)
Caused by: net.sf.basedb.core.BaseException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
at net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1460)
at
net.sf.basedb.core.HibernateUtil.getPredefinedQuery(HibernateUtil.java:1635)
at
net.sf.basedb.core.HibernateUtil.getPredefinedQuery(HibernateUtil.java:1621)
at net.sf.basedb.core.SystemItems.init(SystemItems.java:76)
at net.sf.basedb.core.Application.start(Application.java:491)
... 2 more
Caused by: org.hibernate.QueryException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [SELECT item.id, item.systemId
FROM net.sf.basedb.core.data.HardwareTypeData item
WHERE NOT item.systemId IS NULL]
at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:80)
at antlr.CharScanner.setTokenObjectClass(CharScanner.java:340)
at org.hibernate.hql.ast.HqlLexer.setTokenObjectClass(HqlLexer.java:54)
at antlr.CharScanner.<init>(CharScanner.java:51)
at antlr.CharScanner.<init>(CharScanner.java:60)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:56)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:53)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:50)
at org.hibernate.hql.ast.HqlLexer.<init>(HqlLexer.java:49)
at org.hibernate.hql.ast.HqlParser.getInstance(HqlParser.java:67)
at
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:265)
at
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:180)
at
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
at net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1456)
... 6 more
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
The BASE general discussion mailing list
[email protected]
unsubscribe: send a mail with subject "unsubscribe" to
[email protected]