Where clause causes query to select from sub-class table -------------------------------------------------------- Key: HHH-3304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3304 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: Informix IDS 9 Reporter: Thom Hehl If I have two classes: public class ExcuseCode extends Code{ /** * flag for no */ public static final String FLAG_NO = "N"; /** * flag for yes */ public static final String FLAG_YES = "Y"; /** * Participant must be within a certain number of miles */ public static final String TRIGGER_MILEAGE = "MILEAGE"; /** * Participant must be too old */ public static final String TRIGGER_OVERAGE = "OVERAGE"; private static final long serialVersionUID = 1L; @SuppressWarnings("all") private static Log _log = LogFactory.getLog(ExcuseCode.class.getName()); private String additionalMessage; private String autoFlag; private String ejVisible; private boolean remarksRequired; private String trigger; /** * no-arg constructor */ public ExcuseCode(){ } /** * constructor with only the code character */ public ExcuseCode(char code){ setCodeChar(code); setAdditionalMessage("default postponement"); setAutomatic(false); setDescription("default postponement"); setShortText("default postponement"); } /** * copy constructor */ public ExcuseCode(ExcuseCode excuseCode){ setCodeChar(excuseCode.getCodeChar()); setAdditionalMessage(excuseCode.getAdditionalMessage()); setAutomatic(false); setDescription(excuseCode.getDescription()); setShortText(excuseCode.getShortText()); } /** * @return the automatic */ public boolean isAutomatic() { return getAutoFlag().equals(FLAG_YES); } /** * @param automatic the automatic to set */ public void setAutomatic(boolean automatic) { if(automatic){ setAutoFlag(FLAG_YES); } else{ setAutoFlag(FLAG_NO); } } /** * @return the visible */ public boolean isVisible() { return getEjVisible().equals(FLAG_YES); } /** * @param visible the visible to set */ public void setVisible(boolean visible) { if(visible){ setEjVisible(FLAG_YES); } else{ setEjVisible(FLAG_NO); } } /** * A special code to indicate additional processing. Use this instead of * code to key custom processing. * @return the trigger */ public String getTrigger() { return trigger; } /** * A special code to indicate additional processing. Use this instead of * code to key custom processing. * @param trigger the trigger to set */ public void setTrigger(String trigger) { this.trigger = trigger; } /** * Upon selection, display this additional message * @return the additionalMessage */ public String getAdditionalMessage() { return additionalMessage; } /** * Upon selection, display this additional message * @param additionalMessage the additionalMessage to set */ public void setAdditionalMessage(String additionalMessage) { this.additionalMessage = additionalMessage; } /** * @return the remarksRequired */ public boolean isRemarksRequired() { return remarksRequired; } /** * @param remarksRequired the remarksRequired to set */ public void setRemarksRequired(boolean remarksRequired) { this.remarksRequired = remarksRequired; } /** * @return the ejVisible */ public String getEjVisible() { return ejVisible; } /** * @param ejVisible the ejVisible to set */ public void setEjVisible(String ejVisible) { this.ejVisible = ejVisible; } /** * @return the autoFlag */ public String getAutoFlag() { return autoFlag; } /** * @param autoFlag the autoFlag to set */ public void setAutoFlag(String autoFlag) { this.autoFlag = autoFlag; } and public class DisqualificationCode extends ExcuseCode { private static final long serialVersionUID = 1L; /** * Participant must be too old */ public static final String TRIGGER_OVERAGE = "OVERAGE"; /** * Participant must be too young */ public static final String TRIGGER_UNDERAGE = "UNDERAGE"; /** * Participant must be unemployed */ public static final String TRIGGER_UNEMPLOYED = "UNEMPLOYED"; /** * no-arg constructor */ public DisqualificationCode(){ super(); } /** * create from a code * @param code the code for this disqualification code */ public DisqualificationCode(char code){ super(code); } /** * copy constructor * @param disqCode the disqualification code being copied */ public DisqualificationCode(DisqualificationCode disqCode){ super(disqCode); } /** * constructor from super classs * @param exCode the excuse code being copied */ public DisqualificationCode(ExcuseCode exCode){ super(exCode); } and mapping files to match: <hibernate-mapping> <class name="xxx.bo.ExcuseCode" table="EXC_CODE"> <id name="codeChar" column="EXC_CODE"> <generator class="assigned"/> </id> <property name="description"/> <property name="ejVisible" column="EJ_VISIBLE"/> <property name="autoFlag" column="AUTO"/> </class> </hibernate-mapping> <hibernate-mapping> <class name="com.acs.gs.juror.bo.DisqualificationCode" table="DIS_CODE"> <id name="code" column="DISQ_CODE" type="string"> <generator class="assigned"/> </id> <property name="description" type="string"/> </class> </hibernate-mapping> and then run a query (using Spring): HibernateTemplate ht = getHibernateTemplate(); if(ht==null){ String msg="HibernateTemplate is null."; _log.error(msg); throw new IllegalStateException(msg); } @SuppressWarnings("unchecked") List<ExcuseCode> excuseCodes = ht.find( "from ExcuseCode excusecode where ejVisible='Y' order by excusecode.description asc"); _log.debug("ExcuseCodes:" + excuseCodes); return excuseCodes; I get this error: SEVERE: Column not found: EJVISIBLE in statement [select disqualifi0_.DISQ_CODE as DISQ1_5_, disqualifi0_.description as descript2_5_ from DIS_CODE disqualifi0_ where ejVisible='Y' order by disqualifi0_.description asc] Note that I'm running select ExcuseCode, but hibernate is building a query for the DIS_CODE table which is the subclass of ExcuseCode. Thanks. and -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira