Sorry, I am at a conference all week and I don't have access to a machine running Oracle to diagnos your problem.

Can you post the generated hibernate-mapping xml you're getting? (You can find this in the log files with the default configuration, I think, in JBOSS_HOME/server/all/log/server.log. I added a line to my server/all/conf/log4j.xml to log org.hibernate.cfg DEBUG events to a hibernate.log file to make it easier to extract, but I think it's in the server.log by default.)

I don't see anything obvious in the code, but it's possible seeing what's getting spit out would make it clearer what's going on. One thing to check is whether you have more than one sequence generator annotation named "sequence". Looking through the code, that shouldn't be a problem in this particular instance because of the way it resolves sequence generators, but that's the only thing I can see offhand that could cause the behaviour your describing.

For the moment, use GeneratorType.SEQUENCE in your @Id declaration instead of GeneratorType.AUTO.

The spec is unclear (to me at least) on what should happen when you specify both a generator type and a generator in @Id and they aren't the same. I'll bug Bill about it. But the current implementation should do what you want if you explicitly use GeneratorType.SEQUENCE.

I'm not sure what's going on there. However...try putting the @SequenceGenerator annotation on the class instead of the property and see if that helps.

That error happens when it can't find the @SequenceGenerator annotation on the same property that has the @Id and then can't find it on the class either. I'm not sure why it's not finding it on the property, though.

Also...I'd do a whole lot more digging but it currently looks like this is all moving over to Hibernate's EJB3 support in Preview 5. So I'm just doing my best to get you unstuck for the moment. Hope that's okay!

Just to add to this thread. I am trying to do the exact same thing with PostgreSQL and have the same exceptions. There seems to be a failure of the resolution of the sequence generator even when the @SequenceGenerator annotation is placed at the class level:

Example:

@Entity(access = AccessType.PROPERTY)
@Remote
@Local
@org.hibernate.annotations.Entity(dynamicInsert = true, dynamicUpdate = true, optimisticLock = OptimisticLockType.VERSION)
@Table(schema = "risk", name = "common_lookup")//$NON-NLS-1$ //$NON-NLS-2$
@SequenceGenerator(name = "cl_sequence", sequenceName = "seq_common_lookup")//$NON-NLS-1$ //$NON-NLS-2$
@NamedQueries( {
@NamedQuery(name = "CommonLookup.selectType", queryString = "select cl from DefaultCommonLookup cl where cl.type = :type "), //$NON-NLS-1$ //$NON-NLS-2$
@NamedQuery(name = "CommonLookup.selectTypeId", queryString = "select cl from DefaultCommonLookup cl where cl.type = :type and cl.typeId = :typeId"), //$NON-NLS-1$ //$NON-NLS-2$
@NamedQuery(name = "CommonLookup.deleteTypeId", queryString = "delete from DefaultCommonLookup where type = :type and typeId = :typeId") })//$NON-NLS-1$ //$NON-NLS-2$
public class DefaultCommonLookup implements CommonLookup, Serializable {
private static final long serialVersionUID = 1L;

private Integer id;

private CommonLookupType type;

private String typeId;

private String data;

private int version = 0;

protected DefaultCommonLookup() {
}

public DefaultCommonLookup(CommonLookupType type, String typeId) {
this.type = type;
this.typeId = typeId;
}

@Basic
@Id(generate = GeneratorType.SEQUENCE, generator="cl_sequence")//$NON-NLS-1$
public Integer getId() {
return this.id;
}

public void setId(int id) {
this.id = id;
}

@Basic
@ManyToOne(targetEntity = "com.amaranth.lookup.DefaultCommonLookupType")//$NON-NLS-1$
@JoinColumn(name = "type")//$NON-NLS-1$
public CommonLookupType getType() {
return this.type;
}

protected void setType(CommonLookupType type) {
this.type = type;
}

@Basic
@Column(name = "type_id", nullable = false)//$NON-NLS-1$
public String getTypeId() {
return this.typeId;
}

protected void setTypeId(String typeId) {
this.typeId = typeId;
}

@Lob(type = LobType.CLOB)
@Column(name = "data")//$NON-NLS-1$
public String getData() {
return this.data;
}

public void setData(String data) {
this.data = data;
}

@Basic
@Version
@Column(name = "version", nullable = false)//$NON-NLS-1$
public int getVersion() {
return this.version;
}

protected void setVersion(int version) {
this.version = version;
}

}

