Re: AS400-DB2-JAVA SQLException error -7008

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

 Are you journaling the file being updated?
Bruce
----- Original Message -----
From: <P.Goovaerts@Clipper.Be>
To: <java400-l@midrange.com>
Sent: Thursday, October 11, 2001 12:07 AM
Subject: AS400-DB2-JAVA SQLException error -7008


When I execute an 'update' SQL statement with setAutoCommit(true) it works.
When I do same with setAutoCommit(false) I get an SQLException... WHY????

try
{
   System.out.println("Retrieving: "+keyInCC+" "+keyInYY+" "+keyInMM+" "
+keyInDD+" "+keySequence);
   // Create statement and Read record
   psPerKeyInput =clipper.prepareStatement("SELECT * FROM JAVA.UPBOKINTST
WHERE BRDICC= AND BRDIJJ= AND BRDIMM =? AND BRDIDD =? AND BRRENR =
 ?");
   psPerKeyInput.setShort(1,(keyInCC));
   psPerKeyInput.setShort(2,(keyInYY));
   psPerKeyInput.setShort(3,(keyInMM));
   psPerKeyInput.setShort(4,(keyInDD));
   psPerKeyInput.setInt(5,(keySequence));
   rs =psPerKeyInput.executeQuery();
   System.out.println("Record Retrieved: "+keyInCC+" "+keyInYY+" "
+keyInMM+" "+keyInDD+" "+keySequence+" successfully");

// Update record to see if it's free
clipper.setAutoCommit(false);
System.out.println("Updating : "+keyInCC+" "+keyInYY+" "+keyInMM+"
"+keyInDD+" "+keySequence);
psUpdateRecord =clipper.prepareStatement("UPDATE JAVA.UPBOKINTST SET
BRSTAT= WHERE BRDICC= AND BRDIJJ= AND
  BRDIMM =? AND BRDIDD =? AND BRRENR =?");
psUpdateRecord.setString(1,("TR"));
psUpdateRecord.setShort(2,(keyInCC));
psUpdateRecord.setShort(3,(keyInYY));
psUpdateRecord.setShort(4,(keyInMM));
psUpdateRecord.setShort(5,(keyInDD));
psUpdateRecord.setInt(6,(keySequence));
psUpdateRecord.executeUpdate();
System.out.println("Record Updated : "+keyInCC+" "+keyInYY+" "
+keyInMM+" "+keyInDD+" "+keySequence+" successfully");
}
catch (SQLException e)
{
aFreightQuotation =null;
System.out.println("problem with record retrieval because error: " +
e.getErrorCode());
 }

_______________________________________________
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.