How to query?

[Siegfried Heintze]

I'm working on making an example work using spring and hiberate as inspired by "Spring IN Action" 2nd ed page 189.

I have schema generation working and a call to essionFactory.getCurrentSession().saveOrUpdate(emp) working.

Now I would like to retrieve the one employee object I have successfully saved to MySQL.

The following does not work (see stack trace below) because it dies on the find function.

@Override
public List<Employee> getEmployees() {
String name = "siegfried";
org.hibernate.classic.Session session = sessionFactory.getCurrentSession();
List<Employee> result = session.find(
"from EMPLOYEE" );
return result;

Questions:
(1) How do I fix the exception that is being thrown?
(2) I see that find is deprecated. How do I reimplement this with the new functions?
Thanks,
Siegfried

begin
Dec 28, 2007 1:31:58 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@1d225a7: display name [org.springframework.context.support.ClassPathXmlApplicationContext@1d225a7]; startup date [Fri Dec 28 13:31:58 MST 2007]; root of context hierarchy
Dec 28, 2007 1:31:58 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [hiberDemoConfig.xml]
Dec 28, 2007 1:31:58 PM org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory
INFO: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@1d225a7]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1f1680f
Dec 28, 2007 1:31:58 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
INFO: Loading properties file from class path resource [hiberMySQL.properties]
Dec 28, 2007 1:31:58 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1f1680f: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,sessionFactory,transactionManager,EmployeeHiberDao]; root of factory hierarchy
Dec 28, 2007 1:31:58 PM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
Dec 28, 2007 1:31:58 PM org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.0.GA
Dec 28, 2007 1:31:58 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Dec 28, 2007 1:31:58 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Dec 28, 2007 1:31:58 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Dec 28, 2007 1:31:58 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Dec 28, 2007 1:31:58 PM org.springframework.orm.hibernate3.LocalSessionFactoryBean buildSessionFactory
INFO: Building new Hibernate SessionFactory
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: com.SIGNITEK.spring.demo.domain.Employee
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity com.SIGNITEK.spring.demo.domain.Employee on table Employee
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Dec 28, 2007 1:31:59 PM org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
INFO: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.10a-beta-nt
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: 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 $ )
Dec 28, 2007 1:31:59 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect
Dec 28, 2007 1:31:59 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
Dec 28, 2007 1:31:59 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: on_close
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Dec 28, 2007 1:31:59 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Dec 28, 2007 1:31:59 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Dec 28, 2007 1:31:59 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Dec 28, 2007 1:31:59 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Dec 28, 2007 1:31:59 PM org.springframework.orm.hibernate3.HibernateTransactionManager afterPropertiesSet
INFO: Using DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@98f352] of Hibernate SessionFactory for HibernateTransactionManager
Dec 28, 2007 1:32:00 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect
Dec 28, 2007 1:32:00 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: com.SIGNITEK.spring.demo.domain.Employee
Dec 28, 2007 1:32:00 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity com.SIGNITEK.spring.demo.domain.Employee on table Employee
Dec 28, 2007 1:32:00 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Dec 28, 2007 1:32:00 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Dec 28, 2007 1:32:00 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: Running hbm2ddl schema export
Dec 28, 2007 1:32:00 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: exporting generated schema to database
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/JunkDB
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=auser, password=****}
drop table if exists Employee
create table Employee (id integer not null auto_increment, extension varchar(255), firstName varchar(255), homePhone varchar(255), lastName varchar(255), primary key (id))
Dec 28, 2007 1:32:00 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: schema export complete
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider close
INFO: cleaning up connection pool: jdbc:mysql://localhost:3306/JunkDB
Dec 28, 2007 1:32:00 PM org.hibernate.connection.DriverManagerConnectionProvider close
INFO: cleaning up connection pool: jdbc:mysql://localhost:3306/JunkDB
Exception in thread "main" java.lang.reflect.UndeclaredThrowableException
at $Proxy7.find(Unknown Source)
at com.SIGNITEK.spring.demo.hibernate.ContextSessionDao.getEmployees(ContextSessionDao.java:57)
at com.SIGNITEK.spring.demo.hibernate.ContextSessionDao.println(ContextSessionDao.java:64)
at com.SIGNITEK.spring.demo.hibernate.MainHiberDemo.<init>(MainHiberDemo.java:76)
at com.SIGNITEK.spring.demo.hibernate.MainHiberDemo.main(MainHiberDemo.java:83)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
... 5 more
Caused by: java.lang.NoClassDefFoundError: antlr/ANTLRException
at org.hibernate.hql.ast.ASTQueryTranslatorFactory.createQueryTranslator(ASTQueryTranslatorFactory.java:35)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:74)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1113)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:1098)
... 10 more
 

[Siegfried Heintze]

I did some google searching and found this. However, it seems to generate the same error. Is createQuery the preferred approach?

Thanks,
Siegfried

  public List<Employee> getEmployees() {
String name = "siegfried";
org.hibernate.classic.Session session = sessionFactory.getCurrentSession();
List<Employee> result;// = session.find("from EMPLOYEE" );
result = session.createQuery("FROM employee").list();
return result;
  

[Walter Bernstein]

Caused by: java.lang.NoClassDefFoundError: antlr/ANTLRException

=> ANTLR jar is missing