Strange error after em.persist

[max afinogenov]

Hi everyone.
I have an entity "message" with fields emp_id, local_user_id, message_date, message_header, message_id.
I want to save it to a table "message" with corresponding columns.
But after em.persist(message) I got this exception:

org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00904: "LOCAL_USER_LOCAL_USER_ID": недопустимый идентификатор
{prepstmnt 42 INSERT INTO Message (emp_id, local_user_id, message_date, message_header, emp_emp_id, local_user_local_user_id) VALUES (?, ?, ?, ?, ?, ?) [params=(int) 8, (int) 0, (null) null, (String) , , 7, 9, 6., (null) null, (null) null]} [code=904, state=42000]

Entity "message" has 2 many-to-one relations - local_user and emp. Why JPA tries to insert something to non-existing columns (emp_emp_id, local_user_local_user_id)?

[Jaikiran Pai]

Please post your entities which has the annotations.

[max afinogenov]

 
package entity_pack;
 
import javax.persistence.*;
import java.util.*;
import java.io.Serializable;
 
@Entity
public class Message implements Serializable {
    private int message_id;
    private String message_header;
    private int emp_id;
    private Date message_date;
    private int local_user_id;
 
    private List<Happened_event_list> happened_event_lists;
    private List<Message_inclusion_list> message_inclusion_lists;
    private Emp emp;
    private Local_user local_user;
 
    @ManyToOne
    public Local_user getLocal_user() {
        return local_user;
    }
 
    public void setLocal_user(Local_user local_user) {
        this.local_user = local_user;
    }
 
    @OneToMany(mappedBy="message")
    public List<Message_inclusion_list> getMessage_inclusion_lists() {
        return message_inclusion_lists;
    }
 
    public void setMessage_inclusion_lists(List<Message_inclusion_list> message_inclusion_lists) {
        this.message_inclusion_lists = message_inclusion_lists;
    }
 

 
    @ManyToOne
    public Emp getEmp() {
        return emp;
    }
 
    public void setEmp(Emp emp) {
        this.emp = emp;
    }
 

    @OneToMany(mappedBy = "message")
    public List<Happened_event_list> getHappened_event_lists() {
        return happened_event_lists;
    }
 
    public void setHappened_event_lists(List<Happened_event_list> happened_event_lists) {
        this.happened_event_lists = happened_event_lists;
    }
 
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    public int getMessage_id() {
        return message_id;
    }
 
    public void setMessage_id(int message_id) {
        this.message_id = message_id;
    }
 
    public String getMessage_header() {
        return message_header;
    }
 
    public void setMessage_header(String message_header) {
        this.message_header = message_header;
    }
 

 
    public int getEmp_id() {
        return emp_id;
    }
 
    public void setEmp_id(int emp_id) {
        this.emp_id = emp_id;
    }                      
 
    public Date getMessage_date() {
        return message_date;
    }
 
    public void setMessage_date(Date message_date) {
        this.message_date = message_date;
    }
 
   public int getLocal_user_id() {
        return local_user_id;
    }
 
    public void setLocal_user_id(int local_user_id) {
        this.local_user_id = local_user_id;
    }      
}
 
   

I am trying ta save this entity only.

[Jaikiran Pai]

Entity "message" has 2 many-to-one relations - local_user and emp.

Assuming that your Message entity has foreign key "emp_id" for Emp and "local_user_id" for Local_user, your annotations should look like:

@ManyToOne
[B]@JoinColumn(name="local_user_id")[/B]
    public Local_user getLocal_user() {
        return local_user;
    }
 
@ManyToOne
[B]@JoinColumn(name="emp_id")[/B]
    public Emp getEmp() {
        return emp;
    }

If you omit the JoinColumn annotation, the EJB 3.0 server would choose a default column name for you, which in this case i guess is turning out to be emp_emp_id and local_user_local_user_id

[max afinogenov]

  
@ManyToOne
    @JoinColumn (name = "local_user_id")
    public Local_user getLocal_user() {
        return local_user;
    }
  

@ManyToOne
    @JoinColumn(name="emp_id")
    public Emp getEmp() {
        return emp;
    }
   

After this I get compilation error - cannot resolve symbol
What else can I try?

[Jaikiran Pai]

Have you added the following import statement

import javax.persistence.JoinColumn;

[max afinogenov]

Yes, of course. Error is in name="emp_id" and name="local_user_id"

[Jaikiran Pai]

And if that doesnt work, can you post the compilation error that you are seeing?

[max afinogenov]

I develop using IDEA, so

    
Information:Compilation completed with 2 errors and 0 warnings
Information:2 errors
Information:0 warnings
F:\...\entity_pack\Message.java
    Error:Error:line (49)Cannot resolve symbol
    Error:Error:line (28)Cannot resolve symbol

These 2 symbols are "emp_id" and "local_user_id"
Mb there is another way??

[Jaikiran Pai]

Not sure what the cause of this compilation errors is, but i do see that you have 2 private member variables:

private int emp_id;
private int local_user_id;

Can you remove these and the corresponding getter/setter and see if it works. Let us know, if it doesn't.