Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [Teneo] Problem with the length of element names
[Teneo] Problem with the length of element names [message #93396] Thu, 16 August 2007 16:21 Go to next message
Dimitar Stamenov is currently offline Dimitar StamenovFriend
Messages: 18
Registered: July 2009
Junior Member
I have a problem with the length of the element names in the EMF model -
Teneo complains that it cannot add class tables. I am using DB2 - is it
a specific DB2 problem or it can be fixed in Teneo?

DB2 SQLSTATE 42622 means that the name is too long.

Thanks in advance for your help.

Here is the stack trace:

[java] Exception in thread "main" javax.jdo.JDODataStoreException:
Error(s) were found while auto-creating/validating the
datastore for classes. The errors are printed in the log, and are
attached to this exception.
[java] at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RD BMSManager.java:3272)
[java] at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesA ndValidate(RDBMSManager.java:3322)
[java] at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManage r.java:2554)
[java] at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RD BMSManager.java:2406)
[java] at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.ja va:821)
[java] at
org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:518)
[java] at
org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:213)
[java] at
DatastoreInstall.initJpoxDatastore(DatastoreInstall.java:120 )
[java] at DatastoreInstall.init(DatastoreInstall.java:61)
[java] at DatastoreInstall.main(DatastoreInstall.java:327)
[java] NestedThrowablesStackTrace:
[java] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
-107, SQLSTATE: 42622, SQLERRMC: MYELEMENT_CATEGORYMEMBER
;18
[java] at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
[java] at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
[java] at com.ibm.db2.jcc.b.gb.h(gb.java:217)
[java] at com.ibm.db2.jcc.b.gb.b(gb.java:46)
[java] at com.ibm.db2.jcc.b.w.b(w.java:40)
[java] at com.ibm.db2.jcc.b.vb.f(vb.java:118)
[java] at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
[java] at com.ibm.db2.jcc.c.fg.a(fg.java:1865)
[java] at com.ibm.db2.jcc.c.fg.e(fg.java:737)
[java] at com.ibm.db2.jcc.c.fg.execute(fg.java:721)

Report message to a moderator

Re: [Teneo] Problem with the length of element names [message #93431 is a reply to message #93396] Thu, 16 August 2007 17:46 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Dimitar,
See here: http://www.elver.org/jpox/jpoxdatastore.html#SQL+Naming+Rela ted+Options. Please note the
description on programmatically generating the jdo file on this same page. See also here for more
possibilities to extend the sql naming strategy:
http://www.elver.org/jpox/extensions.html

btw, I will look at your post about the exception tomorrow morning.

gr. Martin

Dimitar Stamenov wrote:
> I have a problem with the length of the element names in the EMF model -
> Teneo complains that it cannot add class tables. I am using DB2 - is it
> a specific DB2 problem or it can be fixed in Teneo?
>
> DB2 SQLSTATE 42622 means that the name is too long.
>
> Thanks in advance for your help.
>
> Here is the stack trace:
>
> [java] Exception in thread "main" javax.jdo.JDODataStoreException:
> Error(s) were found while auto-creating/validating the
> datastore for classes. The errors are printed in the log, and are
> attached to this exception.
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RD BMSManager.java:3272)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesA ndValidate(RDBMSManager.java:3322)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManage r.java:2554)
> [java] at
> org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RD BMSManager.java:2406)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.ja va:821)
> [java] at
> org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:518)
>
> [java] at
> org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:213)
> [java] at
> DatastoreInstall.initJpoxDatastore(DatastoreInstall.java:120 )
> [java] at DatastoreInstall.init(DatastoreInstall.java:61)
> [java] at DatastoreInstall.main(DatastoreInstall.java:327)
> [java] NestedThrowablesStackTrace:
> [java] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
> -107, SQLSTATE: 42622, SQLERRMC: MYELEMENT_CATEGORYMEMBER
> ;18
> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
> [java] at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
> [java] at com.ibm.db2.jcc.b.gb.h(gb.java:217)
> [java] at com.ibm.db2.jcc.b.gb.b(gb.java:46)
> [java] at com.ibm.db2.jcc.b.w.b(w.java:40)
> [java] at com.ibm.db2.jcc.b.vb.f(vb.java:118)
> [java] at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
> [java] at com.ibm.db2.jcc.c.fg.a(fg.java:1865)
> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:737)
> [java] at com.ibm.db2.jcc.c.fg.execute(fg.java:721)
>


--

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

Report message to a moderator

Re: [Teneo] Problem with the length of element names [message #93506 is a reply to message #93431] Fri, 17 August 2007 13:16 Go to previous message
Dimitar Stamenov is currently offline Dimitar StamenovFriend
Messages: 18
Registered: July 2009
Junior Member
Hi Martin,

Thanks for the advice - it really helped me to solve the problem. I have
changed the property JOIN_COLUMN_NAMING_STRATEGY to "simple" and
MAXIMUM_SQL_NAME_LENGTH to 18.

Martin Taal wrote:
> Hi Dimitar,
> See here:
> http://www.elver.org/jpox/jpoxdatastore.html#SQL+Naming+Rela ted+Options.
> Please note the description on programmatically generating the jdo file
> on this same page. See also here for more possibilities to extend the
> sql naming strategy:
> http://www.elver.org/jpox/extensions.html
>
> btw, I will look at your post about the exception tomorrow morning.
>
> gr. Martin
>
> Dimitar Stamenov wrote:
>> I have a problem with the length of the element names in the EMF model
>> - Teneo complains that it cannot add class tables. I am using DB2 - is
>> it a specific DB2 problem or it can be fixed in Teneo?
>>
>> DB2 SQLSTATE 42622 means that the name is too long.
>>
>> Thanks in advance for your help.
>>
>> Here is the stack trace:
>>
>> [java] Exception in thread "main"
>> javax.jdo.JDODataStoreException: Error(s) were found while
>> auto-creating/validating the
>> datastore for classes. The errors are printed in the log, and are
>> attached to this exception.
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RD BMSManager.java:3272)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesA ndValidate(RDBMSManager.java:3322)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManage r.java:2554)
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RD BMSManager.java:2406)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.ja va:821)
>> [java] at
>> org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:518)
>>
>> [java] at
>> org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:213)
>>
>> [java] at
>> DatastoreInstall.initJpoxDatastore(DatastoreInstall.java:120 )
>> [java] at DatastoreInstall.init(DatastoreInstall.java:61)
>> [java] at DatastoreInstall.main(DatastoreInstall.java:327)
>> [java] NestedThrowablesStackTrace:
>> [java] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
>> -107, SQLSTATE: 42622, SQLERRMC: MYELEMENT_CATEGORYMEMBER
>> ;18
>> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
>> [java] at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
>> [java] at com.ibm.db2.jcc.b.gb.h(gb.java:217)
>> [java] at com.ibm.db2.jcc.b.gb.b(gb.java:46)
>> [java] at com.ibm.db2.jcc.b.w.b(w.java:40)
>> [java] at com.ibm.db2.jcc.b.vb.f(vb.java:118)
>> [java] at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
>> [java] at com.ibm.db2.jcc.c.fg.a(fg.java:1865)
>> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:737)
>> [java] at com.ibm.db2.jcc.c.fg.execute(fg.java:721)
>>
>
>

Report message to a moderator

Re: [Teneo] Problem with the length of element names [message #609473 is a reply to message #93396] Thu, 16 August 2007 17:46 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Dimitar,
See here: http://www.elver.org/jpox/jpoxdatastore.html#SQL+Naming+Rela ted+Options Please note the
description on programmatically generating the jdo file on this same page. See also here for more
possibilities to extend the sql naming strategy:
http://www.elver.org/jpox/extensions.html

btw, I will look at your post about the exception tomorrow morning.

gr. Martin

Dimitar Stamenov wrote:
> I have a problem with the length of the element names in the EMF model -
> Teneo complains that it cannot add class tables. I am using DB2 - is it
> a specific DB2 problem or it can be fixed in Teneo?
>
> DB2 SQLSTATE 42622 means that the name is too long.
>
> Thanks in advance for your help.
>
> Here is the stack trace:
>
> [java] Exception in thread "main" javax.jdo.JDODataStoreException:
> Error(s) were found while auto-creating/validating the
> datastore for classes. The errors are printed in the log, and are
> attached to this exception.
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RD BMSManager.java:3272)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesA ndValidate(RDBMSManager.java:3322)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManage r.java:2554)
> [java] at
> org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RD BMSManager.java:2406)
>
> [java] at
> org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.ja va:821)
> [java] at
> org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:518)
>
> [java] at
> org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:213)
> [java] at
> DatastoreInstall.initJpoxDatastore(DatastoreInstall.java:120 )
> [java] at DatastoreInstall.init(DatastoreInstall.java:61)
> [java] at DatastoreInstall.main(DatastoreInstall.java:327)
> [java] NestedThrowablesStackTrace:
> [java] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
> -107, SQLSTATE: 42622, SQLERRMC: MYELEMENT_CATEGORYMEMBER
> ;18
> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
> [java] at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
> [java] at com.ibm.db2.jcc.b.gb.h(gb.java:217)
> [java] at com.ibm.db2.jcc.b.gb.b(gb.java:46)
> [java] at com.ibm.db2.jcc.b.w.b(w.java:40)
> [java] at com.ibm.db2.jcc.b.vb.f(vb.java:118)
> [java] at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
> [java] at com.ibm.db2.jcc.c.fg.a(fg.java:1865)
> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:737)
> [java] at com.ibm.db2.jcc.c.fg.execute(fg.java:721)
>


