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

getGeneratedKeys method

From: Ceki Gulcu <cekgul(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: getGeneratedKeys method
Date: 2004-05-26 11:56:32
Message-ID: 20040526115632.87009.qmail@web51008.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello,

We, the log4j developers, are working on an appender
that will write
log4j events to various RDBMS Various fields of an
event object will
go to 3 different tables, namely the logging_event
table, the
logging_event_property table and the
logging_event_exception
table. Each entry in the logging_event_property and
the
logging_event_exception tables uses a reference to
event_id, where
event_id is a database generated primary key in the
logging_event
table.

For entries in the logging_event_property and
logging_event_exception
tables to be meaningful, we absolutely need the
generated event_id
each time we insert a new logging_event row. We are
able to do this by
following each logging_event insertion with a query to
the database
asking for the event_id of the last inserted event.
This works for
multiple database systems.

However, we have discovered that batching multiple
insertions gives a
very significant boost in performance. Thus, we would
like to insert
say 50 logging_event rows, then multiple
logging_event_property rows
and then multiple logging_event_exception rows. We are
using the
JDBC getGeneratedKeys method to obtain the event_ids.
Unfortunately, this
function is not implemented in Postgresql.


Looking at the archives it seems that this
functionality requires
support for the database back end which does not exist
currently. Is
that correct?

Is there another way to insert into multiple tables in
batches as
described above without using the JDBC
getGeneratedKeys  method?

Your views on the matter would be highly appreciated.
Thanking you
in advance,


-- 
Ceki Glc

     For log4j documentation consider "The complete
log4j manual" 
     ISBN: 2970036908
http://www.qos.ch/shop/products/clm_t.jsp 



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2004-05-26 12:11:51
Subject: Re: getGeneratedKeys method
Previous:From: Sharib AnisDate: 2004-05-26 09:35:27
Subject: Postgresql 7.4.2 and OutOfMemoryError

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