I tried to do it in this way: (using broker) but still no luck. I think
the problem is in sequencemanager or something like that. If I change
it to something else, it will do "CALL IDENTITY" to database.. As far
as I know, that nextval sequencer should do the same thing but for
postgresql and using sequences...
Any ideas?
- Joose
although, according to
http://db.apache.org/ojb/docu/howtos/howto-use-db-sequences.html I
perhaps should do it in another way?
repository.xml has like this:
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValIm
pl" />
and
<class-descriptor class="net.vettenranta.bean.Category"
table="categories">
<field-descriptor name="id"
jdbc-type="INTEGER"
primarykey="true"
default-fetch="true"
access="readonly"
column="id" />
<field-descriptor name="parent" column="parent"
jdbc-type="INTEGER"/>
</class-descriptor>
According to postgrel, only one INSERT happens, nothing else.
I'll try the example way to use broker... maybe that'll help
- Joose
20.7.2004 kello 18:05, Mike Ahlers kirjoitti:
But now.. just how do I update that bean to have that Id after insert?
Have your DAO return the (updated) bean and you shall see it has the
new Id already set.
--
Mike Ahlers
Hippo Webworks
Oosteinde 9
1017 WT Amsterdam
The Netherlands
Tel +31 (0)20 5224466
Fax +31 (0)20 5224467
---------------------------------------
[EMAIL PROTECTED] / www.hippo.nl
---------------------------------------
-----Original Message-----
From: Joose Vettenranta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 20, 2004 5:02 PM
To: [EMAIL PROTECTED]
Subject: Re: OJB + postgresql + "autoincrement"
And finding solution again.. Solution was to put that id field as
read-only.
But now.. just how do I update that bean to have that Id after insert?
- Joose
20.7.2004 kello 17:50, Joose Vettenranta kirjoitti:
Hi,
now that I got working the receiving point and inserting sort works..
but how do I use autoincrement thing in postgres? (using cocoon in
connection pooling).
inserting when id is not set, inserts 0 as id. which of course causes
error.
I tried to look that ojb example from wiki, but it didn't use cocoon
connection pool. Example file in cocoon source didn't have any
autoincrement in it.
Postgresql table is like this:
create table category ( id serial, parent integer );
Thanks, Joose
--
"Always remember that you are unique, just like everyone else!"
* http://iki.fi/joose/ * [EMAIL PROTECTED] * +358 44 561 0270 *
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
