Return-Path: 
 <user-java-return-11098-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 10320 invoked from network); 20 Mar 2007 16:48:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Mar 2007 16:48:25 -0000
Received: (qmail 36025 invoked by uid 500); 20 Mar 2007 16:48:23 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 36005 invoked by uid 500); 20 Mar 2007 16:48:23 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 35957 invoked by uid 99); 20 Mar 2007 16:48:23 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 09:48:23 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (herse.apache.org: local policy)
Received: from [212.159.14.212] (HELO ptb-relay01.plus.net) (212.159.14.212)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 09:48:11 -0700
Received: from [212.159.113.189] (helo=[192.168.7.254])
	 by ptb-relay01.plus.net with esmtp (Exim) id 1HThUy-0000Q1-Gz
	for user-java@ibatis.apache.org; Tue, 20 Mar 2007 16:47:48 +0000
Date: Tue, 20 Mar 2007 16:47:47 +0000 (GMT)
From: Graeme J Sweeney <ibatis.user@gjsweeney.com>
X-X-Sender: irnbru@localhost.localdomain
Reply-To: Graeme J Sweeney <ibatis.user@gjsweeney.com>
To: iBatis List <user-java@ibatis.apache.org>
Subject: Re: Postgres and generated keys
In-Reply-To: <427DDA97-B99E-42C7-9333-0112F024691A@ociweb.com>
Message-ID: <Pine.LNX.4.64.0703201645570.9126@localhost.localdomain>
References: <427DDA97-B99E-42C7-9333-0112F024691A@ociweb.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Checked: Checked by ClamAV on apache.org

On Tue, 20 Mar 2007, Mark Volkmann wrote:


> Perhaps I'm doing something wrong in my AbatorConfig.xml. Here's the part 
> that pertains to the address table.
>
>   <table schema="sal"
>     tableName="address" domainObjectName="Address">
>     <generatedKey column="id" sqlStatement="Postgres" identity="true"/>
>   </table>
>
> Is the value for the sqlStatement attribute wrong?

Something like .....

<generatedKey column="id" sqlStatement="SELECT nextVal('address_id_seq ')" identity="false" />

-- 
Graeme -