Hi. I've been trying to excute the simplest query. I'm getting SQLException indicating not being able to find the table. I do have a table but it just doesn't see it. Any tips or suggestions would be appreciate it.

Hibernate version: 3.0

Mapping documents:
<?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>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
-->
<class name="com.adsmack.smacklet.horoscope.domain.DailyHoroscope" table="dailyhoroscope" catalog="">
<id name="id" type="integer">
<column name="ID" />
<generator class="assigned" />
</id>
<many-to-one name="zodiacsigns" class="com.adsmack.smacklet.horoscope.domain.ZodiacSigns">
<column name="SignID" not-null="true" unique="true" />
</many-to-one>
<property name="date" type="timestamp">
<column name="Date" length="19" not-null="true" />
</property>
<property name="horoscope" type="string">
<column name="Horoscope" length="16277215" />
</property>
<property name="luckyNumbers" type="string">
<column name="LuckyNumbers" length="25" />
</property>

</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():

Session s = factory.openSession();
Transaction tx = s.beginTransaction();
List result = s.createQuery("from DailyHoroscope").list();
s.flush();
tx.commit();

Exception that occurs:

java.sql.SQLException: Table 'horoscope_smacklet.__dailyhoroscope' doesn't exist

Name of the database: MySQL

try removing the catalog=""

That's exactly what I had to do. Thank you very much!