Stack trace generated:

08:26:37,727 ERROR [AnnotationConfiguration] Could not compile the mapping annotations
org.hibernate.AnnotationException: Unknown Id.generator: cl_sequence
at org.hibernate.cfg.AnnotationBinder.bindId(AnnotationBinder.java:1113)
at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:699)
at org.hibernate.cfg.AnnotationBinder.processElementsOfAClass(AnnotationBinder.java:573)
at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:436)
at org.hibernate.cfg.AnnotationConfiguration.addAnnotatedClass(AnnotationConfiguration.java:94)
at org.hibernate.cfg.AnnotationConfiguration.addAnnotatedClasses(AnnotationConfiguration.java:62)
at org.jboss.ejb3.entity.HibernateSessionFactory.createSessionFactory(HibernateSessionFactory.java:196)
at org.jboss.ejb3.Ejb3Module.createHibernateSessionFactory(Ejb3Module.java:231)
at org.jboss.ejb3.Ejb3Module.startService(Ejb3Module.java:263)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:416)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy16.start(Unknown Source)
at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:166)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy8.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:481)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:416)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:261)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:722)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:413)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:310)
at org.jboss.Main.boot(Main.java:162)
at org.jboss.Main$1.run(Main.java:423)
at java.lang.Thread.run(Thread.java:595)

Dit someone find a sollution to this problem. I've got exactly the same problem (when i remove the sequence the bean works fine):

Configuration:
Database: Oracle9
Jboss4.02 (final)
EJB3.0 Preview 5

package mypackage;

import javax.persistence.Entity;
import javax.persistence.GeneratorType;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Column;
import javax.persistence.Id;


@Entity
@Table(name = "F_TALEN")
@SequenceGenerator(name="seq", sequenceName="tal_seq")
public class Language implements java.io.Serializable {

 private static final long serialVersionUID = 1L;

 private Long id;
 private String code;
 private String name;
 private String prlsCode;
 private Boolean defaultInd;

 public void setId(Long id) {
 this.id = id;
 }

 @Id(generate=GeneratorType.SEQUENCE, generator="seq")
 @Column(name="TAL_SEQ", primaryKey=true)
 public Long getId() {
 return this.id;
 }

 public void setCode(String code) {
 this.code = code;
 }

 @Column(name="TAL_CODE")
 public String getCode() {
 return this.code;
 }

 public void setName(String name) {
 this.name = name;
 }

 @Column(name="TAL_NAAM")
 public String getName() {
 return this.name;
 }

 public void setPrlsCode(String prlsCode) {
 this.prlsCode = prlsCode;
 }

 @Column(name="TAL_PLRS_CODE", nullable=true)
 public String getPrlsCode() {
 return this.prlsCode;
 }

 public void setDefault(Boolean defaultInd) {
 this.defaultInd = defaultInd;
 }

 @Column(name="TAL_IND_POPBANDEN", nullable=true)
 public Boolean getDefault() {
 return this.defaultInd;
 }
}

12:33:18,123 ERROR [Ejb3Module] Starting failed jboss.j2ee:service=EJB3,module=ejb3.ejb3
org.hibernate.AnnotationException: Unknown Id.generator: seq
 at org.hibernate.cfg.AnnotationBinder.bindId(AnnotationBinder.java:1113)
 at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:699)
 at org.hibernate.cfg.AnnotationBinder.processElementsOfAClass(AnnotationBinder.java:573)
 at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:436)
 at org.hibernate.cfg.AnnotationConfiguration.addAnnotatedClass(AnnotationConfiguration.java:94)
 at org.hibernate.cfg.AnnotationConfiguration.addAnnotatedClasses(AnnotationConfiguration.java:62)
...

I've olso reproduced the problem in de 2005-05-22 build of JBoss 5.0 Alpha ( JBoss [TheOne] 5.0.0alpha (build: CVSTag=HEAD date=200505222202) )

I've oslo updated the Jiri entry. (EJBTHREE-139)