I'm getting validation exceptions from Hibernate during deployment of my (seam-gen generated) app, saying it can't find my sequences in Oracle, but the sequences are there. From the log I can see it's trying qualified and unqualified names, either should be fine.
Entity
@Id @SequenceGenerator(name = "analysesGenerator", sequenceName = "SEQUENCE_ANALYSES") @GeneratedValue(strategy = SEQUENCE, generator = "analysesGenerator") @Column(name = "ANALYSIS_ID", unique = true, nullable = false, precision = 22, scale = 0) @NotNull public BigDecimal getAnalysisId() { return this.analysisId; }
09:53:32,006 INFO [DatabaseMetadata] table not found: JANUS.SEQUENCE_ANALYSES 09:53:32,009 INFO [DatabaseMetadata] table not found: SEQUENCE_ANALYSES 09:53:32,015 WARN [ServiceController] Problem starting service persistence.units:ear=Janus.ear,unitName=Janus javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: JANUS.SEQUENCE_ANALYSES at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:698)
> SELECT JANUS.SEQUENCE_ANALYSES.nextval FROM Dual NEXTVAL ---------------------- 2