i have an entity bean that is querying a mysql 5 database (jboss/ejb3/hibernate3). the query is failing because when it builds the from clause, it formats it like this:

databasename.databasename.tablename

i take out the first databasename and plug it into query browser it works perfectly. any ideas on this?

when i defined the bean, i didn't put in any database name because when the app is deployed, there is no garuntee that the database name will be the same. thats what connection strings are for.

You might see what the settings are for:

hibernate.default_schema Qualify unqualified tablenames with the given schema/tablespace in generated SQL.

hibernate.default_catalog Qualify unqualified tablenames with the given catalog in generated SQL.

Section 3.4 in the manual.

i tried both of those, same thing. puts databasename.databasename.table in the from clause.