users@glassfish.java.net

Re: Update on PK not allowed?

From: <glassfish_at_javadesktop.org>
Date: Thu, 09 Aug 2007 18:53:38 PDT

It's sort of relational database philosophy/theory. A database table is in theory like a sparse array, indexed not by a number but by the possible values in its primary key. Each table is - in principle - infinite in size, although in reality only a certain number of array cells will ever be filled; and each cell - in principle - does not "have" a primary key as data, but the primary key is the location of the cell in a logical space.

With an array, you can't simply say "array element 5 is now array element 6". You can only move the data from one cell to another. Same goes for a table.

In principle.
[Message sent by forum member 'pmurray_bigpond' (pmurray_bigpond)]

http://forums.java.net/jive/thread.jspa?messageID=230369