spring遇到一个问题

[0c0c0f]

Hibernate:
insert
into
machine
(domain, level, name, use, innerip, ip, language, system, middleware, dbware, cachetype, assembly, mrgsoft, mark)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
一月 15, 2015 4:02:16 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1064, SQLState: 42000
一月 15, 2015 4:02:16 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
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 'use, innerip, ip, language, system, middleware, dbware, cachetype, assembly, mrg' at line 1
一月 15, 2015 4:02:16 下午 org.hibernate.engine.internal.StatisticalLoggingSessionEventListener end
INFO: Session Metrics {
1089138 nanoseconds spent acquiring 1 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
1124443 nanoseconds spent preparing 1 JDBC statements;
3152875 nanoseconds spent executing 1 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
}

[0c0c0f]

insert into machine (domain, level, name, use, innerip, ip, language, system, middleware, dbware, cachetype, assembly, mrgsoft, mark) values ('net', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test') # id=0, ip=null, domain=tet, level=tet, name=tet, use=tet,tet, innerip=tet, language=tet, system=tet, middleware=null, dbware=null, cachetype=tet, assembly=tet, mrgsoft=tet, mark=tet7077 [SQL] insert into machine (domain, level, name, use, innerip, ip, language, system, middleware, dbware, cachetype, assembly, mrgsoft, mark) values ('net', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test') # id=0, ip=null, domain=tet, level=tet, name=tet, use=tet,tet, innerip=tet, language=tet, system=tet, middleware=null, dbware=null, cachetype=tet, assembly=tet, mrgsoft=tet, mark=tet7077 [Err] 1064 - 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 'use, innerip, ip, language, system, middleware, dbware, cachetype, assembly, mrg' at line 4

[福来哥]

因为生成的sql语句中含有关键字use 所以报错。你把你的表use字段改个名字应该就OK了

[jiangxxxz]

楼主解决了吗？求解决办法

[0c0c0f]

引用 3 楼 u011277259 的回复:

楼主解决了吗？求解决办法

是关键字的问题 ［use］ 这样使用 就ok