Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [teneo]:Newbie tutorial1 question
[teneo]:Newbie tutorial1 question [message #77913] Mon, 02 April 2007 22:30 Go to next message
Julia is currently offline JuliaFriend
Messages: 85
Registered: July 2009
Member
I'm struggling to get the tutorial1.java program to work for me. The
system does a rollback when it runs JpoxDataStore.createSchema.

2048205 [main] INFO JPOX.RDBMS - Creating index "WRITER_N49" in catalog
"" schema ""
2048205 [main] DEBUG JPOX.RDBMS.DDL - CREATE INDEX WRITER_N49 ON WRITER
(WRITERS_LIBRARY_ID_OID)
2048215 [main] DEBUG JPOX.RDBMS.DDL - Execution Time = 10 ms
2048225 [main] ERROR JPOX.RDBMS - An exception was thrown while
adding/validating class(es) : DB2 SQL error: SQLCODE: -104, SQLSTATE:
42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE:
42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
at com.ibm.db2.jcc.c.fg.b(fg.java:1160)

I'm using EMF 2.3 teneo 0.8 Eclipse 3.3 and DB2 v9 as my database. I know
that DB2 has not been tested with Teneo but that's the db I plan to use if
Teneo works out. I'm not sure if the problem is the database (I do see
tables are created before the rollback) or soemthing before that. Any
ideas?

btw where are the logs outputing to? I have saw a previous entry in the
newsgroup about it and I have the jars in the java build path and
log4j.properties under /src. I just can't find it.

Julia
Re: [teneo]:Newbie tutorial1 question [message #77929 is a reply to message #77913] Tue, 03 April 2007 08:03 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Julia,
My feel is that it is related to an invalid db constraint creation and not something in your
settings or so.

You can try to do the schema creation separately (outside of teneo):
http://www.jpox.org/docs/1_1/schematool.html#programmatic

It is also possible to dump the schema generation sql in a separate file (see in the top of the
schematool page) so you can try to manually create it in db2 itself.

gr. Martin

Julia wrote:
> I'm struggling to get the tutorial1.java program to work for me. The
> system does a rollback when it runs JpoxDataStore.createSchema.
>
> 2048205 [main] INFO JPOX.RDBMS - Creating index "WRITER_N49" in
> catalog "" schema ""
> 2048205 [main] DEBUG JPOX.RDBMS.DDL - CREATE INDEX WRITER_N49 ON WRITER
> (WRITERS_LIBRARY_ID_OID)
> 2048215 [main] DEBUG JPOX.RDBMS.DDL - Execution Time = 10 ms
> 2048225 [main] ERROR JPOX.RDBMS - An exception was thrown while
> adding/validating class(es) : DB2 SQL error: SQLCODE: -104, SQLSTATE:
> 42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE:
> 42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
> at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
> at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
>
> I'm using EMF 2.3 teneo 0.8 Eclipse 3.3 and DB2 v9 as my database. I
> know that DB2 has not been tested with Teneo but that's the db I plan to
> use if Teneo works out. I'm not sure if the problem is the database (I
> do see tables are created before the rollback) or soemthing before that.
> Any ideas?
>
> btw where are the logs outputing to? I have saw a previous entry in the
> newsgroup about it and I have the jars in the java build path and
> log4j.properties under /src. I just can't find it.
>
> Julia
>


--

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]:Newbie tutorial1 question [message #604188 is a reply to message #77913] Tue, 03 April 2007 08:03 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Julia,
My feel is that it is related to an invalid db constraint creation and not something in your
settings or so.

You can try to do the schema creation separately (outside of teneo):
http://www.jpox.org/docs/1_1/schematool.html#programmatic

It is also possible to dump the schema generation sql in a separate file (see in the top of the
schematool page) so you can try to manually create it in db2 itself.

gr. Martin

Julia wrote:
> I'm struggling to get the tutorial1.java program to work for me. The
> system does a rollback when it runs JpoxDataStore.createSchema.
>
> 2048205 [main] INFO JPOX.RDBMS - Creating index "WRITER_N49" in
> catalog "" schema ""
> 2048205 [main] DEBUG JPOX.RDBMS.DDL - CREATE INDEX WRITER_N49 ON WRITER
> (WRITERS_LIBRARY_ID_OID)
> 2048215 [main] DEBUG JPOX.RDBMS.DDL - Execution Time = 10 ms
> 2048225 [main] ERROR JPOX.RDBMS - An exception was thrown while
> adding/validating class(es) : DB2 SQL error: SQLCODE: -104, SQLSTATE:
> 42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE:
> 42601, SQLERRMC: CASCADE;ON UPDATE;RESTRICT, NO ACTION
> at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
> at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
>
> I'm using EMF 2.3 teneo 0.8 Eclipse 3.3 and DB2 v9 as my database. I
> know that DB2 has not been tested with Teneo but that's the db I plan to
> use if Teneo works out. I'm not sure if the problem is the database (I
> do see tables are created before the rollback) or soemthing before that.
> Any ideas?
>
> btw where are the logs outputing to? I have saw a previous entry in the
> newsgroup about it and I have the jars in the java build path and
> log4j.properties under /src. I just can't find it.
>
> Julia
>


--

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
Previous Topic:[teneo]:Newbie tutorial1 question
Next Topic:JET2 - multiple input models
Goto Forum:
  


Current Time: Wed Oct 21 14:23:53 GMT 2020

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

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

Back to the top