Re: [SQL7008] URLGROUP in TEFF not valid for operation.

Thank You, Thank You, Thank You!!!  That did the trick. What I don't
understand is why I didn't get the same problem with another file that
was also not being journalled. This is one lesson I won't forget soon.

Joe Teff



>Every time I have seen this message, it is because the file is not
>journaled (e.g. it wasn't created as part of a collection through SQL;
>probably was created using DDS).  When using SQL and the default isolation
>level (or generally any isolation level other than NONE), an insert or
>update requires that the file be journaled (CRTJRNRCV, CRTJRN, then
>STRJRNPF).  Sorry for the brevity.
>
>Frances Stewart
>
>
>"Joe Teff" <joeteff@earthlink.net> on 04/29/2000 01:50:03 AM
>
>Please respond to JAVA400-L@midrange.com
>
>To:   JAVA400-L@midrange.com, "Ignite400" <ign_list@ignite400.org>
>cc:
>Subject:  [SQL7008] URLGROUP in TEFF not valid for operation.
>
>
>
>
>I am connecting to an AS/400 using
>
>   DriverManager.registerDriver(new
>com.ibm.as400.access.AS400JDBCDriver());
>   con = DriverManager.getConnection("jdbc:as400://xxx.xxx.xxx.xxx");
>
><my IP here>
>
>This prompts me for a user id & password and connects. Then I build a
>listbox with the contents of a file and this works great. When I try to add
>a record, I get the SQL error. My statement is
>
>   addSql = con.prepareStatement("INSERT INTO TEFF.URLGROUP (R1KEY, R1DESC)
>VALUES(?, ?)");
>
>In my add logic I do
>
>   try {
>   addSql.setInt(1, nextKey);
>   addSql.setString(2, edtField.getText());
>   addSql.executeUpdate();
>   }
>
>These are the only two fields in the file. I use an SQL statement prior
>to the add that gets MAX(R1KEY) and I add 1 to that. I've printed this
>value to the console and it is correct.
>
>I checked security and everything looks fine. I can't find any
>documentation
>on this SQL error except that the SQL State is 55019. Can anyone help me
>here or at least point me in the right direction. Thanks.
>
>Joe Teff
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---
>
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---
>

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---