Hi All,
I have a Java Class, let's call it Bill that has a description field.
The description can be an unlimited number of sentences. I've modeled
this in mysql so that the Bill table has a text_id foreign key into the
Text table.
The java description is broken into multiple lines of 256 char each, and
then each block inserted into the Text table as a separate row, with an
id and a sequence number as the primary key. In this way many rows in
the Text table actually represents one description object in java.
So the question is, how do I map multiple database rows into one java
object (Description) that is then mapped to another java object
(Bill).this?
[Bill Table]
Bill Id
Name
...
Description id
[Text Table]
Description Id
Sequence
Value
---------------------------
A text table may look like this:
Description ID Sequence Value
1 1 This is the first part of the
long description
1 2 that explains what this bill is.
2 1 This is another long description
that belongs
2 2 to bill number two.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
