I am getting the following exception: "cannot instantiate QueryTranslatorFactory".

I have got this exception working throught the tutorial (in the reference guide using the recommended hsqldb) as well as attempting to get Hibernate to work on my application using MySQL.

I have checked that the classes are correctly deployed and cannot find any other reference to this kind of problem in hte API or the forum questions.

Please advise what may be causing this.

I think you're missing some JARs Hibernate requires in your classpath.

My guess is that you didn't include ANTLR. It's provided with Hibernate's distribution.

Giulio

Hi Guido

Thanks for the reply.

I am building the project with ant so it should have built all the jar's. I have also extracted all the files and still am getting the same exception.

However the only antlr jar file I got with the hibernate distribution was antlr-2.7.6rc1.jar

Do you know if this is OK or how to go about checking it?

Thanks again

Fernando

Check that these JARs are in your CLASSPATH when executing Hibernate examples / test cases :

antlr*.jar
cglib*.jar
asm.jar
asm-attrs.jar
commons-collections.jar
commons-logging.jar
hibernate3.jar
jta.jar
dom4j.jar
log4j.jar

These are the minimal JARs required, as stated in Hibernate reference doc.

Your version of ANTLR is ok.

Can you post the full exception stack trace ?

You should also set log debug level in log4j for org.hibernate to DEBUG.

Hi Giulio (apologies about the previous mis-spelling)

I have got all the correct jars as per your list in the CLASSPATH.

The log and stack trace are as follows:

