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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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