2 thoughts on “ERROR: column notation .id applied to type name, which is not a composite type”

1. Very useful. Let me share an workaround if you still want your entity/table to be named User.
   Background: Hibernate creates a query like this:
   select
   user0_.id as id0_,
   user0_.first_name as first2_0_,
   user0_.last_name as last3_0_,
   from
   user user0_
   This user in the from clause messes the things.
   The work around is to specify your schema. Can be done in two ways

   1. By specifying the schema in the table in the @Table annotation. In case of schema public, will look like this.

   @Entity
   @Table(schema=”public”, name = “user”)

   2. By specifying the schema in the schema in the persistence.xml

   This will crate a query that works:
   select
   user0_.id as id0_,
   user0_.first_name as first2_0_,
   user0_.last_name as last3_0_,
   from
   public.user user0_

   Note that public.user

   Reply

2. Thanks,
   Not just a note to yourself, also to me.

   Reply