Hi!
I have to table:
terms:
CREATE TABLE TERMS(
TERM_ID CHAR(13) NOT NULL,
LANG CHAR(2) NOT NULL,
DESCR VARCHAR NOT NULL,
PRIMARY KEY(TERM_ID,LANG)
)
codetable:
CREATE TABLE CODETABLE(
CODE CHAR(15) NOT NULL,
TABLE CHAR(8) NOT NULL,
TERM_ID CHAR(13) NOT NULL,
PRIMARY KEY(CODE,TABLE)
)

for relation for the two table i'd like use the field TERM_ID what is not primary in TERMS and not in TERMS.

I think for this relation is a one-to-many relation:
class codetable:

import java.util.Iterator;
import java.util.Set;

public class CodeTable {
private CodeTableId id;
private String term_id;
private Set terms;

public CodeTable() {
}
public Set getTerms() {
return terms;
}
public void setTerms(Set newTerms) {
terms = newTerms;
}
public CodeTableId getId() {
return id;
}
public void setId(CodeTableId id) {
this.id = id;
}
static public CodeTableId createId(String code, String table) {
return new CodeTableId(code, table);
}
public String getTerm_id() {
return term_id;
}
public void setTerm_id(String term_id) {
this.term_id = term_id;
}
}

CodeTableId:
import java.io.IOException;
import java.io.Serializable;

public class CodeTableId implements Serializable{
private String code;
private String table;

public CodeTableId(){
}
public CodeTableId(String code, String table) {
setCode(code);
setTable(table);
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getTable() {
return table;
}
public void setTable(String table) {
this.table = table;
}
private void writeObject(java.io.ObjectOutputStream s)throws IOException{
s.writeObject(code);
s.writeObject(table);
}
private void readObject(java.io.ObjectInputStream s) throws IOException, ClassNotFoundException{
code = (String)s.readObject();
table = (String)s.readObject();
}
}

mapping:
<?xml version="1.0" encoding="ISO-8859-2"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.ignis.db.lang">
<class name="CodeTable" table="codetable">
<composite-id name="id" class="CodeTableId" mapped="false" access="property">
<key-property name="Code" type="java.lang.String" column="code"/>
<key-property name="Table" type="java.lang.String" column="table"/>
</composite-id>
<property name="Term_id" not-null="false"/>
<set name="Terms" cascade="all">
<key column="term_id" unique="false" not-null="true" property-ref="Term_id"/>
<one-to-many class="Terms" not-found="ignore" />
</set>
</class>
</hibernate-mapping>

terms:
public class Terms {
private TermsId terms;
private String lang;
private String term_id;

private String descr;

public Terms(){

}
public String getDescr() {
return descr;
}
public void setDescr(String descr) {
this.descr = descr;
}
public TermsId getTerms() {
return terms;
}
public void setTerms(TermsId terms) {
this.terms = terms;
}
public String getLang() {
return lang;
}
public void setLang(String lang) {
this.lang = lang;
}
static public TermsId createId(String terms_id,String lang){
return new TermsId(terms_id,lang);
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
}

TermId:
public class TermsId {
private String lang;
private String term_id;
public TermsId(String term_id,String lang){
setTerm_id(term_id);
setLang(lang);
}
public TermsId(){
}
public String getLang() {
return lang;
}
public void setLang(String lang) {
this.lang = lang;
}
public String getTerm_id() {
return term_id;
}
public void setTerm_id(String term_id) {
this.term_id = term_id;
}
}

Mapping:
<?xml version="1.0" encoding="ISO-8859-2"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.ignis.db.lang">
<class name="Terms" table="Terms">
<composite-id name="id" class="TermsId" mapped="false" access="property">
<key-property name="Term_id" type="java.lang.String" column="term_id"/>
<key-property name="Lang" type="java.lang.String" column="lang"/>
</composite-id>

<property name="Descr" not-null="false" type="java.lang.String"/>
<property name="Lang" not-null="false" type="java.lang.String"/>
</class>
</hibernate-mapping>

If i run the session.get(CodeTable.class,new CodeTableId(..,..));
i became a error: duplicated map for terms_id in TERMS and i must uset it with update="false" and insert="false".
where must i use it? i try it codetable mapping in <set>,<key>,<one-to-many> but not worked.

it isn't a parent/child relation, because i'd like use one term for many codetable. the TERMS_ID is not unique in TERMS and not in CODETABLE.

what do i wrong?
thanx:
ignis

So. First i draw the database:


because the first try not worked, and nobody can help, i try to add a Id column (as integer) to terms, and modify the mapping and class:

Mapping:

(the codetable still the same)
i run the test program and i became a error:

what's wrong?

thanx:
Ignis