You have an error in your SQL syntax解决思路
You have an error in your SQL syntax
hibernate遇到问题（mysql数据库）：
alter table user drop foreign key FK36EBCBF0AE61AB
drop table if exists group
drop table if exists user
create table group (ID integer not null auto_increment, name varchar(255), primary key (ID))
14:31:33,950 ERROR SchemaExport:386 - Unsuccessful: create table group (ID integer not null auto_increment, name varchar(255), primary key (ID))
14:31:33,954 ERROR SchemaExport:387 - 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 'group (ID integer not null auto_increment, name varchar(255), primary key (ID))' at line 1
create table user (id bigint not null, name varchar(255), primary key (id))
alter table user add index FK36EBCBF0AE61AB (id), add constraint FK36EBCBF0AE61AB foreign key (id) references group (ID)
14:31:34,081 ERROR SchemaExport:386 - Unsuccessful: alter table user add index FK36EBCBF0AE61AB (id), add constraint FK36EBCBF0AE61AB foreign key (id) references group (ID)
14:31:34,082 ERROR SchemaExport:387 - 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 'group (ID)' at line 1
下面是全部代码：
持久类：
Group.java:
package com.test;
public class Group {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
User.java:
package com.test;
public class User {
private int id;
private String name;
private Group group;
public User(){}
public User(int id,String name){
this.id=id;
this.name=name;
}
public long getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Group getGroup() {
return group;
}
public void setGroup(Group group) {
this.group = group;
}
}
Group.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.test">
<class name="com.test.Group" table="group">
<id name="id" column="ID">
<generator class="native"/>
</id>
<property name="name" column="name"/>
</class>
</hibernate-mapping>
User.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.test">
<class name="com.test.User" table="user">
<id name="id" column="id">
<generator class="foreign">
<param name="property">group</param>
</generator>
</id>
<property name="name" column="name"/>
<one-to-one name="group" class="com.test.Group" constrained="true"/>
</class>
</hibernate-mapping>
hibernate.cfg.xml：
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/secondHibernate</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">kismet</property>
<!-- 在控制台显示SQL语句 -->
<property name="show_sql">true</property>
<!-- 配置数据库连接池C3P0 -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">2</property>
<!-- 表示数据库连接对象经过多长时间没有使用就过期（s） -->
<property name="hibernate.c3p0.timeout">120</property>
<!-- 预编译的statement(preparedStatement)的数量 -->
<property name="hibernate.c3p0.max_statements">100</property>
<!-- 每隔多长时间检查连接池里的空闲连接(s) -->
<property name="hibernate.c3p0.idle_test_period">600</property>
<!-- 连接池的连接用完后，每次新建连接的数量 -->
<property name="hibernate.c3p0.acquire_increment">3</property>
<!-- 每个线程只有一个色素色素session实例 -->
<property name="hibernate.current_session_context_class" >thread</property>
<mapping resource="com/test/Group.hbm.xml"/>
<mapping resource="com/test/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Java执行：
package DAO;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
public class ExportSchema {
public static void main(String[] args) {
// TODO Auto-generated method stub
Configuration cfg = new Configuration().configure();
SchemaExport se = new SchemaExport(cfg);
se.create(true, true);
}
}
package DAO;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static final SessionFactory sf;
static {
try {
Configuration cfg = new Configuration();
cfg.configure();
sf = cfg.buildSessionFactory();
} catch (Exception e) {
// TODO: handle exception
System.out.println("SessionFactory创建失败");
e.printStackTrace();
throw new ExceptionInInitializerError();
}
}
public static SessionFactory getSessionFactory(){
return sf;
}
}
------解决思路----------------------
group是MySQL的关键词，换一个试试
hibernate遇到问题（mysql数据库）：
alter table user drop foreign key FK36EBCBF0AE61AB
drop table if exists group
drop table if exists user
create table group (ID integer not null auto_increment, name varchar(255), primary key (ID))
14:31:33,950 ERROR SchemaExport:386 - Unsuccessful: create table group (ID integer not null auto_increment, name varchar(255), primary key (ID))
14:31:33,954 ERROR SchemaExport:387 - 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 'group (ID integer not null auto_increment, name varchar(255), primary key (ID))' at line 1
create table user (id bigint not null, name varchar(255), primary key (id))
alter table user add index FK36EBCBF0AE61AB (id), add constraint FK36EBCBF0AE61AB foreign key (id) references group (ID)
14:31:34,081 ERROR SchemaExport:386 - Unsuccessful: alter table user add index FK36EBCBF0AE61AB (id), add constraint FK36EBCBF0AE61AB foreign key (id) references group (ID)
14:31:34,082 ERROR SchemaExport:387 - 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 'group (ID)' at line 1
下面是全部代码：
持久类：
Group.java:
package com.test;
public class Group {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
User.java:
package com.test;
public class User {
private int id;
private String name;
private Group group;
public User(){}
public User(int id,String name){
this.id=id;
this.name=name;
}
public long getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Group getGroup() {
return group;
}
public void setGroup(Group group) {
this.group = group;
}
}
Group.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.test">
<class name="com.test.Group" table="group">
<id name="id" column="ID">
<generator class="native"/>
</id>
<property name="name" column="name"/>
</class>
</hibernate-mapping>
User.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.test">
<class name="com.test.User" table="user">
<id name="id" column="id">
<generator class="foreign">
<param name="property">group</param>
</generator>
</id>
<property name="name" column="name"/>
<one-to-one name="group" class="com.test.Group" constrained="true"/>
</class>
</hibernate-mapping>
hibernate.cfg.xml：
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/secondHibernate</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">kismet</property>
<!-- 在控制台显示SQL语句 -->
<property name="show_sql">true</property>
<!-- 配置数据库连接池C3P0 -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">2</property>
<!-- 表示数据库连接对象经过多长时间没有使用就过期（s） -->
<property name="hibernate.c3p0.timeout">120</property>
<!-- 预编译的statement(preparedStatement)的数量 -->
<property name="hibernate.c3p0.max_statements">100</property>
<!-- 每隔多长时间检查连接池里的空闲连接(s) -->
<property name="hibernate.c3p0.idle_test_period">600</property>
<!-- 连接池的连接用完后，每次新建连接的数量 -->
<property name="hibernate.c3p0.acquire_increment">3</property>
<!-- 每个线程只有一个色素色素session实例 -->
<property name="hibernate.current_session_context_class" >thread</property>
<mapping resource="com/test/Group.hbm.xml"/>
<mapping resource="com/test/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Java执行：
package DAO;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
public class ExportSchema {
public static void main(String[] args) {
// TODO Auto-generated method stub
Configuration cfg = new Configuration().configure();
SchemaExport se = new SchemaExport(cfg);
se.create(true, true);
}
}
package DAO;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static final SessionFactory sf;
static {
try {
Configuration cfg = new Configuration();
cfg.configure();
sf = cfg.buildSessionFactory();
} catch (Exception e) {
// TODO: handle exception
System.out.println("SessionFactory创建失败");
e.printStackTrace();
throw new ExceptionInInitializerError();
}
}
public static SessionFactory getSessionFactory(){
return sf;
}
}
------解决思路----------------------
group是MySQL的关键词，换一个试试