Re: AS400-DB2-JAVA SQLException error -7008 (solved)

For future reference as this might save you and others time in the
future... if instead of creating 'AS/400 objects' to test with, you created
'SQL objects', you don't have to worry about setting up journals and things
like that yourself.

That is, instead of crtlib, crtpf for you testing areas....

use the SQL statements create collection and create table.

The tables in the collection will have journals setup for you.

Richard D. Dettinger
AS/400 Java Data Access Team

Democracy's enemies have always underestimated the courage of the American
people.
It was true at Concord Bridge.  It was true at Pearl Harbor.  And it was
true today.

         Rochester Post-Bulletin
         Tuesday September 11, 2001


P.Goovaerts@Clipper.Be@midrange.com on 10/11/2001 08:05:39 AM

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   java400-l@midrange.com
cc:
Subject:  Re: AS400-DB2-JAVA SQLException error -7008 (solved)




After 4 day's of searching, writing mails, trial and tests... I found the
reason right under my nose...  I decided to try emulate the problem in
VAJAVA with Debugger.  This allowed me to find and read the complete
errordescription and explanation of this code 7008.    Error SQL7008, cause
(3) : JOURNALLING!

Yes, I never work on productionlibs directly when creating new
applications.  Surely not when it's in a domain which I'm still learning
(only working on it for a year...) and which is so complex as the whole
internet/intranet application development.  In other words : Java, Html,
SQL, Application Server, VAJAVA, Studio,...  I created a testfile in a
testlib on our AS400.  These are not journalled and therefore I cannot
update records in these files without commit(true) !

And, believe this or not...
When I was moving my lib and files in a journalled environment, I got a
message from Bruce Jin asking me if this file was journalled!  grrrrrr....
Should have put this question into java400-l@midrange.com 4 day's
earlier...


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.