11:20:43,473 INFO Environment:479 - Hibernate 3.1
11:20:43,483 INFO Environment:494 - loaded properties from resource hibernate.properties: {hibernate.order_updates=true, hibernate.default_batch_fetch_size=8, hibernate.connection.driver_class=@DRIVER_CLASS@, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=@HIBERNATE_DIALECT@, hibernate.jdbc.use_streams_for_binary=true, hibernate.query.factory_class=@QUERY_TRANSLATOR_FACTORY@, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=@DB_USERNAME@, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=@DB_URL@, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
11:20:43,493 INFO Environment:524 - using java.io streams to persist binary types
11:20:43,493 INFO Environment:525 - using CGLIB reflection optimizer
11:20:43,493 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
11:20:43,553 INFO Configuration:1286 - configuring from resource: /hibernate.cfg.xml
11:20:43,553 INFO Configuration:1263 - Configuration resource: /hibernate.cfg.xml
11:20:43,803 INFO Configuration:468 - Reading mappings from resource: Event.hbm.xml
11:20:43,934 INFO HbmBinder:265 - Mapping class: hibernate_eg.Event -> EVENTS
11:20:43,954 INFO HbmBinder:1332 - Mapping collection: hibernate_eg.Event.participants -> PERSON_EVENT
11:20:43,964 INFO Configuration:468 - Reading mappings from resource: Person.hbm.xml
11:20:44,014 INFO HbmBinder:265 - Mapping class: hibernate_eg.Person -> PERSON
11:20:44,014 INFO HbmBinder:1332 - Mapping collection: hibernate_eg.Person.events -> PERSON_EVENT
11:20:44,014 INFO HbmBinder:1332 - Mapping collection: hibernate_eg.Person.emailAddresses -> PERSON_EMAIL_ADDR
11:20:44,014 INFO Configuration:1397 - Configured SessionFactory: null
11:20:44,024 INFO Configuration:1022 - processing extends queue
11:20:44,024 INFO Configuration:1026 - processing collection mappings
11:20:44,094 INFO Configuration:1035 - processing association property references
11:20:44,094 INFO Configuration:1057 - processing foreign key constraints
11:20:44,094 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
11:20:44,094 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
11:20:44,104 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
11:20:44,104 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
11:20:44,104 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
11:20:44,244 INFO SettingsFactory:77 - RDBMS: HSQL Database Engine, version: 1.8.0
11:20:44,244 INFO SettingsFactory:78 - JDBC driver: HSQL Database Engine Driver, version: 1.8.0
11:20:44,254 INFO Dialect:103 - Using dialect: org.hibernate.dialect.HSQLDialect
11:20:44,274 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
11:20:44,274 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
11:20:44,274 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
11:20:44,274 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
11:20:44,274 INFO SettingsFactory:136 - JDBC batch size: 15
11:20:44,274 INFO SettingsFactory:139 - JDBC batch updates for versioned data: enabled
11:20:44,284 INFO SettingsFactory:144 - Scrollable result sets: enabled
11:20:44,284 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
11:20:44,284 INFO SettingsFactory:160 - Connection release mode: auto
11:20:44,284 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
11:20:44,284 INFO SettingsFactory:187 - Default batch fetch size: 8
11:20:44,284 INFO SettingsFactory:191 - Generate SQL with comments: disabled
11:20:44,284 INFO SettingsFactory:195 - Order SQL updates by primary key: enabled
11:20:44,284 INFO SettingsFactory:338 - Query translator: @QUERY_TRANSLATOR_FACTORY@
XXXXX FDN XXXInitial SessionFactory creation failed.org.hibernate.HibernateException: could not instantiate QueryTranslatorFactory: @QUERY_TRANSLATOR_FACTORY@
Exception in thread "main" java.lang.NullPointerException
at peacBudget.Password.savePasswordObject(Password.java:109)
at peacBudget.TestCustomer.<init>(TestCustomer.java:27)
at peacBudget.TestCustomer.main(TestCustomer.java:33)

Process completed.

Cheers

Fernando

Unless you put @QUERY_TRANSLATOR_FACTORY@ manually, you are using a configuration template which requires parameter substitution of some sort.

Actually it looks that Hibernate is trying to instantiate the class "@QUERY_TRANSLATOR_FACTORY" which of course doesn't exist.

Show me hibernate.cfg.xml.

If that's the problem, you must check all parameters delimited with @*@.

Giulio

Hi Giulio

Apologies about the delay in getting back to you as I did not get notice that you had posted a reply.

I enclose hte config and properties files. The only refernece ot the @QUERY_TRANSLATOR_FACTORY@ was in hte properties file (hence I am attaching the file) but it seems to be a normal set-up.

#############Properties file
##########################################
##########################################
##########################################
##########################################
##########################################


######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'


## Query translator factory class

hibernate.query.factory_class @QUERY_TRANSLATOR_FACTORY@


#################
### Platforms ###
#################

hibernate.dialect @HIBERNATE_DIALECT@
hibernate.connection.driver_class @DRIVER_CLASS@
hibernate.connection.username @DB_USERNAME@
hibernate.connection.password @DB_PASSWORD@
hibernate.connection.url @DB_URL@

## JNDI Datasource

#hibernate.connection.datasource jdbc/test
#hibernate.connection.username db2
#hibernate.connection.password db2


## HypersonicSQL

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


## MySQL


#hibernate.dialect org.hibernate.dialect.MySQLDialect
#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
#hibernate.connection.driver_class org.gjt.mm.mysql.Driver
#hibernate.connection.driver_class com.mysql.jdbc.Driver
#hibernate.connection.url jdbc:mysql:
#hibernate.connection.username fdn
#hibernate.connection.password fdn


## Oracle

#hibernate.dialect org.hibernate.dialect.OracleDialect
#hibernate.dialect org.hibernate.dialect.Oracle9Dialect
#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
#hibernate.connection.username ora
#hibernate.connection.password ora
#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test


## PostgreSQL

#hibernate.dialect org.hibernate.dialect.PostgreSQLDialect
#hibernate.connection.driver_class org.postgresql.Driver
#hibernate.connection.url jdbc:postgresql:template1
#hibernate.connection.username pg
#hibernate.connection.password
#hibernate.query.substitutions yes 'Y', no 'N'


## DB2

#hibernate.dialect org.hibernate.dialect.DB2Dialect
#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
#hibernate.connection.url jdbc:db2:test
#hibernate.connection.username db2
#hibernate.connection.password db2

## TimesTen (not supported yet)

#hibernate.dialect org.hibernate.dialect.TimesTenDialect
#hibernate.connection.driver_class com.timesten.jdbc.TimesTenDriver
#hibernate.connection.url jdbc:timesten:direct:test
#hibernate.connection.username
#hibernate.connection.password

## DB2/400

#hibernate.dialect org.hibernate.dialect.DB2400Dialect
#hibernate.connection.username user
#hibernate.connection.password password

## Native driver
#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
#hibernate.connection.url jdbc:db2://systemname

## Toolbox driver
#hibernate.connection.driver_class com.ibm.as400.access.AS400JDBCDriver
#hibernate.connection.url jdbc:as400://systemname


## Derby (Not supported!)

#hibernate.dialect org.hibernate.dialect.DerbyDialect
#hibernate.connection.driver_class org.apache.derby.jdbc.EmbeddedDriver
#hibernate.connection.username
#hibernate.connection.password
#hibernate.connection.url jdbc:derby:/test;create=true


## Sybase

#hibernate.dialect org.hibernate.dialect.SybaseDialect
#hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver
#hibernate.connection.username sa
#hibernate.connection.password sasasa
#hibernate.connection.url jdbc:sybase:Tds:co3061835-a:5000/tempdb


## Mckoi SQL

#hibernate.dialect org.hibernate.dialect.MckoiDialect
#hibernate.connection.driver_class com.mckoi.JDBCDriver
#hibernate.connection.url jdbc:mckoi:///
#hibernate.connection.url jdbc:mckoi:local://C:/mckoi1.00/db.conf
#hibernate.connection.username admin
#hibernate.connection.password nimda


## SAP DB

#hibernate.dialect org.hibernate.dialect.SAPDBDialect
#hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB
#hibernate.connection.url jdbc:sapdb://localhost/TST
#hibernate.connection.username TEST
#hibernate.connection.password TEST
#hibernate.query.substitutions yes 'Y', no 'N'


## MS SQL Server

#hibernate.dialect org.hibernate.dialect.SQLServerDialect
#hibernate.connection.username sa
#hibernate.connection.password sa

## JSQL Driver
#hibernate.connection.driver_class com.jnetdirect.jsql.JSQLDriver
#hibernate.connection.url jdbc:JSQLConnect://1E1/test

## JTURBO Driver
#hibernate.connection.driver_class com.newatlanta.jturbo.driver.Driver
#hibernate.connection.url jdbc:JTurbo://1E1:1433/test

## WebLogic Driver
#hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver
#hibernate.connection.url jdbc:weblogic:mssqlserver4:1E1:1433

## Microsoft Driver (not recommended!)
#hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver
#hibernate.connection.url jdbc:microsoft:sqlserver://1E1;DatabaseName=test;SelectMethod=cursor

## jTDS (since version 0.9)
#hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
#hibernate.connection.url jdbc:jtds:sqlserver://1E1/test

## Interbase

#hibernate.dialect org.hibernate.dialect.InterbaseDialect
#hibernate.connection.username sysdba
#hibernate.connection.password masterkey

## DO NOT specify hibernate.connection.sqlDialect

## InterClient

#hibernate.connection.driver_class interbase.interclient.Driver
#hibernate.connection.url jdbc:interbase://localhost:3060/C:/firebird/test.gdb

## Pure Java

#hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver
#hibernate.connection.url jdbc:firebirdsql:localhost/3050:/firebird/test.gdb


## Pointbase

#hibernate.dialect org.hibernate.dialect.PointbaseDialect
#hibernate.connection.driver_class com.pointbase.jdbc.jdbcUniversalDriver
#hibernate.connection.url jdbc:pointbase:embedded:sample
#hibernate.connection.username PBPUBLIC
#hibernate.connection.password PBPUBLIC


## Ingres

#hibernate.dialect org.hibernate.dialect.IngresDialect
#hibernate.connection.driver_class ca.edbc.jdbc.EdbcDriver
#hibernate.connection.url jdbc:edbc://localhost:II7/database
#hibernate.connection.username user
#hibernate.connection.password password


## Mimer SQL

#hibernate.dialect org.hibernate.dialect.MimerSQLDialect
#hibernate.connection.driver_class com.mimer.jdbc.Driver
#hibernate.connection.url jdbc:mimer:multi1
#hibernate.connection.username hibernate
#hibernate.connection.password hibernate



#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

#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



##############################
### Proxool Connection Pool###
##############################

## Properties for external configuration of Proxool

hibernate.proxool.pool_alias pool1

## Only need one of the following

#hibernate.proxool.existing_pool true
#hibernate.proxool.xml proxool.xml
#hibernate.proxool.properties proxool.properties



#################################
### Plugin ConnectionProvider ###
#################################

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)

#hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DBCPConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.ProxoolConnectionProvider



#######################
### Transaction API ###
#######################

## Enable automatic flush during the JTA beforeCompletion() callback
## (This setting is relevant with or without the Transaction API)

#hibernate.transaction.flush_before_completion


## Enable automatic session close at the end of transaction
## (This setting is relevant with or without the Transaction API)

#hibernate.transaction.auto_close_session


## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory


## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction
## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class

#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction


## to use the second-level cache with JTA, Hibernate must be able to obtain the JTA TransactionManager

#hibernate.transaction.manager_lookup_class org.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.ResinTransactionManagerLookup



##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

#hibernate.show_sql true


## add comments to the generated SQL

#hibernate.use_sql_comments true


## generate statistics

#hibernate.generate_statistics true


## auto schema export

#hibernate.hbm2ddl.auto create-drop
#hibernate.hbm2ddl.auto create
#hibernate.hbm2ddl.auto update


## specify a default schema and catalog for unqualified tablenames

#hibernate.default_schema test
#hibernate.default_catalog test


## enable ordering of SQL UPDATEs by primary key

hibernate.order_updates true


## set the maximum depth of the outer join fetch tree

hibernate.max_fetch_depth 1


## set the default batch size for batch fetching

hibernate.default_batch_fetch_size 8


