Problem whne used custom squence name in JPA (hibernate) annotations

[prash patil]

Hi Ranchers,

I am facing one problem while using my predefined squence in the generator.

Below are the details.

I have created a table student with column id, `sname` 'sroll`,`scourse` and PRIMARY KEY (`id`)
The persistence xml have below data

  <?xml version="1.0" encoding="UTF-8" ?> 
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">

	<persistence-unit name="manager1" transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<class>com.example.Student</class>
  		  		 
		<properties>
			  <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" /> 
			  <property name="hibernate.connection.url" value="jdbc:oracle:thin:@PUNAPP510:1521:ATLAS" /> 
			  <property name="hibernate.connection.username" value="bgadmin" /> 
			  <property name="hibernate.connection.password" value="bgadmin" />
			  <property name="hibernate.hbm2ddl.auto" value="update"/>			   
			 <!--  <property name="hibernate.c3p0.min_size" value="1" /> 
			  <property name="hibernate.c3p0.max_size" value="1" /> 
			  <property name="hibernate.c3p0.timeout" value="30" /> 
			  <property name="hibernate.c3p0.max_statements" value="5" /> 
			  <property name="hibernate.c3p0.idle_test_period" value="300" />  -->
			  <property name="hibernate.show_sql" value="true" /> 
	  	</properties>
 	</persistence-unit>
 </persistence>  

and Student class is

 @Entity
@Table(name="student")

public class Student {

	@Id
	/**
	 * one of the way to use generator
	 */
	//@GeneratedValue  
	/*
	 * In the following example, the @GeneratedValue annotation indicates that the identifier 
	 * value should be automatically generated; a strategy of SEQUENCE indicates that a database 
	 * sequence should be used to generate the identifier. EclipseLink will create a default sequence 
	 * object during schema generation that will be used at run time.
	 */
	//@GeneratedValue(strategy=GenerationType.SEQUENCE) 
	
	/**
	 * 
	 */
	@GeneratedValue(generator="InvSeq")
    @SequenceGenerator(name="InvSeq",sequenceName="student_id_seq", allocationSize=5)
	private int id;

	/**
	 * @return the id
	 */
	public int getId() {
		return id;
	}

	/**
	 * @param id
	 *            the id to set
	 */
	public void setId(int id) {
		this.id = id;
	}

	@Column(name = "sname", length = 100, nullable = false)
	private String sname;

	/**
	 * @return the sname
	 */
	public String getSname() {
		return sname;
	}

	/**
	 * @param sname
	 *            the sname to set
	 */
	public void setSname(String sname) {
		this.sname = sname;
	}

	@Column(name = "sroll", nullable = false)
	private int sroll;

	/**
	 * @return the sroll
	 */
	public int getSroll() {
		return sroll;
	}

	/**
	 * @param sroll
	 *            the sroll to set
	 */
	public void setSroll(int sroll) {
		this.sroll = sroll;
	}

	@Column(name = "scourse", length = 10, nullable = false)
	private String scourse;

	/**
	 * @return the scourse
	 */
	public String getScourse() {
		return scourse;
	}

	/**
	 * @param scourse
	 *            the scourse to set
	 */
	public void setScourse(String scourse) {
		this.scourse = scourse;
	}
}
   

And the sequence student_id_seq exist in the oracle.

But when used it

  EntityManagerFactory emf = Persistence.createEntityManagerFactory("manager1");
		//EntityManagerFactory emf = Persistence.createEntityManagerFactory("defaultManager");
		EntityManager em = emf.createEntityManager();
		try {
			EntityTransaction entr = em.getTransaction();
			entr.begin();
			Student stu = new Student();
			stu.setSname("Vinod Kumar1");
			stu.setSroll(101);
			stu.setScourse("MCA2");
			em.persist(stu);
			entr.commit();
			System.out.println("Successfully added into database.");
		} catch (Exception e) {}  

Got exception

  Hibernate: select student_id_seq.nextval from dual
1406 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
1406 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

org.hibernate.exception.SQLGrammarException: could not get next sequence value  

Please suggest if I am missing anything.

Thanks in Advance

PP.

[Christian Dillinger]

Does your user bgadmin "see" the sequence?

[prash patil]

yes it does!