Return-Path: 
 <user-java-return-7973-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 76237 invoked from network); 18 Jul 2006 11:02:42 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 18 Jul 2006 11:02:42 -0000
Received: (qmail 85421 invoked by uid 500); 18 Jul 2006 11:02:41 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 85211 invoked by uid 500); 18 Jul 2006 11:02:40 -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 85200 invoked by uid 99); 18 Jul 2006 11:02:40 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Jul 2006 04:02:40 -0700
X-ASF-Spam-Status: No, hits=0.3 required=10.0
	tests=PLING_QUERY
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [212.159.14.131] (HELO pih-relay04.plus.net) (212.159.14.131)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Jul 2006 04:02:38 -0700
Received: from [212.159.113.189] (helo=[192.168.7.254])
	 by pih-relay04.plus.net with esmtp (Exim) id 1G2nLC-0003wz-GD
	for user-java@ibatis.apache.org; Tue, 18 Jul 2006 12:02:15 +0100
Date: Tue, 18 Jul 2006 12:02:11 +0100 (BST)
From: Graeme J Sweeney <ibatis.user@gjsweeney.com>
X-X-Sender: irnbru@localhost.localdomain
Reply-To: Graeme J Sweeney <ibatis.user@gjsweeney.com>
To: user-java@ibatis.apache.org
Subject: Re: How to map Timestamp with time zone column?!
In-Reply-To: <200607181233.47749.cijoml@volny.cz>
Message-ID: <Pine.LNX.4.64.0607181158350.2832@localhost.localdomain>
References: <200607141504.40045.cijoml@volny.cz>
 <200607181233.47749.cijoml@volny.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

On Tue, 18 Jul 2006, CIJOML wrote:

> newKontakt.setId_lokace('4');

<snip/>

>  Detail: Key (lokace_id_lokace)=(52) is not present in table "lokace".
> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on 
> table "kontakt" violates foreign key 
> constraint "kontakt_lokace_id_lokace_fkey"

<snip/>

> So time is OK, but when inserting, it looks for line 52?! I inserted 
> line 4 in lokace_id!!!
> 
> Any fix? Explanation?

'4' != 4

'4' is an ASCII charcter with decimal value 52.

Your value is converted from a charcter to an integer.

-- 
Graeme -