Re: Postgresql serial type problem

[Okan Çetin]

thanks for reply.
Problem was solved.  I changed the xml file like this:

<insert id="insertEvent" parameterClass="Event">
    insert into PUBLIC.event (
      description
    )
    values (
      #event_id#,  #description#
    )
  </insert>

On 9/21/06, Daniel Pitts <[EMAIL PROTECTED] > wrote:

I would guess that you should omit event_id.  Instead setting it in your java code to the return valid of the insert() method.

---

From: Okan Çetin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2006 5:08 PM
To: user-java@ibatis.apache.org
Subject: Postgresql serial type problem

I have a table in postgresql and in this table there is a column that's type is serial. (event_id is serial )

I am adding data in this table like this;

<insert id="insertEvent" parameterClass="Event">
    insert into PUBLIC.event (
      event_id,
      description
    )
    values (
      #event_id#,  #description#
    )
  </insert>

Although the data is correctly inserted into the table, event_id column is empty. In database side, event_id's type is serial, there is no problem if I add data by manually, the event_id is automaticly increasing. In ibatis should I do some extra config to do this?

Thanks,
Okan.

--
~
otomatik oluşturuldu:
http://ocetin.net/log
http://linux.beykent.edu.tr

--
~
otomatik oluşturuldu:
http://ocetin.net/log
http://linux.beykent.edu.tr