Ola pessoal!
eu tenho esse querry
@NamedQuery(name = "Instituicao.findByNome", query = "SELECT i FROM Instituicao i WHERE i.nome = :nome")
como eh q eu faço pra q o i.nome seja pesquisado com o like?
eu jah tentei assim
@NamedQuery(name = "Instituicao.findByNome", query = "SELECT i FROM Instituicao i WHERE i.nome LIKE %:nome%")
mas tah dando esse erro
Exception in thread "main" Local Exception Stack:
Exception [TOPLINK-8026] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: Syntax error parsing the query [Instituicao.findByNome: SELECT i FROM Instituicao i WHERE i.nome LIKE %:nome%], line 1, column 47: unexpected char [%].