A coder's blog.

Ideas, projects, problems and solutions - whatever is interesting.

Operator Does Not Exist: Character Varying = Bytea

Postgres error message in Cinnamon-CMS

Message: operator does not exist: character varying = bytea

similiar problem:

http://www.tmro.net/2008/07/postgresql-named-queries-headache/

Hibernate-Query:

1
2
3
4
5
6
7

            @NamedQuery(

                    name = "findLanguageByIsoCode",

                    query = "select l from Language l where iso_code=:isoCode"

            ),

Solution: change from column-based (“iso_code”) to field-name (l.isoCode)

1
2
3
4
5
6
7

            @NamedQuery(

                    name = "findLanguageByIsoCode",

                    query = "select l from Language l where l.isoCode=:isoCode"

            ),