--

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

Report message to a moderator

Re: [Teneo] Problem with the length of element names [message #609478 is a reply to message #93431] Fri, 17 August 2007 13:16 Go to previous message
Dimitar Stamenov is currently offline Dimitar StamenovFriend
Messages: 18
Registered: July 2009
Junior Member
Hi Martin,

Thanks for the advice - it really helped me to solve the problem. I have
changed the property JOIN_COLUMN_NAMING_STRATEGY to "simple" and
MAXIMUM_SQL_NAME_LENGTH to 18.

Martin Taal wrote:
> Hi Dimitar,
> See here:
> http://www.elver.org/jpox/jpoxdatastore.html#SQL+Naming+Rela ted+Options
> Please note the description on programmatically generating the jdo file
> on this same page. See also here for more possibilities to extend the
> sql naming strategy:
> http://www.elver.org/jpox/extensions.html
>
> btw, I will look at your post about the exception tomorrow morning.
>
> gr. Martin
>
> Dimitar Stamenov wrote:
>> I have a problem with the length of the element names in the EMF model
>> - Teneo complains that it cannot add class tables. I am using DB2 - is
>> it a specific DB2 problem or it can be fixed in Teneo?
>>
>> DB2 SQLSTATE 42622 means that the name is too long.
>>
>> Thanks in advance for your help.
>>
>> Here is the stack trace:
>>
>> [java] Exception in thread "main"
>> javax.jdo.JDODataStoreException: Error(s) were found while
>> auto-creating/validating the
>> datastore for classes. The errors are printed in the log, and are
>> attached to this exception.
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RD BMSManager.java:3272)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesA ndValidate(RDBMSManager.java:3322)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManage r.java:2554)
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RD BMSManager.java:2406)
>>
>> [java] at
>> org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.ja va:821)
>> [java] at
>> org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:518)
>>
>> [java] at
>> org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:213)
>>
>> [java] at
>> DatastoreInstall.initJpoxDatastore(DatastoreInstall.java:120 )
>> [java] at DatastoreInstall.init(DatastoreInstall.java:61)
>> [java] at DatastoreInstall.main(DatastoreInstall.java:327)
>> [java] NestedThrowablesStackTrace:
>> [java] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
>> -107, SQLSTATE: 42622, SQLERRMC: MYELEMENT_CATEGORYMEMBER
>> ;18
>> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
>> [java] at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
>> [java] at com.ibm.db2.jcc.b.gb.h(gb.java:217)
>> [java] at com.ibm.db2.jcc.b.gb.b(gb.java:46)
>> [java] at com.ibm.db2.jcc.b.w.b(w.java:40)
>> [java] at com.ibm.db2.jcc.b.vb.f(vb.java:118)
>> [java] at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
>> [java] at com.ibm.db2.jcc.c.fg.a(fg.java:1865)
>> [java] at com.ibm.db2.jcc.c.fg.e(fg.java:737)
>> [java] at com.ibm.db2.jcc.c.fg.execute(fg.java:721)
>>
>
>

Report message to a moderator

Previous Topic:Teneo - Migrating 0.75 to 0.8
Next Topic:[TENEO] Multiple instances using concurrently the same database?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 20 02:34:09 GMT 2022

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly