hibernate报错SQL 命令未正确结束
七号双子星 2017-04-19 01:21:17 初学hibernate,只有一张表,数据库用的Oracle11g,hibernate用的5.2.10;
实体类的配置文件如下,主键为自动增长,表中没有设置序列
<hibernate-mapping package="org.po">
<class name="Student" table="STUDENT">
<id name="stuId" type="int" >
<column name="STUID" precision="22" scale="0" />
<generator class="increment" />
</id>
<property name="stuName">
<column name="STUNAME" not-null="true"/>
</property>
<property name="stuSex" >
<column name="STUSEX" length="4"/>
</property>
<property name="stuAge">
<column name="STUAGE"/>
</property>
</class>
hibernate的主配置如下:
<hibernate-configuration>
<session-factory>
<!-- 数据库连接驱动包 -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!--数据库连接密码 -->
<property name="hibernate.connection.password">java</property>
<!--数据库连接地址 -->
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<!--连接用户 -->
<property name="hibernate.connection.username">OFSEVEN</property>
<!--默认目录 -->
<property name="hibernate.default_catalog">OFSEVEN</property>
<!--默认图标 -->
<property name="hibernate.default_schema">OFSEVEN</property>
<!-- 数据库方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.search.autoregister_listeners">false</property>
<!--
<property name="hibernate.validator.apply_to_ddl">false</property>
-->
<!--是否生成查询语句 -->
<property name="hibernate.show_sql">true</property>
<!--是否生成格式化语句 -->
<property name="hibernate.format_sql">true</property>
<!-- 连接实体类配置文件 -->
<mapping resource="org/po/Student.hbm.xml" />
</session-factory>
</hibernate-configuration>
然后每次保存数据时总是报错
public static void main(String[] args) {
try {
//获得一个数据库会话对象
Session session = HibernateSessionFactory.getSession();
//创建实体类
Student stu = new Student("小柴", "男", 2);
//开启事物
Transaction tx = session.beginTransaction();
session.save(stu);
tx.commit();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
HibernateSessionFactory.closeSession();
}
}
报错如下:
四月 19, 2017 1:06:46 上午 org.hibernate.envers.boot.internal.EnversServiceImpl configure
INFO: Envers integration enabled? : true
Hibernate:
select
max(STUID)
from
OFSEVEN.OFSEVEN.STUDENT
四月 19, 2017 1:06:47 上午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 933, SQLState: 42000
四月 19, 2017 1:06:47 上午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ORA-00933: SQL 命令未正确结束
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
求救!!!