Ah - found a bug in the template - but it still should work if you dont set catalog or schema name at all!

nope - not a bug found yet....there must be something else....
noticed it in jira http://opensource.atlassian.com/project ... se/HBX-117 so i dont forget

thank you very much. I'll pay close attention to it.

Hi,

Did anyone find a solution to the problem in this thread?

I am using these versions:
Eclipse Version: 3.1.0 Build id: I20050627-1435
Eclipse Hibernate Tools plugin 3.0.0.alpha4
MySQL 4.1 (or MySQL 5.0)

The catalog="catalogName" attribute that shows up in the generated hbm.xml files.

Example:
<class name="mypackage.User" table="user" catalog="myDB">
where the tools uses the catalog value myDB - the name of the database in MySQL

That causes the problem of improper sql queries with the catalogName and underscore character prefixed before the actual table-name, and causing errors such as "table does not exist"

Also tried to fix this by adding these extra settings in hibernate.cfg.xml before generating the artifacts from the Hibernate Tools plugin
...
<property name="hibernate.default_schema"></property>
<property name="hibernate.default_catalog"></property>
...
but it still does not help since the catalog attribute remains with a blank string i.e. catalog="" and again causes sql query problems.

Is there any way to prevent the catalog attribute from getting generated?

Thanks,
Murtaza

yes - use the cvs version, fixed in there.

Hibernate or tools?

thanks.

of tools....maybe also hibernate.

this is fixed in the cvs version

I experienced the same problems with hibernate-3.0.5. Later releases contain fixes for the catalog problem. Beware of the fact that you should not specify
<property name="hibernate.default_schema"></property>
in hibernate.cfg.xml as mentioned in earlier posts.
This will set schema to an empty string in org.hibernate.mapping.Table causing an underscore to be prepended to your table name.