I have a hierachy of classes that goes like this: user->person->student
the user has a property called userStatus, which is a reference to another table. What I'm trying to do is get a list of students with a particular userStatus When I do the query for users like this: select ojbs from com.mp.hato.OJBUser where userStatus=1 It works fine. However, when I try select ojbs from com.mp.hato.OJBStudent where userStatus=1 I get a message java.sql.SQLException: Column not found, message from server: "Unknown column 'userStatus' in 'where clause'" Why is this happening when I use the student class, but not the user class? As far as I can tell, apart from this the inheritance has worked fine - if I retreived a student object I can access all the inherited fields, including the userStatus. So, I think its a problem with the query rather than the inheritance setup. Does anyone have any ideas? The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information. If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited. As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it. In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any). Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded. Mouchel Parkman UK Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
