I get the following exception when trying to execute HQL from within the Hibernate Console.

java.sql.SQLException: Table 'test.public_product' doesn't exist

using the HQL "from Product p"


From within the Hibernate Console I am able to create my Session Factory and browse the loaded mapped objects fine. In addition, I can browse the DB schema from within the configuration pane.

Also, I believe the mapping files are correct, because I am able to successfully run JUnit tests which make use of my business objects and mapping files. This exception appears only when trying to execute HQL from within the console.

Why is the generated SQL trying to query the table "public_product" instead of table "product"? Why is the "public_" prefix added?

I have searched the forums for an answer, I apologize if I have missed it.

Thanks in advance for any help you can provide!

which database ?

and show your mapping if you assume they are correct ;)

My mapping file is found below. I am using MySQL 3.23, an older version but should still be fine.


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.yokel.db.Product" table="product">
<id name="id" type="long" unsaved-value="null" column="product_id">
<generator class="identity"/>
</id>

<property name="model" column="model" length="50" />
<property name="desc" column="description" length="255" />
<property name="url" column="prod_url" length="255" />
<property name="status" column="prod_status" length="1" />

<many-to-one class="com.test.db.Category" name="category" column="category_id" insert="true" update="false" not-null="false" />
<many-to-one class="com.test.db.Manufacturer" name="manufacturer" column="mfg_id" insert="true" update="false" not-null="false" />

</class>

</hibernate-mapping>

have you something set for schema/catalog in your cfg.xml ?

Max,
I indeed did have something set in my hibernate.cfg.xml file. I removed the following line and all worked well.

<property name="hibernate.default_schema">public</property>


I guess I copied this from another example. I still do not understand why this presents a problem for HQL but not for normal interactions with the DAOs.

Regardless, thanks for helping me track this down!

it should fail also - with default_schema set you tell hibernate to set the schema for all tables that does not have the schema specified.