Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » Teneo @Index support
Teneo @Index support [message #607035] Thu, 21 June 2007 19:27
Jason Henriksen is currently offline Jason HenriksenFriend
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
Previous Topic:[Teneo] Identifier for my objects
Next Topic:Teneo @Index support
Goto Forum:
  


Current Time: Thu Mar 28 09:57:47 GMT 2024

Powered by FUDForum. Page generated in 0.03466 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top