I'm developing an app using Hibernate 3.5.3 and SmartGWT 2.2 (the SmartGWT doesn't really come into it here, but just for completeness) on NetBeans 6.9.

For the purposes of this exercise, I created a very simple MySQL database, with just one table, named 'users'. That table has just two columns, 'username' and 'password'.

The problem is that when I try to run any query in the HQL Query window (a window in NetBeans where you can run HQL queries - I believe a similar window exists in Eclipse), I get the result "Invalid Query." in the SQL tab and, when I execute the query, the following error in the Results tab:



It doesn't matter what the query is - I get the same result. The example above was generated by running "from Users".

I know I can actually connect to the database, because I can create the reverse engineering file (and the subsequent class).

Here's my hibernate.cfg.xml:



Here's the generated hibernate.reveng.xml:



Here's the generated Users.hbm.xml:



I've looked on all the forums I could find and not found much. Most people having a similar problem are finding it in code, not using the HQL Query window. There was some talk about Hibernate having problems with case, so I tried it changing everything to all lower case (i.e., 'users'), but that changed nothing.

Thanks in advance for any help.

I have the same problem, my OS is win7 64 bits, netbeans 6.9.1. I have reviewed a thousand times and nothing. I'm using the sample DB that comes by default ide.

error:
org.hibernate.hql.ast.QuerySyntaxException: Customer Is Not mapped [from Customer]

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="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="hibernate.connection.driver_class">org.apache.derby.jdbc.ClientDriver</property>
<property name="hibernate.connection.url">jdbc:derby://localhost:1527/sample</property>
<property name="hibernate.connection.username">app</property>
<property name="hibernate.connection.password">app</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<mapping resource="prueba2/DiscountCode.hbm.xml"/>
<mapping resource="prueba2/Customer.hbm.xml"/>
<mapping resource="prueba2/ProductCode.hbm.xml"/>
<mapping resource="prueba2/PurchaseOrder.hbm.xml"/>
<mapping resource="prueba2/Product.hbm.xml"/>
<mapping resource="prueba2/MicroMarket.hbm.xml"/>
<mapping resource="prueba2/Manufacturer.hbm.xml"/>
</session-factory>
</hibernate-configuration>

Customer.hbm.xml:

<?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">
<!-- Generated Sep 10, 2010 11:06:49 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="prueba2.Customer" schema="APP" table="CUSTOMER">
<id name="customerId" type="int">
<column name="CUSTOMER_ID"/>
<generator class="assigned"/>
</id>
<property name="discountCode" type="char">
<column length="1" name="DISCOUNT_CODE" not-null="true"/>
</property>
<property name="zip" type="string">
<column length="10" name="ZIP" not-null="true"/>
</property>
<property name="name" type="string">
<column length="30" name="NAME"/>
</property>
<property name="addressline1" type="string">
<column length="30" name="ADDRESSLINE1"/>
</property>
<property name="addressline2" type="string">
<column length="30" name="ADDRESSLINE2"/>
</property>
<property name="city" type="string">
<column length="25" name="CITY"/>
</property>
<property name="state" type="string">
<column length="2" name="STATE"/>
</property>
<property name="phone" type="string">
<column length="12" name="PHONE"/>
</property>
<property name="fax" type="string">
<column length="12" name="FAX"/>
</property>
<property name="email" type="string">
<column length="40" name="EMAIL"/>
</property>
<property name="creditLimit" type="java.lang.Integer">
<column name="CREDIT_LIMIT"/>
</property>
</class>
</hibernate-mapping>

please help us..

These are more likely due to your IDE setup problems, not hibernate itself. I would check to ensure your hibernate.cfg.xml is in your root classpath, and your mapping file is in the right classpath sub folder.

Also try write a standalone main Java client that loads the hibernate session and run your query. See manual on how to setup one. Get this working and apply it in your IDE settings.