## rollback generated identifier values of deleted entities to default values

#hibernate.use_identifer_rollback true


## enable CGLIB reflection optimizer (enabled by default)

#hibernate.cglib.use_reflection_optimizer false



#####################
### JDBC Settings ###
#####################

## specify a JDBC isolation level

#hibernate.connection.isolation 4


## enable JDBC autocommit (not recommended!)

#hibernate.connection.autocommit true


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

#hibernate.jdbc.batch_size 5


## enable batch updates even for versioned data

hibernate.jdbc.batch_versioned_data true


## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true


## use JDBC 3 PreparedStatement.getGeneratedKeys() to get the identifier of an inserted row

#hibernate.jdbc.use_get_generated_keys false


## choose a custom JDBC batcher

# hibernate.jdbc.factory_class


## choose a custom SQL exception converter

#hibernate.jdbc.sql_exception_converter



##########################
### Second-level Cache ###
##########################

## optimize chache for minimal "puts" instead of minimal "gets" (good for clustered cache)

#hibernate.cache.use_minimal_puts true


## set a prefix for cache region names

hibernate.cache.region_prefix hibernate.test


## disable the second-level cache

#hibernate.cache.use_second_level_cache false


## enable the query cache

#hibernate.cache.use_query_cache true


## store the second-level cache entries in a more human-friendly format

#hibernate.cache.use_structured_entries true


## choose a cache implementation

#hibernate.cache.provider_class org.hibernate.cache.EhCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.EmptyCacheProvider
hibernate.cache.provider_class org.hibernate.cache.HashtableCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.TreeCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.OSCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.SwarmCacheProvider


## choose a custom query cache implementation

#hibernate.cache.query_cache_factory



############
### JNDI ###
############

## specify a JNDI name for the SessionFactory

#hibernate.session_factory_name hibernate/session_factory


## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction;
## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which
## is the best approach in an application server

#file system
#hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory
#hibernate.jndi.url file:/

#WebSphere
#hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory
#hibernate.jndi.url iiop://localhost:900/

#############config file
##########################################
##########################################
##########################################
##########################################

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<!-- Database connection settings -->
<property name="connection.driver_class">org/gjt/mm/mysql.Driver</property>
<property name="connection.url">jdbc:mysql://localhost</property>
<property name="connection.username">fdn</property>
<property name="connection.password">fdn</property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>

<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>


<!-- <property name="hbm2ddl.auto">create</property>
-->
<mapping resource="UserAndAccessPackage.hbm.xml"/>
<!-- <mapping resource=".hbm.xml"/>
-->

</session-factory>

</hibernate-configuration>






###I found the code in the Settings.Java line338 as follows:
##########################################
##########################################
##########################################
##########################################
protected QueryTranslatorFactory createQueryTranslatorFactory(Properties properties) {
String className = PropertiesHelper.getString(
Environment.QUERY_TRANSLATOR, properties, "org.hibernate.hql.ast.ASTQueryTranslatorFactory"
);

log.info("Query translator: " + className);
try {
return (QueryTranslatorFactory) ReflectHelper.classForName(className).newInstance();
}
catch (Exception cnfe) {
throw new HibernateException("could not instantiate QueryTranslatorFactory: " + className, cnfe);
}
}

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

Unfortunately all this seems to be standard yet my problem cannot be a bug as it appears too common. I am at my wits end.

Cheers

Fernando

Hi Fernando,

i'm quite sure those values are meant to be substituted.

You see that even if @QUERY... was commented out, you didn't specify any value for the dialect and so on.

The only way this properties file can work is by being processed by some task (like Ant) which substitutes to those @@ values the real values.

Try to manually substitute the values now.

Put your dialect class, JDBC values (driver class, user name pwd and url for the database) and comment out the QUERY_TRANSLATOR_FACTORY line with a # - so it will use the default value.


Giulio

Hi Giulio

Apologies about the delay in reply as I was involved in another project.

Thanks, you were correct and I have got my applivation going using HSQL.

I am getting an error on Mysql saying that I amusing the wrong Driver class but it works OK on my other applications. I am waiting for a reply from the Mysql guys.

Many thanks for your assistance.

Initially I saw how to terminate the topic and give an evaluation but it seems to have disappeared for now. Can you guide on this?

Cheers

Fernando

Hi Fernando,

glad you solved your problem.

To give credit for posts you feel helped solve your problem, use the link you find at the bottom of each post in your topic, and choose "Yes" where it says "... helped solve your problem?"


Regards,

Giulio