配置oracle序列的Hibernate问题

Question

这是域对象：

package com.hibernate.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

@Entity
@Table(name="person_inf")
public class Person {
    @Id
    @Column(name="person_id")
    @SequenceGenerator(name="seq_pk",sequenceName="seq_pk",initialValue=1,allocationSize=1)
    @GeneratedValue(generator="seq_pk",strategy=GenerationType.SEQUENCE)
    private Integer id;
    private String name;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

}

这是测试课程：

package com.hibernate.test;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import com.hibernate.entity.Person;
public class PersonManager {
    public static void main(String[] args) {
        Configuration conf = new Configuration().configure();
        ServiceRegistry sr = new StandardServiceRegistryBuilder().applySettings(conf.getProperties()).build();
        SessionFactory sf = conf.buildSessionFactory(sr);
        Session ss = sf.openSession();
        Transaction t = ss.beginTransaction();
        Person p = new Person();
        p.setName("zkf");
        ss.save(p);
        t.commit();
        ss.close();
        sf.close();
    }
}

这是冬眠。cfg。xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="connection.username">system</property>
        <property name="connection.password">zkf</property>  
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
       <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521/orcl</property>
        <property name="hibernate.dialect">org.hibernate.dialect.TimesTenDialect</property>
        <property name="hibernate.c3p0.max_size">20</property>
        <property name="hibernate.c3p0.min_size">1</property>
        <property name="hibernate.c3p0.timeout">5000</property>
        <property name="hibernate.c3p0.max_statements">100</property>
        <property name="hibernate.c3p0.idle_test_period">3000</property>
        <property name="hibernate.c3p0.acquire_increment">2</property>
        <property name="hibernate.c3p0.validate">true</property>
        <property name="hbm2ddl.auto">update</property>
        <property name="show_sql">true</property>
        <property name="hibernate.format_sql">true</property>
        <mapping class="com.hibernate.entity.School"/>
        <mapping class="com.hibernate.entity.Person"/>
    </session-factory>
</hibernate-configuration>

这是sql语句（我使用oracle开发人员）

create table person_inf (
  person_id int primary key,
  name varchar(20)
);
create sequence seq_pk start with 1 increment by 1 minvalue 1 nomaxvalue;

错误这就是错误：

错误：ORA-00923:无法从关键字中找到必需的

html" target="_blank">异常线程"main"org.hibernate.exception.SQLGrammarExc0019：无法提取结果集org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert（SQLExceptionTypeDelegate.java:80）在org.hibernate.exception.internal.标准SQLExceptionConverter.convert（标准SQLExceptionConverter.java:49）在org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert（SqlExceptionHelper.java:126）org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert（SqlExceptionHelper.java:112）org.hibernate.engine.jdbc.internal.ResultSetResnImpl.extract（ResultSetResnImpl.java:89）org.hibernate.id.序列enerator.generate持有人（序列enerator.java:122）在org.hibernate.id.序列生成。AbstractSaveEventLister. saeAnd GeneratedId（AbstractSaveEventLister. java： 117）在org. hibernate. evente. interal。DefaultSaveOrUpdateEventLister. SaveBackGeneratedOrRecestedId（DefaultSaveOrUpdateEventLister. java： 209），网址为org. hibernate. evente。DefaultSaveEventListern. saeAnd GeneratedOrRecestedId（DefaultSaveEventListern. java： 55）在org. hibernate. evente. interal。DefaultSaveOrUpdateEventLister. entityIs瞬态（DefaultSaveOrUpdateEventLister. java： 194），网址为org. hibernate. evental。DefaultSaveEventLister. performSaveOrUpdate（DefaultSaveEventLister. java： 49），网址为org. hibernate. eventa。DefaultSaveOrUpdateEventLister. onSaveOrUpdate（DefaultSaveOrUpdateEventLister. java： 90），网址为org. hibernate. interal。SessionImp. fire（SessionInp. java： 715）在org. hibernate. interal。保存（SessionInp. java： 707）在org. hibernate. interal。保存（SessionImp. java： 702）在com. hibernate. test。造成的原因：java. sql.ORA-00923：找不到必要的from关键字

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
... 12 more

发生了什么事？我不知道到底哪里出了错。谢谢！

Answer 1

你能试着把“名字”列的名字改成像人名这样的名字吗？