JDBCSQL Exception : Column not found [@Column annotation is not working field in JPA]

Question

I am working with JPA application.The JPA annotations are applied on Getter methods and its working but when I am trying to apply the annotations on fields then compiler generate the error. I want to apply annotations on fields.

@Entity
@Table(name="TB_DEMO",query="select q from TB_DEMO q")
public class Demo extends DomainRoot{

    @Column(name="VAR_COUNT")
        private int varCount;

        public int getCount(){
        return this.varCount;
        }
        public void setCount(int count){
        this.varCount=count;
        }
}

Error: org.springframeowork.dao.InvalidDataResourceUsageException: Could not prepare statement

org.h2.jdbc.JdbcSQLException: Column "QSXXXXXXXX_.VARCOUNT" not found

JDBCSQLException is not a compilation error. Post rather the exception. — davidxxx
– davidxxx, Commented Dec 15, 2017 at 20:29
it is working with getter methods but not working with fields — NDesai
– NDesai, Commented Dec 15, 2017 at 20:45

Henrique Fernandes Cipriano · Accepted Answer · 2017-12-16 19:40:40Z

1

The persistence provider isn't consider your field attributes why DomainRoot or application default access using mapping by Property (Annotations on gets) and you trying to use mapping by Field(Annotations on Fields).

The specifications say that in this case (Inhritance), the comportament is unpredictable.

For your example, increase @Access(AccessType.FIELD) on class level or simply use the same access level on whole class hierarchy without declare @Access Annotations.

answered Dec 16, 2017 at 19:40

Henrique Fernandes Cipriano

5857 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JDBCSQL Exception : Column not found [@Column annotation is not working field in JPA]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related