Hibernate多对多映射持久性异常

Question

@Entity
@Table(name = "GOAL")
@NamedQuery(name = "get_goal", 
  query = "SELECT goal FROM Goal goal ")
public class Goal {

/** The strategic_ goal_ key. */
@Column(name = "GOAL_KEY")
private String Goal_Key;

/** The strategic_ goal_ name. */
@Column(name = "GOAL_NM")
private String strategic_Goal_Name;

/** The client initiatives. */
@ManyToMany
@JoinTable(name = "goal_initiative", joinColumns = { @JoinColumn(name = "Goal_Key") }, inverseJoinColumns = { @JoinColumn(name = "initiative_Key") })
List<ClientInitiative> initiative = new ArrayList<ClientInitiative>();  

 /**
 * The Class ClientInitiative.
 */
 @Entity
 @Table(name = "INIITATIVE")
 public class ClientInitiative {

/** The initiative_ key. */
@Column(name = "INITIATIVE_KEY")
private String initiative_Key;

/** The initiative_Key_Name. */
@Column(name = "INITIATIVE_KEY_NM")
private String initiative_Key_Name;

@ManyToMany(mappedBy="clientInitiative")
List<StrategicGoal> strategicGoals = new ArrayList<StrategicGoal>();

   @Repository
   public class GoalDAOImpl extends BaseDaoImpl{

@Override
@NamedQueryTarget("get_goal")
public List<Goal> getGoals(String planUnitKey) {

    List<Goal> goals = null;
    try {
        goals = (List<Goal>) getEntityManager()
                .createNamedQuery("get_goal").getResultList();
        return strategicGoals;
    } catch (NoResultException noResult) {
        return null;
    }
}

" Persistence.PersistenceException"   

persistenceException：DB2 SQL错误：sqlcode=-206,sqlstate=42703,sqlerrmc=t0.id,driver=3.52.95{prepstmnt 1029586270

    SELECT t0.id, t0.GOAL_KEY, t0.GOAL_NM 
    FROM CGSP.GOAL t0 

Answer 1

如果您查找错误代码，您将发现以下内容

1. 指定的列不是语句的任何源或目标表或视图的列。
2. 在SELECT或DELETE语句中，指定的列不是语句中FROM子句中标识的任何表或视图的列。
3. SQL数据更改语句的列列表指定了该语句的目标表或视图的列的名称。
4. 指定了限定列名，但在此上下文中未定义指定为限定符的表指示符。
5. 在OLAP规范中指定了对列的相关引用。OLAP规范中引用的每个列名必须明确引用包含OLAP规范的子SELECT的结果表中的一列。

在你的情况下，这是第一点。列id不是目标表的列。这就是问题所在。