DESCRIPTION:
The name of the constraint is taking account except for the unique
constraint.
To be able to generate a naming index in the schema generation for
Oracle schema definition like this:
CREATE TABLE TEST
(
ID INT NOT NULL,
NAME VARCHAR2 (255)
CONSTRAINT MY_UNIQUE_1 UNIQUE (NAME)
)
The attribute name in the XML definition file must be take into account,
two Java classes have to be modified Unique.java and Table.java.
And the Unique.vm file for Oracle.
Diffs:
Index: ./src/java/org/apache/turbine/torque/engine/database/model/Table.java
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-2/src/java/org/apache/turbine/torque/engine/
database/model/Table.java,v
retrieving revision 1.2
diff -u -r1.2 Table.java
--- ./src/java/org/apache/turbine/torque/engine/database/model/Table.java
2001/08/20 02:49:31 1.2
+++ ./src/java/org/apache/turbine/torque/engine/database/model/Table.java
2001/11/21 18:58:08
@@ -410,6 +410,7 @@
public Unique addUnique(Attributes attrib)
{
Unique unique = new Unique();
+ unique.loadFromXML(attrib);
addUnique (unique);
return unique;
}
Index:
./src/java/org/apache/turbine/torque/engine/database/model/Unique.java
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-2/src/java/org/apache/turbine/torque/engine/
database/model/Unique.java,v
retrieving revision 1.1.1.1
diff -r1.1.1.1 Unique.java
96a97,105
> * Get the name of the unique index
> */
> public String getIndexName()
> {
> return indexName;
> }
>
>
> /**
156a166,176
>
> /**
> * Imports a column from an XML specification
> */
> public void loadFromXML (Attributes attrib)
> {
> //Name
> indexName = attrib.getValue("name");
>
> }
>
Index: ./conf/torque/templates/sql/base/oracle/unique.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-2/conf/torque/templates/sql/base/oracle/uniq
ue.vm,v
retrieving revision 1.1.1.1
diff -r1.1.1.1 unique.vm
2,3c2,4
< UNIQUE ($unique.ColumnList),
< #end
\ No newline at end of file
---
> CONSTRAINT $unique.IndexName UNIQUE ($unique.ColumnList),
> #end
>
Eric Theroude
Project Manager, Paris - France
iMediation - http://www.imediation.com
Disclaimer: All the opinions expressed above are mine and not those from my
company.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
