[Teneo] Problem with the length of element names [message #93396] |
Thu, 16 August 2007 12:21  |
Eclipse User |
|
|
|
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)
|
|
|
|
Re: [Teneo] Problem with the length of element names [message #93506 is a reply to message #93431] |
Fri, 17 August 2007 09:16  |
Eclipse User |
|
|
|
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)
>>
>
>
|
|
|
Re: [Teneo] Problem with the length of element names [message #609473 is a reply to message #93396] |
Thu, 16 August 2007 13:46  |
Eclipse User |
|
|
|
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
|
|
|
Re: [Teneo] Problem with the length of element names [message #609478 is a reply to message #93431] |
Fri, 17 August 2007 09:16  |
Eclipse User |
|
|
|
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)
>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.07153 seconds