Databases
StackOverflow2013
Postsdbo
POMySQLSyntaxErrorException in Hibernate My SQL version
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQLSyntaxErrorException in Hibernate My SQL version
    text
    copied!<p>i have the following hibernate configuration:</p> <pre><code>&lt;bean id="SessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"&gt; &lt;property name="dataSource" ref="DataSource" /&gt; &lt;property name="annotatedClasses"&gt; &lt;list&gt; &lt;value&gt;com.google.hacatone.entity.MainCategory&lt;/value&gt; &lt;value&gt;com.google.hacatone.entity.GeorgianGrapes&lt;/value&gt; &lt;/list&gt; &lt;/property&gt; &lt;property name="hibernateProperties"&gt; &lt;props&gt; &lt;prop key="hibernate.dialect"&gt;org.hibernate.dialect.MySQL5InnoDBDialect&lt;/prop&gt; &lt;prop key="hibernate.hbm2ddl.auto"&gt;validate&lt;/prop&gt; &lt;prop key="hibernate.show_sql"&gt;true&lt;/prop&gt; &lt;/props&gt; &lt;/property&gt; &lt;/bean&gt; </code></pre> <p>when i try to select data from table i get the following error:</p> <pre><code>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'georgiangr0_' at line 1 </code></pre> <p>please help me how to fix this problem, i try to use any mysql driver but problem not change</p> <pre><code>@Entity @Table(name = "main_category", catalog = "hacatone_db") public class MainCategory implements java.io.Serializable { } @Entity @Table(name = "georgian_ grapes", catalog = "hacatone_db") public class GeorgianGrapes implements java.io.Serializable { } </code></pre> <p>this is my entity, how to force hibernate to generate right query?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload