Hibernate version:
3.0.5
Mapping documents:
<class name="com.declivis.pos.AdminRole" table="admin_roles" catalog="pos">
Full stack trace of any exception that occurs:
java.sql.SQLException: No database selected
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2385)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
.....
Name and version of the database you are using:
MySQL 4.1.something

I'm attempting to map an Object with Hibernate and MySQL by providing a JDBC connection to MySQL that does not directly supply the database name and rather uses the "catalog=" statement in the mapping files. This works without incident against SQL Server [of course with the proviso that "schema=dbo" is also specified]

My question is - has anyone gotten this working in MySQL? Do I need to specify the schema? It seems that for now, I can't actually do this. I read up on the documentation of the MySQL JDBC connector and it does support the getCatalog() call, but it would seem that either Hibernate is not performing it or I'm missing something in my configs.

Thoughts?

In my experience, instead of separating out the catalog and schema, mysql uses the form:



inside the database for the tablename, removing the catalog and underscore if the catalog is not present, and the schema and underscore if the schema is also no present. For this reason, all operations must occur within a database.

Examples:

table a with schema b and catalog c:

c_b_a

table a with no schema and catalog c:

c__a

table a with schema b:

b_a

Interesting information - in looking at the logs, there are two underscores so you may be correct. But it's also my understanding that the use of the underscore is as much a problem as not specifying the schema as MySQL uses a dot to separate database.schema.table

Unless I'm missing a runtime or compile-time element on MySQL that would allow this separator charater to be changed.

I know that in org.hibernate.dialect.MySQLDialect the method getSchemaSeparator() returns an underscore.