File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes Doubt - Oreilly - Page 107 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "Doubt - Oreilly - Page 107" Watch "Doubt - Oreilly - Page 107" New topic
Author

Doubt - Oreilly - Page 107

Niranjan Deshpande
Ranch Hand

Joined: Oct 16, 2005
Posts: 1277
Hi all,

Plesae refer Oreilly - Page 107

All the three things - pkColumnName valueColumnName pkColumnValue are confusing me.

Functionally, what is the difference between these three.

It would be great if some one draws a relevant table here and explains me


SCJP 1.4 - 95% [ My Story ] - SCWCD 1.4 - 91% [ My Story ]
Performance is a compulsion, not a option, if my existence is to be justified.
Alex Kikhtenko
Greenhorn

Joined: Feb 09, 2008
Posts: 5
Originally posted by Niranjan Deshpande:
Hi all,

Plesae refer Oreilly - Page 107

All the three things - pkColumnName valueColumnName pkColumnValue are confusing me.

Functionally, what is the difference between these three.

It would be great if some one draws a relevant table here and explains me


The schema is simple as a pie.

Have a look at the following table:



So, the layout is:
pkColumnName = "PK_COLUMN"
valueColumnName = "VALUE_COLUMN"
pkColumnValue = "DETERMINANT2" (for example)

The idea is each row in the table represents certain entity and there must be the way to distinguish between entities (3 entities in the preceding example)
[ February 09, 2008: Message edited by: Alex Kikhtenko ]
Niranjan Deshpande
Ranch Hand

Joined: Oct 16, 2005
Posts: 1277
Thanks for that..

But its still unclear to me !!

Please explain the schema keeping in mind the example entiy in oreilly.
Will be grateful

What is the CUST_ID in the Oreilly code? Please explain the schema with reference to the code in the book
Alex Kikhtenko
Greenhorn

Joined: Feb 09, 2008
Posts: 5
Ok. Let's consider the book's example with Customer entity.



Suppose we have another one entity Product:


As you can see we want the both entities to use the same table GENERATOR_TABLE to hold their Primary-Key-Next-Value.

Suppose also we've just persisted 3 Customer entities and 8 Product entities into the DB.

In this case the GENERATOR_TABLE table would look like:


So obviously CUST_ID is necessary to distinguish it's primary key value from primery key value of Product entity bean.

Hope this helps.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Doubt - Oreilly - Page 107