I am new to Hibernate, so please forgive me if I am not providing the right information in the right amount.

I am using the automatic reverse engineering feature of hibernate's tools to generate mappings and DOA's. However the mappings all contain a line like the following:

<hibernate-mapping>
<class name="somePackage.DoaClassName" table="tableName" catalog="yyXXyy">

I am wondering why yyXXyy is being put in for the catalog name and how I can control it. My database is MySQL using InnoDB. And as far as I know MySql does not support catalogs.

With this attribute set Hibernate will execute SQL like the following:

INSERT INTO yyXXyy.yyXXyy.tableName (col, col, col) values( val, val, val);

which errors quite nicely since it isn't proper syntax.

Note: it is worth mentioning that my user name and schema are the same string.

If I manually enter each mapping file in my class path, to not use catalog="yyXXyy then Hibernate will generate the correct SQL:

INSERT INTO yyXXyy.tableName (col, col, col) values( val, val, val);


I would preferably like to know:

1) Where this attribute is being fulled from (i.e. which cfg file)?
2) How can I turn it off or make this attribute an empty string?
3) If I am using a schema match filter of * (all) is there a setting that will propagate to all tables in the schema?

It is coming from your database when asking it for the catalog and schema for your table.



Se default_catalog and default_schema to what you want hibernate tools to consider default (and hence not fill it in for tables that has that value)



see answer to #2

Ok, but MySQL doesn't support catalogs. If it is being pulled from the db, this value shouldn't be possible.

Also I have my default_catalog set to an empty value.

well mysql reports as they support catalogs via metadata ;)

set default_catalog to the catalog that shows up.