QuerySyntaxException (table is not mapped)

[Gabriela Rios]

Hi,

I'm getting this error and I don't know why. Could someone please take a look at it?

Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: Contact is not mapped [from Contact c]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:322)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
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:124)
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:1770)
at com.sys.power.dao.hibernate.ContactDaoImpl.findAll(ContactDaoImpl.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy9.findAll(Unknown Source)
at com.sys.power.SpringHibernateSample.main(SpringHibernateSample.java:28)

This is my app-context.xml: I use H2 as my datasource.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx" 
	xmlns:jdbc="http://www.springframework.org/schema/jdbc"
	xsi:schemaLocation="
		http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">

	<!-- Declare database with embedded database using H2 -->
	<jdbc:embedded-database id="dataSource" type="H2">
		<jdbc:script location="classpath:META-INF/sql/schema.sql"/>
		<jdbc:script location="classpath:META-INF/sql/test-data.sql"/>
	</jdbc:embedded-database>
	
	<!-- Hibernate session factory requires a transaction manager for transactional data access. 
	By default, Spring will look up the bean with the name transactionManager within its ApplicationContext -->
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"/>
	</bean>
	
	<tx:annotation-driven/>
	<!--  Scan components under the package com.sys.power -->
	<context:component-scan base-package="com.sys.power" />
	
	<!-- SessionFactory bean -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<!-- Inject data source bean into the session factory -->
		<property name="dataSource" ref="dataSource"/>
		<!-- Scan for the domain objects with the ORM annotation -->
		<property name="packagesToScan" value="com.sys.power.domain"/>
		<!-- Provides configuration details for hibernate -->
		<property name="hibernateProperties">
			<props>
				<!-- database dialect MySQLDialect, PostgreSQLDialect, Oracle10gDialect -->
				<prop key="hibernate.dialect">org.hibernate.dialect.H2Dialect</prop>
				<!-- Declares the depth for outer joins when mapping objects have associations with other mapped objects -->
				<prop key="hibernate.max_fetch_depth">3</prop>
				<!-- The number of records from the JDBC result set that Hibernate should use to retrieve the records for each fetch -->
				<prop key="hibernate.jdbc.fetch_size">50</prop>
				<!-- Number of update operations that should be grouped together into a batch -->
				<prop key="hibernate.jdbc.batch_size">10</prop>
				<!-- if hibernate should output the sql queries to the log or console -->
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>
</beans>

CREATE TABLE contact (
ID int(11) NOT NULL AUTO_INCREMENT,
FIRST_NAME varchar(60) NOT NULL,
LAST_NAME varchar(40) NOT NULL,
BIRTH_DATE date,
VERSION int(11) NOT NULL DEFAULT '0',
UNIQUE KEY UQ_CONTACT_1 (FIRST_NAME,LAST_NAME),
PRIMARY KEY (ID)
);

That seems to work fine:

2012-06-06 14:50:42,559 INFO [org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory] - <Creating embedded database 'dataSource'>
2012-06-06 14:50:42,699 INFO [org.springframework.jdbc.datasource.init.ResourceDatabasePopulator] - <Executing SQL script from class path resource [META-INF/sql/schema.sql]>
2012-06-06 14:50:42,750 INFO [org.springframework.jdbc.datasource.init.ResourceDatabasePopulator] - <Done executing SQL script from class path resource [META-INF/sql/schema.sql] in 51 ms.>
2012-06-06 14:50:42,750 INFO [org.springframework.jdbc.datasource.init.ResourceDatabasePopulator] - <Executing SQL script from class path resource [META-INF/sql/test-data.sql]>
2012-06-06 14:50:42,760 INFO [org.springframework.jdbc.datasource.init.ResourceDatabasePopulator] - <Done executing SQL script from class path resource [META-INF/sql/test-data.sql] in 10 ms.>

This is Contact:

/**
 * 
 */
package com.sys.power.domain;

import static javax.persistence.GenerationType.IDENTITY;

import java.io.Serializable;
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.*;

@Entity
@Table(name="contact")
public class Contact implements Serializable {
	private long id;
	private int version;
	private String firstName;
	private String lastName;
	private Date birthDate;
	private Set<ContactTelDetail> contactTelDetails = new HashSet<ContactTelDetail>();
	private Set<Hobby> hobbies = new HashSet<Hobby>();
	/**
	 * @return the id
	 */
	@Id
	@GeneratedValue(strategy = IDENTITY)
	@Column(name="ID")
	public long getId() {
		return id;
	}
	/**
	 * @param id the id to set
	 */
	public void setId(long id) {
		this.id = id;
	}
	/**
	 * @return the version
	 */
	@Version
	@Column(name="VERSION")
	public int getVersion() {
		return version;
	}
	/**
	 * @param version the version to set
	 */
	public void setVersion(int version) {
		this.version = version;
	}
	/**
	 * @return the firstName
	 */
	@Column(name="FIRST_NAME")
	public String getFirstName() {
		return firstName;
	}
	/**
	 * @param firstName the firstName to set
	 */
	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}
	/**
	 * @return the lastName
	 */
	@Column(name="LAST_NAME")
	public String getLastName() {
		return lastName;
	}
	/**
	 * @param lastName the lastName to set
	 */
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	/**
	 * @return the birthDate
	 */
	@Temporal(TemporalType.DATE)
	@Column(name="BIRTH_DATE")
	public Date getBirthDate() {
		return birthDate;
	}
	/**
	 * @param birthDate the birthDate to set
	 */
	public void setBirthDate(Date birthDate) {
		this.birthDate = birthDate;
	}
	
	public String toString() {
		return "Contact - Id: " + id + ", First Name: " + firstName
				+ ", Last Name: " + lastName + ", birthday: "
				+ birthDate;
	}
	
	@OneToMany(mappedBy="contact", cascade=CascadeType.ALL, orphanRemoval=true)
	public Set<ContactTelDetail> getContactTelDetails(){
		return this.contactTelDetails;
	}
	
	public void setContactTelDetails(Set<ContactTelDetail> contactTelDetails){
		this.contactTelDetails = contactTelDetails;
	}
	
	public void addContactTelDetails(ContactTelDetail contactTelDetail){
		contactTelDetail.setContact(this);
		getContactTelDetails().add(contactTelDetail);
	}
	
	public void removeContactTelDetail(ContactTelDetail contactTelDetail){
		getContactTelDetails().remove(contactTelDetail);
	}
	
	@ManyToMany
	@JoinTable(name="contact_hobby_detail",
		joinColumns = @JoinColumn(name="CONTACT_ID"),
		inverseJoinColumns = @JoinColumn(name="HOBBY_ID"))
	public Set<Hobby> getHobbies(){
		return this.hobbies;
	}
	
	public void setHobbies(Set<Hobby> hobbies){
		this.hobbies = hobbies;
	}
}

This is my ContactDaoImplementation

package com.m2sys.mpower.dao.hibernate;

import java.util.List;

import javax.annotation.Resource;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.SessionFactory;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.sys.power.dao.ContactDao;
import com.sys.power.domain.Contact;

@Repository("contactDao")
@Transactional
public class ContactDaoImpl implements ContactDao{
	private Log log = LogFactory.getLog(ContactDaoImpl.class);
	
	private SessionFactory sessionFactory;

	/**
	 * @return the sessionFactory
	 */
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	/**
	 * @param sessionFactory the sessionFactory to set
	 */
	@Resource(name="sessionFactory")
	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	
	@Transactional(readOnly=true)
	public List<Contact> findAll() {
		return sessionFactory.getCurrentSession().createQuery("from Contact c").list();
	}
}

This should be my object type rather than my table name.
return sessionFactory.getCurrentSession().createQuery("from Contact c").list();

My main class

package com.sys.power;

import java.util.List;

import org.springframework.context.support.GenericXmlApplicationContext;

import com.sys.power.dao.ContactDao;
import com.sys.power.domain.Contact;

public class SpringHibernateSample {
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		GenericXmlApplicationContext ctx = new GenericXmlApplicationContext();
		ctx.load("classpath:META-INF/spring/app-context.xml");
		ctx.refresh();
	
		ContactDao contactDao = ctx.getBean("contactDao", ContactDao.class);
		List<Contact> contacts = contactDao.findAll();
		listContacts(contacts);
	}

	private static void listContacts(List<Contact> contacts) {
		System.out.println("\nListing contacts without details");
		for(Contact contact: contacts){
			System.out.println(contact+"\n");
		}	
	}
}

what's wrong with my code? What am I missing? :-(

[Gabriela Rios]

I found my problem. I misspelled the package name somewhere. It seems like I just have to post here to 5 minutes later find the issue myself. I apologize. Thanks.

[William P O'Sullivan]

Was just about to ...

But thank you for commenting on the resolution.

Please mark as "resolved"

WP