from SuperClass c where instanceOf(c)=instance

from Transaction t where instanceOf(t) != ScheduledThirdTransaction

from Transaction t where t.class <> ScheduledThirdTransaction

<hibernate-mapping>

    <class name="net.persofin.transactions.Transaction" lazy="false" table="TRANS">
        <id name="id" column="TRS_ID">
            <generator class="increment"/>
        </id>       
       
        <property name="memo" column="MEMO"/>
        <property name="executionDate" column="EXEDATE" />
        <property name="amount" column="AMOUNT" />
        <property name="type" column="TYPE" />
        <property name="assetFactor" column="ASSET_FACTOR" />       
        <many-to-one name="account" class="net.persofin.accounts.Account" column="ACC_ID"/>       
        <joined-subclass name="net.persofin.transactions.TransferTransaction" lazy="false"   table="TRANSFER">
               <key column="TRANS_ID"/>
                <many-to-one name="linkedTrans"   column="TRANS_TRANS_ID"/>
               <many-to-one name="accountFrom"   column="TRANS_ACC_ID"/>                  
        </joined-subclass>
        <joined-subclass name="net.persofin.transactions.ThirdTransaction" lazy="false"   table="THIRDTRANS">
               <key column="THIRDTR_ID"/>
                <many-to-one name="third"  column="TIR_ID"/> 
                <many-to-one name="cat"  column="CAT_ID"/>                         
        </joined-subclass>
        <joined-subclass name="net.persofin.transactions.StockTransaction" lazy="false"   table="STOCKTRANS">
           <key column="STOCKTR_ID"/>
                <many-to-one name="stock"  column="STK_ID"/> 
                <property name="commissions"  column="COMMISSIONS"/>
                <property name="unitPrice"  column="UNIT_PRICE"/>
                <property name="qty"  column="QTY"/>                         
        </joined-subclass>
       
    </class>
   <class name="net.persofin.transactions.ScheduledThirdTransaction" lazy="false" table="SCHD_THIRDTRANS">
      <id name="id" column="SCHDTR_ID">
            <generator class="increment"/>
        </id>
                  <property name="memo" column="MEMO"/>
                   <many-to-one name="account" class="net.persofin.accounts.Account" column="ACC_ID"/>
                  <property name="executionDate" column="EXEDATE" />
                   <property name="amount" column="AMOUNT" />
                   <property name="type" column="TYPE" />
                 <property name="assetFactor" column="ASSET_FACTOR" />   
                 <many-to-one name="third"  column="TIR_ID"/> 
                    <many-to-one name="cat"  column="CAT_ID"/> 
                   <property name="nextExecutionDate" column="NEXT_EXE_DATE"/>
                   <property name="frequency" column="FREQUENCY"/>
                   <property name="scale" column="SCALE"/>
                   <property name="active" column="ACTIVE"/>
   </class>
</hibernate-mapping>

could not resolve property: class of: net.persofin.transactions.ScheduledThirdTransaction

<hibernate-mapping>

    <class name="net.persofin.transactions.Transaction" lazy="false" table="TRANS">
   
        <id name="id" column="TRS_ID">
            <generator class="increment"/>
        </id>       
        <discriminator column="KIND" type="string"/>   
        <property name="memo" column="MEMO"/>
        <property name="executionDate" column="EXEDATE" />
        <property name="amount" column="AMOUNT" />
        <property name="type" column="TYPE" />
        <property name="assetFactor" column="ASSET_FACTOR" />       
        <many-to-one name="account" class="net.persofin.accounts.Account" column="ACC_ID"/> 
        <subclass name="net.persofin.transactions.TransferTransaction" lazy="false"   discriminator-value="TRANSFER" >
                   <join table="TRANSFER">
                     <key column="TRANS_ID"/>
                      <many-to-one name="linkedTrans"   column="TRANS_TRANS_ID"/>
                     <many-to-one name="accountFrom"   column="TRANS_ACC_ID"/>
                  </join>       
        </subclass>
        <subclass name="net.persofin.transactions.ThirdTransaction" lazy="false"  discriminator-value="THIRD">
                <join table="THIRDTRANS">
                 <key column="THIRDTR_ID"/>
                      <many-to-one name="third"  column="TIR_ID"/> 
                      <many-to-one name="cat"  column="CAT_ID"/>                   
                </join>   
                [b]<subclass name="net.persofin.transactions.ScheduledThirdTransaction" lazy="false" discriminator-value="SCHD_THIRD">
                          <join table="SCHD_THIRDTRANS">
                               <key column="SCHDTR_ID"/>
                               <property name="NEXT_EXE_DATE"/>
                               <property name="FREQUENCY"/>
                               <property name="SCALE"/>
                               <property name="ACTIVE"/>
                         </join>               
                </subclass>    [/b]
        </subclass>
        <subclass name="net.persofin.transactions.StockTransaction" lazy="false" discriminator-value="STOCK">
           <join table="STOCKTRANS">
               <key column="STOCKTR_ID"/>
                <many-to-one name="stock"  column="STK_ID"/> 
                <property name="commissions"  column="COMMISSIONS"/>
                <property name="unitPrice"  column="UNIT_PRICE"/>
                <property name="qty"  column="QTY"/>   
            </join>                       
        </subclass>       
    </class>

</hibernate-mapping>