Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-dev] bug 326968 - size of compound key of the entity TelephoneNumber exceeds MaxDBs limit

Hi Tom, all,

https://bugs.eclipse.org/bugs/show_bug.cgi?id=326968

https://bugs.eclipse.org/bugs/attachment.cgi?id=180245

Sorry for bothering you again but it turned out that the PK sizes of the entities 

org.eclipse.persistence.testing.models.jpa.ddlgeneration.CKeyEntityA,
CKeyEntityB and CKeyEntityC 

also exceed the limit on MaxDB. This affects three tests in the DDLGenerationJUnitTestSuite:

.testDDLUniqueKeysAsJoinColumns 
.testDDLUnidirectionalOneToMany 
.testManyToManyWithMultipleJoinColumns

Specifying a length for the PK components solves the issue. Do you have objections to do so?

-Adrian


SAP AG
Dietmar-Hopp-Allee 16, 69190 Walldorf, Germany

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, John Schwarz, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
 

> -----Ursprüngliche Nachricht-----
> Von: eclipselink-dev-bounces@xxxxxxxxxxx 
> [mailto:eclipselink-dev-bounces@xxxxxxxxxxx] Im Auftrag von 
> Goerler, Adrian
> Gesendet: Dienstag, 5. Oktober 2010 15:25
> An: Dev mailing list for Eclipse Persistence Services
> Betreff: [eclipselink-dev] bug 326968 - size of compound key 
> of the entity TelephoneNumber exceeds MaxDBs limit
> 
> Hi,
> 
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=326968
> 
> tested on MaxDB -> OK
> reviewed by Tom
> checked in in trunk.
> 
> -Adrian
> 
> SAP AG
> Dietmar-Hopp-Allee 16, 69190 Walldorf, Germany
> 
> Sitz der Gesellschaft/Registered Office: Walldorf, Germany
> Vorstand/SAP Executive Board: Henning Kagermann 
> (Sprecher/CEO), Léo Apotheker (stellvertretender 
> Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard 
> Oswald, John Schwarz, Peter Zencke
> Vorsitzender des Aufsichtsrats/Chairperson of the SAP 
> Supervisory Board: Hasso Plattner
> Registergericht/Commercial Register Mannheim No HRB 350269
>  
> 
> > -----Ursprüngliche Nachricht-----
> > Von: Tom Ware [mailto:tom.ware@xxxxxxxxxx] 
> > Gesendet: Dienstag, 5. Oktober 2010 14:36
> > An: Goerler, Adrian
> > Cc: Dev mailing list for Eclipse Persistence Services
> > Betreff: Re: bug 326968
> > 
> > Hi Adrian,
> > 
> >    The patch looks reasonable to me.
> > 
> > -Tom
> > 
> > Goerler, Adrian wrote:
> > > Hi Tom, all,
> > >  
> > > _https://bugs.eclipse.org/bugs/show_bug.cgi?id=326968_
> > >  
> > > MaxDB has a limit for an index width of 1024 bytes. With 
> > UTF8 (what we 
> > > suggest to use on MaxDB), the PK of the entity
> > >  
> > > 
> > org.eclipse.persistence.testing.models.jpa.xml.merge.inherited
> > .TelephoneNumber
> > >  
> > > exceeds this limit. I am suggesting to limit the length of 
> > the index 
> > > columns in order to make the index narrower.
> > >  
> > > What do you think?
> > >  
> > > -Adrian
> > >  
> > >  
> > > SAP AG
> > > Dietmar-Hopp-Allee 16, 69190 Walldorf, Germany
> > >  
> > > Sitz der Gesellschaft/Registered Office: Walldorf, Germany
> > > Vorstand/SAP Executive Board: Henning Kagermann 
> (Sprecher/CEO), Léo 
> > > Apotheker (stellvertretender Sprecher/Deputy CEO), Werner 
> > Brandt, Claus 
> > > Heinrich, Gerhard Oswald, John Schwarz, Peter Zencke
> > > Vorsitzender des Aufsichtsrats/Chairperson of the SAP 
> > Supervisory Board: 
> > > Hasso Plattner
> > > Registergericht/Commercial Register Mannheim No HRB 350269
> > >  
> > >  
> > 
> _______________________________________________
> eclipselink-dev mailing list
> eclipselink-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-dev
> 

Back to the top