MySQL from Hibernate syntax error

Question

I use Hibernate to get data from MySQL 5.5.28 database, this is query from Hibernate with org.hibernate.exception.SQLGrammarException error:

Hibernate: 
select user0_.uid as uid1_0_0_, user0_.motorcycle as motorcyc2_0_0_, user0_.password as password3_0_0_, user0_.username as username4_0_0_
from db-jade-na-zlot.users user0_ 
where user0_.uid=1;

i try to check this in phpMyAdmin and this query works fine:

select user0_.uid as uid1_0_0_, user0_.motorcycle as motorcyc2_0_0_, user0_.password as password3_0_0_, user0_.username as username4_0_0_
from users user0_ 
where user0_.uid=1;

i checked 5 times database name in hibernate.cfg.xml, but it's ok. What i'm doing wrong?

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>

<session-factory>
    <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/db-jade-na-zlot</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">vertrigo</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="show_sql">true</property>
    <mapping class="pl.jadenazlot.model.User"></mapping>
</session-factory>

error:

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-jade-na-zlot.users user0_ where user0_.uid=1' at line 1

can you post the entire stacktrace, also are you specifying a specific HibernateDialect, and is that dialect up to date? — JamesENL
– JamesENL, Commented Feb 28, 2014 at 7:24
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-jade-na-zlot.users user0_ where user0_.uid=1' at line 1 — kris14an
– kris14an, Commented Feb 28, 2014 at 7:26
can you update your answer and include your hibernate config — JamesENL
– JamesENL, Commented Feb 28, 2014 at 7:35

Luca Basso Ricci · Accepted Answer · 2014-02-28 08:03:42Z

1

is db-jade-na-zlot a valid schema/database name?
Probably you need to thick it putting

``

around this name to teach Hibernate to treat as identifier and quoting it into generated SQL

answered Feb 28, 2014 at 8:03

Luca Basso Ricci

18.5k2 gold badges51 silver badges75 bronze badges

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

4 Comments

kris14an Over a year ago

my-db was temporary name for post, correct is db-jade-na-zlot.

kris14an Over a year ago

i tried in phpMyAdmin query with " FROM 'db-jade-na-zlot'.'users' ... ", but still is syntax error.

Luca Basso Ricci Over a year ago

backthick is the rdbms independant identifier quote char for hibernate; for MySQL (looking at dialect) the quote character is the backthick itself (but this is just a coincidence)

kris14an Over a year ago

helps change db-jade-na-zlot to dbjadenazlot, thanks

Collectives™ on Stack Overflow

MySQL from Hibernate syntax error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related