Re:

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Andres Olarte <olarte(dot)andres(at)gmail(dot)com>
Cc: vasylenko(at)uksatse(dot)org(dot)ua, pgsql-jdbc(at)postgresql(dot)org
Subject: Re:
Date: 2007-01-10 15:36:24
Message-ID: 635CFBA4-3FCD-4EAD-A444-7603F086CC3A@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Andres,

what he is looking for is to not have to select the id and still have
the rowset work.

Dave
On 10-Jan-07, at 9:26 AM, Andres Olarte wrote:

> You can do the same with JDBC. Don't set a value for your id column
> in the ResultSet. The backend will do it for you.
>
> On 1/10/07, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>> What you are looking for is in hibernate, or some other high level
>> persistence framework . In JDBC you have to do all the work.
>>
>> Dave
>>
>> On 10-Jan-07, at 8:16 AM, vasylenko(at)uksatse(dot)org(dot)ua wrote:
>>
>> >
>> >
>> > Such declaration like this
>> >
>> > id int4 NOT NULL DEFAULT nextval('seq_group_id'::regclass)
>> > and
>> > CONSTRAINT i_group PRIMARY KEY (id)
>> >
>> > give me the oportumity don't bother about unique value of id
>> > and use another query.
>> >
>> > INSERT INTO groups(g_name) VALUES("new group");
>> >
>> > I hope to find the same easy way in using ResultSet's objects (),
>> > i.e. to
>> > forget about id in my code until it nessesary for me and not for
>> jdbc.
>> >
>> > ---------------------------(end of
>> > broadcast)---------------------------
>> > TIP 1: if posting/reading through Usenet, please send an
>> appropriate
>> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that
>> > your
>> > message can get through to the mailing list cleanly
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

  • Re: at 2007-01-10 14:26:55 from Andres Olarte

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-01-11 04:57:57 Re: How to recoup the messages on the execution of a query
Previous Message Andres Olarte 2007-01-10 14:26:55 Re: