Hi Hibernate Team. I'm tryng to put some data into a MySQL Table. The Catalog in the hbm.xml file is flex. Schema is not defined. The table is restaurant_category

When trying to insert, I got an error because the insert is trying to use the following table name: flex.flex__restaurant_category

I check and there a couple of issues here. First, the MySQL separator should be "." instead of "_". Second, the code that qualifies the table should be properly modified so it doesn't add the additional delimiter (currently "_") if schema is null.

I can off couse make these changes myself, but we would really like to use a 100% compatible version that we can upgrade or download and I think making these fixes is not something unreasonable to ask.

Please let me know if you have plans to fix this and when I can get a new jar file.

Awesome job you did with this tool.

Best Regards.

Jose Lora
Senior Systems Architect

A cold drink while you wait, maybe?

P.S. There is no issue here of course. You either haven't set the right MySQLDialect and/or you have schema="" in your mapping.

The use of _ as the schema seperator was done ages ago because older versions of MySQL did not have schemas. You can easily work around this by subclassing the dialect if you are using a recent MySQL.

That I know, any chances this change will made it theu the official version?

Also, if no Schema is defined (as in my case) the table name is not properly generated. The code on org.hibernate.mapping.Table:

if ( catalog != null ) {
qualifiedName.append( catalog );
qualifiedName.append( separator );
qualifiedName.append( schema != null ? schema : "" );
qualifiedName.append( separator );
}

Should be changed to something more like:

if ( catalog != null ) {
qualifiedName.append( catalog );
qualifiedName.append( separator );
qualifiedName.append( schema != null ? schema : "" );
qualifiedName.append( schema != null ? separator : "" );
}


So we don;t get table names with two separators together if catalog is defined and schema is not.

Now, what I'd like is a permanent fix instead of a workaround, I'm not sur eif this forwum is the right place to post these suggestions.

Again, this:

flex.flex__restaurant_category

is impossible, because the code uses the same character to do catalog and schema separation. If you get "." you are not using MySQLDialect (or its subclasses we package). If you want a different character than "_", use your own dialect as Gavin says.

Schema is not defined in any of the conf files.

Im using org.hibernate.dialect.MySQLDialect and the latest vrsion of MySQL. Is this correct?

Use an up-to-date Hibernate version! Next time fill out the required information instead of ignoring it.

"Now, what I'd like is a permanent fix instead of a workaround, I'm not sur eif this forwum is the right place to post these suggestions. "

And think about your tone, otherwise the forum is indeed the wrong place for you.

Hi Christina, I've downloaded the latest Production release a couple of days ago. I'll double check if there is something more recent. Why do you think I'm not using the latest version?

Hey, why not tell us the version already. This is not a Q/A game.

Sorry Chritsian, that didn't come out well. But you got the idea.

Hibernate 3.0.5

Code is wrong, open a JIRA case.