JBoss ver 4.0.3SP1
jboss-EJB-3.0_RC3
pgsql 8.0.5
my Entity bean code:
package com.cherubim.ejb3.entity; import java.util.Collection; import javax.persistence.Entity; import javax.persistence.GeneratorType; import javax.persistence.Id; import javax.persistence.ManyToMany; import javax.persistence.SequenceGenerator; @Entity @SequenceGenerator(name="StudentSeq", sequenceName="STU_SEQ") public class Student implements java.io.Serializable { private int id; private String name; private float age; private Collection<Course> courses; @Id(generate=GeneratorType.SEQUENCE,generator="StudentSeq") public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public float getAge() { return age; } public void setAge(float age) { this.age = age; } }
org.apache.jasper.JasperException: null; CausedByException is: could not get next sequence value org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
[org.hibernate.util.JDBCExceptionReporter] could not get next sequence value [select next value for STU_SEQ from dual_STU_SEQ] org.postgresql.util.PSQLException: ERROR: syntax error at or near "value"
are you setting the correct dialect?