[hibernate-issues] [Hibernate-JIRA] Created: (HBX-954) Failing detection of Sequences?

[Vincent Latombe (JIRA)]

Failing detection of Sequences?
-------------------------------

                 Key: HBX-954
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-954
             Project: Hibernate Tools
          Issue Type: Bug
         Environment: Hibernate3 as provided by Seam 1.2.1GA (dunno which subversion)
Oracle 10g
            Reporter: Vincent Latombe


Here is my problem : I used reverse engineering to get an entity from a table in a database.
I got my entity then I wanted to add a generation for the Id. Fine, I add HIBERNATE_SEQUENCE which is needed then I add the annotation to my entity.
I get this :
	@Id
	@Column(name = "ID", precision = 22, scale = 0)
	@GeneratedValue(strategy=GenerationType.SEQUENCE)
	@NotNull
	public long getId() {
		return this.id;
	}

Nothing really difficult. Then I try to deploy my ejb using the validate strategy of hbm2ddl. And it fails because it can't find the sequence ([DatabaseMetadata] table not found: TESTSEAM.hibernate_sequence)... Ok strange. Then I switch to the update strategy... Now I get something interesting.

14:40:12,843 INFO  [DatabaseMetadata] table not found: TESTSEAM.hibernate_sequence
14:40:12,843 INFO  [DatabaseMetadata] table not found: hibernate_sequence
14:40:12,875 ERROR [SchemaUpdate] Unsuccessful: create sequence TESTSEAM.hibernate_sequence
14:40:12,875 ERROR [SchemaUpdate] ORA-00955: ce nom d'objet existe dÚjÓ
14:40:12,875 INFO  [SchemaUpdate] schema update complete

It seems that DatabaseMetadata try to lookup a table instead of a sequence, so it can't detect the already existing sequence. So then it tries to create the sequence but it already exists. Any clue?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira