ID_NAME in two tables

[nimo frey]

I have that two Tables with Table1 containing ID_NAME as a primary key
and Table2 containing ID_NAME as a normal row
(that means, it s not a primary-key or a foreign-key). I mapped that in common way.

But when I want to get the ID_NAME from Table2, then this failure occurs:

Caused by: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=TABLE2_.IDNAME, DRIVER=3.50.152

42703: An undefined column, attribute, or parameter name was detected.

But the column ID_NAME is definitly in my database both in Table1 and Table2.

What does this sql-error mean:

IDNAME is not valid in the context where it is used. sqlcode : -206 sqlstate : 42703

The strange thing is, that the database-column is definitly called ID_NAME and not IDNAME (as produced in the failure-message), another point is, that idName is my property in Table2 and not a correlated column to any other tables. However, I have idName in another Table called Table1 in which this property is a common primary key. But I have not association between Table1 and Table2.

    private String idName;
    @Basic
    @Column(name = "ID_NAME", nullable = false, insertable = true, updatable = true, columnDefinition = "char(40)")
    public Short getIdName() { return idName; }
    public void setIdName(Short idName) { this.idName = idName;}

What is wrong?



Does anyone know a solution?

[nimo frey]

solved. I have redefine getter/setters.

Now it works.

[nimo frey]

solved