Hi I'm using JBoss 4.0.3SP1 and I have an entity bean that stores its data in 2 tables that are joined by an id. My class looks like:
@Entity(access=AccessType.PROPERTY) @Table(name="users1") @SecondaryTable(name="users2", join={@JoinColumn(name="id", referencedColumnName="user_id")}) public class User implements Serializable { int id; String username = null; String firstName = null; @Id(generate=GeneratorType.AUTO) @Column(name="user_id") public int getId() { return id; } public void setId(int id) { this.id = id; } @Column(nullable=false,length=50) public String getUsername() { return super.getUsername(); } public void setUsername(String name) { this.username = name; } @Column(name="firstName", secondaryTable="users2") public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } }
java.sql.SQLException: Unknown column 'firstName' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2064)