Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 19670 invoked from network); 25 Feb 2006 00:49:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Feb 2006 00:49:13 -0000 Received: (qmail 24329 invoked by uid 500); 25 Feb 2006 00:49:11 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 24311 invoked by uid 500); 25 Feb 2006 00:49:10 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 24300 invoked by uid 99); 25 Feb 2006 00:49:10 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Feb 2006 16:49:10 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [216.130.242.22] (HELO fusion04.fusionmail.net) (216.130.242.22) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Feb 2006 16:49:09 -0800 Received: by fusion04.fusionmail.net with Internet Mail Service (5.5.2657.72) id ; Fri, 24 Feb 2006 18:48:48 -0600 Message-ID: From: Davis Chapman To: "'user-java@ibatis.apache.org'" Subject: Problem with Insert Date: Fri, 24 Feb 2006 18:48:42 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I'm running into a perplexing problem. I'm trying to replace a homegrown DOA with iBatis in an application running against DB2 on an AS/400. All of my selects are running fine. But when I try to run an Insert statement, I get the following error: Caused by: java.sql.SQLException: [SQL7008] ECEP in T0MD618D not valid for operation. Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: I've double checked everything I can think of. I'm connecting with the correct credentials, etc. I've used iBatis extensively in other projects with lots of success, but this has me baffled. Any ideas what could be wrong? Thanks, Davis Chapman