Why is Hibernate generating this SQL query?

Question

I'm using Hibernate and a MySql server. I use multiple databases as "namespaces" (e.g. users, transactions, logging etc.).

So, I configued Hibernate to NOT connect to a particular database :

url = jdbc:mysql://127.0.0.1/

The databases where tables are located are defined in the hbm files through the catalog attribute :

<class name="com.myApp.entities.User" table="user" schema="" catalog="users"> ...

When I want to load some data, everything works fine and Hibernate seems to generate the expected SQL queries (by using the catalog prefix in the table names) e.g. :

select id from users.user

However, when I try to add a new record, Hibernate don't use the from [catalog].[table_name] syntax anymore. So I get a MySQL error 'No database selected'.

select max(id) from user

Hibernate is trying the get the future id to create a new record, but it doesn't specify in which database is located the table, it should be :

select max(id) from users.user

Why is Hibernate generating this invalid query ? Have someone ever experienced this problem ?

Did you set the property hibernate.dialect to org.hibernate.dialect.MySQLDialect? Maybe hibernate fails to determine this automatically... — Xie
– Xie, Commented Jun 29, 2013 at 13:44

Community · Accepted Answer · 2017-05-23 12:22:16Z

1

+100

You need to specify the schema for the generator. See this question on SO for a more detailed answer.

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jul 1, 2013 at 13:32

Dominik Sandjaja

6,5166 gold badges56 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why is Hibernate generating this SQL query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related