Re: How to map Timestamp with time zone column?!

2006-07-18 Thread Graeme J Sweeney
On Tue, 18 Jul 2006, CIJOML wrote: newKontakt.setId_lokace('4'); 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"

Re: How to map Timestamp with time zone column?!

2006-07-18 Thread CIJOML
Hi All, I fixed XML file, so now I have same number of columns as variables :))) I also rewrite Kontakt.class to be unix_time as Date Now I am trying insert this: //KONTAKT - nejde vlozit TIME!!! Kontakt newKontakt = new Kontakt(); newKontakt.setId_kontakt('3'); newKontakt.setId_administrator('

How to map Timestamp with time zone column?!

2006-07-14 Thread CIJOML
Hi All, I am trying map Timestamp with time zone column to ibatis, but without success. Database is Postgresql 8.1.4. http://www.ibatis.com/dtd/sql-map-2.dtd";> SELECT ID_KONTAKT as id_kontakt, ADMINISTRATOR_ID_ADMINISTRATOR as id_administrator,