Skip site navigation (1) Skip section navigation (2)

Re: sequences in JDBC

From: Dave Harkness <daveh(at)MEconomy(dot)com>
To: <nickf(at)ontko(dot)com>, "pgsql-jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: sequences in JDBC
Date: 2001-09-26 21:25:44
Message-ID: 5.1.0.14.2.20010926142226.00b1f7d0@mail.meconomy.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
At 01:47 PM 9/26/2001, Nick Fankhauser wrote:
>I'm trying to use a sequence via JDBC, but I'm having a problem.
>
>The prepared statement I'm using looks like this:
>
>final String address_lineInsert = "insert into address_line( address_id,
>address_line_id, address_line_text) values (?,?,?)";

The problem is that it is treating "nextval..." as a literal string and 
then trying to convert it to a number (as that is the column's type). You 
need to change it to this:

final String address_lineInsert = "insert into address_line( address_id, 
address_line_id, address_line_text) values (?, nextval('address_id_seq'), ?)";

This way Postgres will execute the nextval function as you wanted.

Peace,
Dave


In response to

Responses

pgsql-jdbc by date

Next:From: Nick FankhauserDate: 2001-09-26 21:29:57
Subject: Re: sequences in JDBC
Previous:From: Russ McBrideDate: 2001-09-26 21:20:44
Subject: connection error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group