Problema de mapeamento - Hibernate - sql-query

Galera qual seria o problema desse mapeamento.
Isso começou quando eu coloquei o sql-query e o mas interessante que eu segui o livro do Hibernate.

O erro é este.

The content of element type "joined-subclass" must match 
 "(meta*,subselect?,synchronize*,comment?,tuplizer*,key,(property|many-to-one|one-to-one|
 component|dynamic-component|properties|any|map|set|list|bag|idbag|array|primitive-array)*,joined-
 subclass*,loader?,sql-insert?,sql-update?,sql-delete?,resultset*,(query|sql-query)*)".

A linha onde o mesmo esta ocorrendo é neste agora porque isso acontece.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping
	package="br.com.redeamazonica.corp.mediasuite.model.programa">
	<class name="Programa" table="PROGRAMA" catalog="SISOPEC">
		<id name="codPrograma" type="string">
			<column name="Cod_Programa" length="4" />
			<generator class="assigned" />
		</id>
		<property name="codProgramaSiscom" type="string">
			<column name="Cod_ProgramaSiscom" length="4" />
		</property>		
		..................
                ..................
		<joined-subclass name="ProgramaComum" table="PROGRAMA_COMUM" extends="br.com.redeamazonica.corp.mediasuite.model.programa.Programa">
			
			<key column="Cod_Programa"/>
			
			<set name="exibicoes" inverse="true" cascade="all, delete-orphan">
				<key>
					<column name="Cod_Programa" length="4" not-null="true" />
				</key>
				<one-to-many class="ProgramaExibicao"/>
			</set>
			
			<set name="programasAlternativos" inverse="true">
				<key/>
				<one-to-many class="ProgramaComum"/>
				<loader query-ref="progAlt"/>
			</set>
			
			<sql-query name="progAlt">
				<load-collection alias="progc" role="ProgramaComum.programasAlternativos"/>
    			<![CDATA[SELECT {progc.*} 
    			FROM SISOPEC.PROGRAMA_COMUM pc
				WHERE pc.Cod_Programa_Inedito = :codPrograma AND pc.Inedito_Alternativo = 'A']]>
			</sql-query>
			
			<property name="nivelPrograma" type="string">
				<column name="Nivel_Programa" length="3"
					not-null="true" />
			</property>
			..................................
                        .................................
			
		</joined-subclass>
		
	</class>
</hibernate-mapping>

Topicos relacionados