Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » Teneo @Index support
| Teneo @Index support [message #87056] |
Thu, 21 June 2007 15:27  |
Eclipse User |
|
|
|
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
|
|
|
| Re: Teneo @Index support [message #87071 is a reply to message #87056] |
Thu, 21 June 2007 18:12  |
| Eclipse User |
|
|
|
I have included this a few weeks ago in Teneo and have used it at a customer. So it's there but it
will be some time (a few weeks) before I can release a new build.
gr. Martin
Jason Henriksen wrote:
> 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
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: Teneo @Index support [message #87086 is a reply to message #87071] |
Thu, 21 June 2007 19:09 |
| Eclipse User |
|
|
|
Excellent. I'll definitely be excited to get that deployed.
Thank you for all of your work on this project,
Jason
"Martin Taal" <mtaal@elver.org> wrote in message
news:f5et4u$4jp$1@build.eclipse.org...
> I have included this a few weeks ago in Teneo and have used it at a
customer. So it's there but it
> will be some time (a few weeks) before I can release a new build.
>
> gr. Martin
>
> Jason Henriksen wrote:
> > 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
> >
> >
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal@springsite.com - mtaal@elver.org
> Web: www.springsite.com - www.elver.org
|
|
|
| Re: Teneo @Index support [message #607036 is a reply to message #87056] |
Thu, 21 June 2007 18:12 |
| Eclipse User |
|
|
|
I have included this a few weeks ago in Teneo and have used it at a customer. So it's there but it
will be some time (a few weeks) before I can release a new build.
gr. Martin
Jason Henriksen wrote:
> 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
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: Teneo @Index support [message #607037 is a reply to message #87071] |
Thu, 21 June 2007 19:09 |
| Eclipse User |
|
|
|
Excellent. I'll definitely be excited to get that deployed.
Thank you for all of your work on this project,
Jason
"Martin Taal" <mtaal@elver.org> wrote in message
news:f5et4u$4jp$1@build.eclipse.org...
> I have included this a few weeks ago in Teneo and have used it at a
customer. So it's there but it
> will be some time (a few weeks) before I can release a new build.
>
> gr. Martin
>
> Jason Henriksen wrote:
> > 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
> >
> >
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal@springsite.com - mtaal@elver.org
> Web: www.springsite.com - www.elver.org
|
|
|
Goto Forum:
Current Time: Wed May 21 07:16:32 EDT 2025
Powered by FUDForum. Page generated in 0.30393 seconds |
Home