Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 15487 invoked from network); 13 Apr 2004 05:02:21 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 13 Apr 2004 05:02:21 -0000 Received: (qmail 21414 invoked by uid 500); 13 Apr 2004 05:01:52 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 21154 invoked by uid 500); 13 Apr 2004 05:01:51 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: users@cocoon.apache.org Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 21140 invoked from network); 13 Apr 2004 05:01:50 -0000 Received: from unknown (HELO smtp804.mail.sc5.yahoo.com) (66.163.168.183) by daedalus.apache.org with SMTP; 13 Apr 2004 05:01:50 -0000 Received: from unknown (HELO alpha) (uchenna@sbcglobal.net@67.119.10.36 with login) by smtp804.mail.sc5.yahoo.com with SMTP; 13 Apr 2004 05:02:01 -0000 From: "Uchenna Igwebuike" To: Subject: RE: CForms(woody) ad hibernate design advice needed Date: Mon, 12 Apr 2004 22:01:53 -0700 Message-ID: <007601c42114$7008bd60$6500a8c0@alpha> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0077_01C420D9.C3A9E560" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <000401c420ff$bf0d84a0$6601a8c0@JOEL> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0077_01C420D9.C3A9E560 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I do the same thing with Entity Beans, by doing a net change ie update all records contained in the repeater, insert any new ones and delete(or deactivate) the missing ones. This way I don't loose the object identity (surrogate key) generated the first time that it is created, as this helps preserve the audit trail. -----Original Message----- From: Joel McConaughy [mailto:joel@displayware.com] Sent: Monday, April 12, 2004 7:34 PM To: users@cocoon.apache.org Subject: CForms(woody) ad hibernate design advice needed I need to develop a large number of database maintenance pages with create/read/update/delete functionality (e.g. users, items, regions, etc.). Repeater widgets and actions provide an easy way to display multiple rows and edit them in place. However, it seems like the only simple way to update a database is to delete every row and then re-insert the contents of the repeater. This unfortunately doesn't scale with large results sets. Is there a better way? Thanks in advance. Fyi, I'm planning to use hibernate from flow for serialization (thanks Hugo for the samples!). joel Joel McConaughy Managing Partner Displayware 800 Fifth Ave., #101-316 Seattle, WA 98104-3191 206-300-4732 Direct 206-382-2188 Fax joel@displayware.com ------=_NextPart_000_0077_01C420D9.C3A9E560 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable CForms(woody) ad hibernate design advice needed

I do the same thing with Entity Beans, by doing a net change ie update all records contained in the repeater, insert any new ones and delete(or deactivate) the missing ones. This way I don’t loose the object = identity (surrogate key) generated the first time that it is created, as this = helps preserve the audit trail.

 

-----Original = Message-----
From: Joel McConaughy [mailto:joel@displayware.com]
Sent: Monday, April 12, = 2004 7:34 PM
To: = users@cocoon.apache.org
Subject: CForms(woody) ad hibernate design advice needed

 

I need to develop a large number of database maintenance pages with create/read/update/delete functionality (e.g. = users, items, regions, etc.).  Repeater widgets and actions provide an = easy way to display multiple rows and edit them in place.  However, it seems = like the only simple way to update a database is to delete every row and then re-insert the contents of the repeater.  This unfortunately doesn't = scale with large results sets.  Is there a better way?  Thanks in = advance.

Fyi, I'm planning to use hibernate from flow = for serialization (thanks Hugo for the samples!). =

joel

Joel = McConaughy
Managing Partner
Displayware
800 Fifth Ave., #101-316
Seattle, WA 98104-3191
206-300-4732 Direct
206-382-2188 Fax
joel@displayware.com<= /font>

------=_NextPart_000_0077_01C420D9.C3A9E560--