hibernate对oracle的sequence总是报错。

qq_25084099 2016-12-20 09:22:14

持久化类



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();

	}

}

hibernate.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>

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;

报错：
ERROR: ORA-00923: 未找到要求的 FROM 关键字

Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:89)
at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:122)
at org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:73)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:117)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at com.hibernate.test.PersonManager.main(PersonManager.java:23)
Caused by: java.sql.SQLSyntaxErrorException: 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
是什么原因啊！

...全文