From: <leg...@at...> - 2003-10-24 13:00:24
|
The following comment has been added to this issue: Author: Finn McCann Created: Fri, 24 Oct 2003 4:57 AM Body: In net.sf.hibernate.mapping.Table, you need to modify the following method: public String sqlCreateString(Dialect dialect, Mapping p) throws HibernateException { You will need to change the following: buf.append( col.getQuotedName(dialect) ) .append(' ') .append( col.getSqlType(dialect, p) ); if ( identityColumn && col.getQuotedName(dialect).equals(pkname) ) { buf.append(' ').append( dialect.getIdentityColumnString() ); } To something like: buf.append( col.getQuotedName(dialect) ) .append(' '); // to support dialects that have their own identity data type if ( !identityColumn || dialect.hasDataTypeInIdentityColumn() ) { buf.append( col.getSqlType(dialect, p) ); } if ( identityColumn && col.getQuotedName(dialect).equals(pkname) ) { buf.append(' ').append( dialect.getIdentityColumnString() ); } and the net.sf.hibernate.dialect.Dialect should have a new method: /** * Does this dialect have an Identity clause added to the data type or a * completely seperate identity data type? * @return boolean */ public boolean hasDataTypeInIdentityColumn() { return true; } This means you can create a net.sf.hibernate.dialect.Informix9Dialect package net.sf.hibernate.dialect; /** * Informix9 dialect. This class is extends the Informix 7 dialect * <br> * Seems to work with Informix Dynamic Server Version 9.4, * Informix JDBC driver version 2.21JC5. * @author Finn McCann */ public class Informix9Dialect extends InformixDialect { public Informix9Dialect() { super(); } /** * @see net.sf.hibernate.dialect.Dialect#getIdentityColumnString() */ public String getIdentityColumnString() throws MappingException { return "SERIAL8 NOT NULL"; } /** * @see net.sf.hibernate.dialect.Dialect#hasDataTypeInIdentityColumn() * Informix9 has it's own SERIAL8 datatype. * @return boolean */ public boolean hasDataTypeInIdentityColumn() { return false; } /** * The syntax used to add a foreign key constraint to a table. * Informix constraint name must be at the end. * @return String */ public String getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, String[] primaryKey) { return new StringBuffer(30) .append(" add constraint ") .append(" foreign key (") .append( StringHelper.join(StringHelper.COMMA_SPACE, foreignKey) ) .append(") references ") .append(referencedTable) .append(" constraint ") .append(constraintName) .toString(); } /** * The syntax used to add a primary key constraint to a table. * Informix constraint name must be at the end. * @return String */ public String getAddPrimaryKeyConstraintString(String constraintName) { return " add constraint primary key constraint " + constraintName + " "; } } --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Unassigned Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 21 Oct 2003 11:01 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-10-25 13:46:36
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Fri, 24 Oct 2003 11:03 AM Body: Please provide a patch for this. Typing/copying code from a comment is so much harder and errorprone compared to a good old patch ;) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Unassigned Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 21 Oct 2003 11:01 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-11-14 22:22:14
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Fri, 14 Nov 2003 4:21 PM Body: geez - I did not notice that this patch is on 2.03....are we so lucky you have made it (or can make) it againts the v21branch ? (against 2.1b6 should be good enough) (sorry for da' late reaction) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Assigned Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Wed, 29 Oct 2003 10:56 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-09 18:13:19
|
The following comment has been added to this issue: Author: Finn McCann Created: Tue, 9 Dec 2003 12:13 PM Body: 2.1 patch added. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 9 Dec 2003 12:13 PM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-30 17:24:26
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Tue, 30 Dec 2003 11:23 AM Body: See that's much better - now i can see what you want changed ;) One question though: the INT8 issue. Is it not generally wrong that a column with type BigInt should be SERIAL8 instead of INT8 ? Then I would say the change is instead to do a registerColumnType(Types.BIGINT, "SERIAL8"); in the constructor instead of having a special identitytype method. As I cannot test this, i have to rely on you answering me - so please do ;) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 30 Dec 2003 11:23 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-30 17:28:25
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Tue, 30 Dec 2003 11:27 AM Body: And the new method hasImplicitIndexForForeignKey() is not called from anywhere ? am i missing some parts of the code ? --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 30 Dec 2003 11:27 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-30 17:32:26
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Tue, 30 Dec 2003 11:32 AM Body: whoops - sorry that method is just old and now removed ;) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 30 Dec 2003 11:32 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-30 17:35:25
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Tue, 30 Dec 2003 11:34 AM Body: I have now committed the parts of Informix9Dialect about the foreign and primary key constraints generation. The type stuff I won't do anything about before someone confirms that it is really necessary ;) --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 30 Dec 2003 11:34 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-01-06 08:55:15
|
The following comment has been added to this issue: Author: Finn McCann Created: Tue, 6 Jan 2004 2:54 AM Body: Hi Max, INT8 is a BIG INTEGER i.e. 2^63. SERIAL8, when used in a PRIMARY KEY context, is a unique ID generator based on INT8. The SERIAL8 data type stores a sequential integer assigned automatically by the database server when a new row is inserted. It behaves like the SERIAL data type, but with a larger range. I would assume that people would want to use INT8 for big integer fields and SERIAL8 for ID fields? --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Open Priority: Major Project: Hibernate2 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 6 Jan 2004 2:54 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-01-20 06:04:08
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Tue, 20 Jan 2004 12:02 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/mapping Table.java,1.13.2.13,1.13.2.14 Fixed HB-414 allow dialects to specify special types for identity types. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Fix Fors: 2.1.1 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 20 Jan 2004 12:02 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-01-20 06:04:09
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Tue, 20 Jan 2004 12:02 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate2/src/net/sf/hibernate/dialect Dialect.java,1.20.2.22,1.20.2.23 Informix9Dialect.java,1.1.2.1,1.1.2.2 Fixed HB-414 allow dialects to specify special types for identity types. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-414 Summary: Informix dialect creates syntax errors in IDS 9.4 Type: Bug Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Fix Fors: 2.1.1 Versions: 2.0.2 Assignee: Max Rydahl Andersen Reporter: Finn McCann Created: Tue, 21 Oct 2003 11:01 AM Updated: Tue, 20 Jan 2004 12:02 AM Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box. Description: Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues: 1. Serial ids: <id name="id" column="ID" length="32" unsaved-value="null"> <generator class="uuid.hex"/> </id> creates a data type: INT8 SERIAL instead of: SERIAL8 The "INT8 SERIAL" causes a syntax error in IDS 9.4. 2. Foreign Key constraint names: <set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc"> <key column="NETWORK_ID" length="32"/> <one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/> </set> creates this ALTER TABLE statement: alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK instead of: alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error. This also applies to adding UNIQUE CONSTRAINTs. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |