Hibernate query not mapped

[Frank Serkland]

I have the following line of code that's not running.

Query myQuery = session.createQuery("from poll1");

I'm getting the following error message.

org.hibernate.hql.ast.QuerySyntaxError: poll1 is not mapped. [from poll1]

Here is my mapping in poll1.hbm.xml. The table is capitalized the same way, so I'm confused. Any ideas?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="">
	<class name="model.Poll1" table="poll1"
		mutable="true" polymorphism="implicit" dynamic-update="false"
		dynamic-insert="false" select-before-update="false" optimistic-lock="version">
		<id name="id" column="id">
			<generator class="native" />
		</id>
		<property name="yes" type="int" column="yes"></property>
		<property name="no" type="int" column="no"></property>
	</class>
</hibernate-mapping>

This is hibernate.cfg.xml

<?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>
		<property name="connection.url">jdbc:mysql://localhost/ghs86</property>
		<property name="connection.username">root</property>
		<property name="connection.password"></property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
		<!--
			thread is the short name for
			org.hibernate.context.ThreadLocalSessionContext and let Hibernate
			bind the session automatically to the thread
		-->
		<property name="current_session_context_class">thread</property>    <!-- this will show us all sql statements -->
		<property name="hibernate.show_sql">true</property>  <!-- mapping files -->

		<mapping resource="comment.hbm.xml" />
		<mapping resource="poll1.hbm.xml" />
	</session-factory>
</hibernate-configuration>

[Arun Kumarr]

First, I'd check if you've entered poll1 or polll.
Second, I'd see if we have can declare package definiton of the class in a separate xml attribute, like in "<hibernate-mapping package=""> and remove "model." from the name attribute.

[Frank Serkland]

Arun Kumarr wrote:First, I'd check if you've entered poll1 or polll.

I definitely have poll1, so that is correct.

Arun Kumarr wrote:Second, I'd see if we have can declare package definiton of the class in a separate xml attribute, like in "<hibernate-mapping package=""> and remove "model." from the name attribute.

I just tried that. It didn't work.

[Frank Serkland]

Frank Serkland wrote:I definitely have poll1, so that is correct

For some reason, I had to change poll1 to Poll1, I guess because my model class is capitalized. Anyway, the line that was giving me problems works now. Go figure.

[Vijitha Kumara]

Frank Serkland wrote:For some reason, I had to change poll1 to Poll1...

Same reason why you got that error... You work with Objects (Classes for that matter) in ORM so exact name should be used.