|
Re: [teneo]:Newbie tutorial1 question [message #77929 is a reply to message #77913] |
Tue, 03 April 2007 08:03 |
Martin Taal 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 |
Martin Taal 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
|
|
|
Powered by
FUDForum. Page generated in 0.03072 seconds