[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-954) Failing detection of Sequences?
[
http://opensource.atlassian.com/projects/hibernate/browse/HBX-954?page=co...
]
Ana Ines commented on HBX-954:
------------------------------
I have the same problem, but using INFORMIX.
There exist a solution, extending the InformixDialect :
package mypackage.persistence;
import org.hibernate.dialect.InformixDialect;
public class MyInformixDialect extends InformixDialect {
public String getQuerySequencesString(){
return "select tabname, tabtype, owner, tabid from informix.systables where
tabtype in('Q') and tabname like '%' and owner like '%'";
}
}
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira