Eu tenho a seguinte NativeQuery:
@NamedNativeQueries(value={
@NamedNativeQuery(name = "Programa.findByNome", query = "SELECT * FROM programa WHERE LOWER(nome) SIMILAR TO ?1", resultSetMapping = "consultaPrograma")
})
@SqlResultSetMapping(name = "consultaPrograma", entities = {
@EntityResult(entityClass = Programa.class, fields = {
@FieldResult(name="id", column="id"),
@FieldResult(name="dataInicio", column="datainicio"),
@FieldResult(name="dataFim", column="datafim"),
@FieldResult(name="nome", column="nome"),
@FieldResult(name="publicoAlvo", column="publicoalvo"),
@FieldResult(name="objetivo", column="objetivo"),
@FieldResult(name="contribuicaoSociedade", column="contribuicaosociedade"),
@FieldResult(name="categoria", column="categoria"),
@FieldResult(name="areaTematica", column="id_areatematica"),
@FieldResult(name="edital", column="edital")
})})
E tô recebendo o seguinte erro quando faço a consulta:
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-6130] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.QueryException
Exception Description: Custom SQL failed to provide descriminator column : , as defined in SQLResultSetMapping : consultaPrograma.
Query: ResultSetMappingQuery()
Programa é uma classe filha de Projeto.
Programa herda o id de Projeto.
Pq será esse erro?