Teneo @Index support [message #607035] |
Thu, 21 June 2007 19:27 |
Jason Henriksen Messages: 231 Registered: July 2009 |
Senior Member |
|
|
My DBA wont allow me to use teneo to drive DB management unless I can
establish arbitrary indexes on columns. (This is completely reasonable
since we will be putting 52 million consumer records in to it)
It seems that this just isn't supported, but hopefully I just haven't found
the right way to do it.
<xsd:element name="SSN" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="teneo.jpa">
@Column(name="SSN",length="9")
@Index(name="IDX_CMR36013")
</xsd:appinfo>
<xsd:documentation>Social Security Number</xsd:documentation>
</xsd:annotation>
</xsd:element>
I've also tried:
<xsd:complexType name="Consumer">
<xsd:annotation><xsd:appinfo source="teneo.jpa">
@Table(
name="CMR3601T"
uniqueConstraints = { @UniqueConstraint(columnNames={"CONSUMER_SK"}),
@UniqueConstraint(columnNames={"CONSUMER_SK", "DATE_OF_BIRTH"})}
indexes = {
@Index(name="CMR36011", columnNames={"CONSUMER_SK"}),
@Index(name="CMR36016",
columnNames={"CONSUMER_SK","DATE_OF_BIRTH"}),
@Index(name="CMR36013", columnNames={"SSN"}),
@Index(name="CMR36014", columnNames={"DATE_OF_BIRTH"}),
@Index(name="CMR36015", columnNames={"CONSUMER_ID"})
}
)
</xsd:appinfo></xsd:annotation>
...
</xsd:complexType>
The unique constraints seem to work fine, but the indexes cause an
exception. Any help getting this work would be greatly appreciated. If it
isn't supported, is there anything I could do to help get it working?
Thanks very much,
Jason Henriksen
|
|
|
Powered by
FUDForum. Page generated in 0.03466 seconds