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
>
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: |