Hi, my scenerio is:

table product
(
product_id int,
name varchar(20)
)

table product_description
(
product_id int,
lang_id smallint,
description
)

I want to have a class FullProduct which have a "composite-id" of product_id and lang_id. The class will look like this...

public class FullProduct
{
class PK() {...} // inner class
PK pk;
String name,
String description
}

I can do this easily with a table VIEW. Which, is NOT able to update!!
Any suggestion how can i do it? I am afriad <joined-subclass> cannot help ...

I totally understood that this is NOT a common situation, but this design will save many development days...

Why don't you add a column called product_desc_id and, to protect your data from hard inserts and updates, create an index based on those two columns (product_id, lang_id) and make this index unique?

This give you the same idea from having composite-id. But gives you more: the simplicity of a simple, incremental, primary and beautiful key.

Thx for you suggestion.

Do you mean making the product_descr like this?

table product_description
(
product_desc_id int, --PK
product_id int, -- IX
lang_id smallint, -- IX
description varchar(),
)

But how can this solve my problem?

A FullProduct means a product with full detail in the specific language version....

i.e. in my old system, the code work like:

FullProduct p = ProductDAO.find(productID, langID);
System.out.println("ProductID: " + p.getProductID());
System.out.println("Description: " + p.getDescription());