SQL Error: 1054, SQLState: 42S22 Unknown column in 'field list' error Java Spring Boot Mysql error -

basically trying make simple promotion page, error getting sql error: 1054, sqlstate: 42s22 error unknown column 'promotion0_.promo_type_id' in 'field list'

here model classes

package promotions.model;   import java.io.serializable;  import javax.persistence.cascadetype; import javax.persistence.column; import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.id; import javax.persistence.joincolumn; import javax.persistence.manytoone; import javax.persistence.onetomany; import javax.persistence.onetoone; import javax.persistence.table;  @entity @table(name="promotion") public class promotion implements serializable{  @id @generatedvalue(strategy=generationtype.auto) @column(name="id") private int id; private string name; private boolean active; private boolean status; @manytoone @joincolumn(name="promotype_id") private promo_type promo_type; @manytoone @joincolumn(name="roomtype_id") private roomtype room_types;    public promotion() {  } public promotion(string name, boolean active, boolean status, promo_type promo_type, roomtype room_types) {     super();     this.name = name;     this.active = active;     this.status = status;     this.promo_type = promo_type;     this.room_types = room_types; } public int getid() {     return id; } public void setid(int id) {     this.id = id; } public string getname() {     return name; } public void setname(string name) {     this.name = name; } public boolean isactive() {     return active; } public void setactive(boolean active) {     this.active = active; } public boolean isstatus() {     return status; } public void setstatus(boolean status) {     this.status = status; } @onetoone(cascade = cascadetype.all) @joincolumn(name = "promotype_id") public promo_type getpromo_type() {     return promo_type; }  public void setpromo_type(promo_type promo_type) {     this.promo_type = promo_type; }  @onetoone(cascade = cascadetype.all) @joincolumn(name = "roomtype_id") public roomtype getroom_types() {     return room_types; } public void setroom_types(roomtype room_types) {     this.room_types = room_types; } @override public string tostring() {     return "promotions [id=" + id + ", name=" + name + ", active=" + active + ", status=" + status + ", promo_type="             + promo_type + ", room_types=" + room_types + "]"; } 

}

package promotions.model;  import java.io.serializable; import java.util.collection; import java.util.hashset; import java.util.set;  import javax.persistence.cascadetype; import javax.persistence.column; import javax.persistence.entity; import javax.persistence.fetchtype; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.id; import javax.persistence.onetomany; import javax.persistence.table;  @entity @table(name="roomtype") public class roomtype implements serializable{  @id @generatedvalue(strategy=generationtype.auto) @column(name="roomtype_id") private int id; private string name;  @onetomany(mappedby="room_types", cascade= cascadetype.all,fetch= fetchtype.lazy) private collection<promotion>promotions;     public roomtype() {  }  public roomtype(string name, collection<promotion> promotions) {     super();     this.name = name;     this.promotions = promotions; }  public int getid() {     return id; }  public void setid(int id) {     this.id = id; }  public string getname() {     return name; }  public void setname(string name) {     this.name = name; }  public collection<promotion> getpromotions() {     return promotions; }  public void setpromotions(collection<promotion> promotions) {     this.promotions = promotions; }       } 

here model class

package promotions.model;  import java.io.serializable; import java.util.collection; import java.util.hashset; import java.util.set;  import javax.persistence.cascadetype; import javax.persistence.column; import javax.persistence.entity; import javax.persistence.fetchtype; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.id; import javax.persistence.onetomany; import javax.persistence.onetoone; import javax.persistence.table;   @entity @table(name="promotype") public class promo_type implements serializable{ @id @generatedvalue(strategy=generationtype.auto) @column(name="promotype_id") private int id; private string name; private double discount; @onetomany(mappedby="promo_type", cascade= cascadetype.all,fetch= fetchtype.lazy) private collection<promotion>promotions;    public promo_type() {  } public promo_type(string name, double discount, collection<promotion>      promotions) {     super();     this.name = name;     this.discount = discount;     this.promotions = promotions; } public int getid() {     return id; } public void setid(int id) {     this.id = id; } public string getname() {     return name; } public void setname(string name) {     this.name = name; } public double getdiscount() {     return discount; } public void setdiscount(double discount) {     this.discount = discount; } public collection<promotion> getpromotions() {     return promotions; } public void setpromotions(collection<promotion> promotions) {     this.promotions = promotions; } 

}

and here mysql query

 create database `promotiondb`;  use promotiondb;  create table `promotype` (   `promotype_id` int(11) not null auto_increment,   `name` varchar(45) not null,   `discount` double not null,   primary key (`promotype_id`) );   create table `roomtype` (   `roomtype_id` int(11) not null auto_increment,   `name` varchar(70) not null,    primary key (`roomtype_id`) );  create table `promotion` (   `id` int not null auto_increment,   `name` varchar(45) null,   `status` tinyint(1) null,   `active` tinyint(1) null,   `promotype_id` int(11) not null,   `roomtype_id` int(11) not null,   primary key (`id`),   key `fk_promotype` (`promotype_id`),   key `fk_roomtype` (`roomtype_id`),   constraint `fk_roomtype` foreign key (`roomtype_id`) references `roomtype` (`roomtype_id`),   constraint `fk_promotype` foreign key (`promotype_id`) references `promotype` (`promotype_id`) ); 

here error, sql error: 1054, sqlstate: 42s22, unknown column 'promotion0_.promo_type_id' in 'field list'error 34768 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.sqlexceptionhelper : unknown column 'promotion0_.promo_type_id' in 'field list'

    com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown column 'promotion0_.promo_type_id' in 'field list' @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) ~[na:1.8.0_121] @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source) ~[na:1.8.0_121] @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source) ~[na:1.8.0_121] @ java.lang.reflect.constructor.newinstance(unknown source) ~[na:1.8.0_121] @ com.mysql.jdbc.util.handlenewinstance(util.java:425) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.util.getinstance(util.java:408) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:943) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3973) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3909) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2527) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2680) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2501) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:1858) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ com.mysql.jdbc.preparedstatement.executequery(preparedstatement.java:1966) ~[mysql-connector-java-5.1.41-bin.jar:5.1.41] @ org.hibernate.engine.jdbc.internal.resultsetreturnimpl.extract(resultsetreturnimpl.java:70) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.getresultset(loader.java:2117) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.executequerystatement(loader.java:1900) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.executequerystatement(loader.java:1876) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.doquery(loader.java:919) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:336) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.dolist(loader.java:2617) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.dolist(loader.java:2600) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.listignorequerycache(loader.java:2429) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.loader.list(loader.java:2424) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.loader.hql.queryloader.list(queryloader.java:501) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.hql.internal.ast.querytranslatorimpl.list(querytranslatorimpl.java:371) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:216) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1326) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.internal.queryimpl.list(queryimpl.java:87) ~[hibernate-core-5.0.11.final.jar:5.0.11.final] @ org.hibernate.jpa.internal.queryimpl.list(queryimpl.java:606) ~[hibernate-entitymanager-5.0.11.final.jar:5.0.11.final] @ org.hibernate.jpa.internal.queryimpl.getresultlist(queryimpl.java:483) ~[hibernate-entitymanager-5.0.11.final.jar:5.0.11.final] @ org.hibernate.jpa.criteria.compile.criteriaquerytypequeryadapter.getresultlist(criteriaquerytypequeryadapter.java:50) ~[hibernate-entitymanager-5.0.11.final.jar:5.0.11.final] @ org.springframework.data.jpa.repository.support.simplejparepository.findall(simplejparepository.java:329) ~[spring-data-jpa-1.11.0.release.jar:na] @ org.springframework.data.jpa.repository.support.simplejparepository.findall(simplejparepository.java:74) ~[spring-data-jpa-1.11.0.release.jar:na] @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_121] @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) ~[na:1.8.0_121] @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) ~[na:1.8.0_121] @ java.lang.reflect.method.invoke(unknown source) ~[na:1.8.0_121] @ org.springframework.data.repository.core.support.repositoryfactorysupport$queryexecutormethodinterceptor.executemethodon(repositoryfactorysupport.java:504) ~[spring-data-commons-1.13.0.release.jar:na] @ org.springframework.data.repository.core.support.repositoryfactorysupport$queryexecutormethodinterceptor.doinvoke(repositoryfactorysupport.java:489) ~[spring-data-commons-1.13.0.release.jar:na] @ org.springframework.data.repository.core.support.repositoryfactorysupport$queryexecutormethodinterceptor.invoke(repositoryfactorysupport.java:461) ~[spring-data-commons-1.13.0.release.jar:na] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.data.projection.defaultmethodinvokingmethodinterceptor.invoke(defaultmethodinvokingmethodinterceptor.java:61) ~[spring-data-commons-1.13.0.release.jar:na] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation(transactioninterceptor.java:99) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactionaspectsupport.invokewithintransaction(transactionaspectsupport.java:282) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:96) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.dao.support.persistenceexceptiontranslationinterceptor.invoke(persistenceexceptiontranslationinterceptor.java:136) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.data.jpa.repository.support.crudmethodmetadatapostprocessor$crudmethodmetadatapopulatingmethodinterceptor.invoke(crudmethodmetadatapostprocessor.java:133) ~[spring-data-jpa-1.11.0.release.jar:na] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.interceptor.exposeinvocationinterceptor.invoke(exposeinvocationinterceptor.java:92) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.data.repository.core.support.surroundingtransactiondetectormethodinterceptor.invoke(surroundingtransactiondetectormethodinterceptor.java:57) ~[spring-data-commons-1.13.0.release.jar:na] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:213) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ com.sun.proxy.$proxy83.findall(unknown source) ~[na:na] @ promotions.service.promotionsservice.findall(promotionsservice.java:28) ~[classes/:na] @ promotions.service.promotionsservice$$fastclassbyspringcglib$$f95c210e.invoke(<generated>) ~[classes/:na] @ org.springframework.cglib.proxy.methodproxy.invoke(methodproxy.java:204) ~[spring-core-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.cglibaopproxy$cglibmethodinvocation.invokejoinpoint(cglibaopproxy.java:721) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:157) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation(transactioninterceptor.java:99) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactionaspectsupport.invokewithintransaction(transactionaspectsupport.java:282) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:96) ~[spring-tx-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:179) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept(cglibaopproxy.java:656) ~[spring-aop-4.3.6.release.jar:4.3.6.release] @ promotions.service.promotionsservice$$enhancerbyspringcglib$$30594b1.findall(<generated>) ~[classes/:na] @ promotions.controller.samplerestcontroller.allpromotions(samplerestcontroller.java:24) ~[classes/:na] @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_121] @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) ~[na:1.8.0_121] @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) ~[na:1.8.0_121] @ java.lang.reflect.method.invoke(unknown source) ~[na:1.8.0_121] @ org.springframework.web.method.support.invocablehandlermethod.doinvoke(invocablehandlermethod.java:205) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:133) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:116) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:827) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:738) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:85) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:963) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:897) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:970) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:861) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ javax.servlet.http.httpservlet.service(httpservlet.java:622) ~[servlet-api.jar:na] @ org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:846) ~[spring-webmvc-4.3.6.release.jar:4.3.6.release] @ javax.servlet.http.httpservlet.service(httpservlet.java:729) ~[servlet-api.jar:na] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:230) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) ~[tomcat-websocket.jar:8.5.6-dev] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:192) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.springframework.web.filter.requestcontextfilter.dofilterinternal(requestcontextfilter.java:99) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:192) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.springframework.web.filter.httpputformcontentfilter.dofilterinternal(httpputformcontentfilter.java:105) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:192) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:81) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:192) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:197) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) ~[spring-web-4.3.6.release.jar:4.3.6.release] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:192) ~[catalina.jar:na] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:165) ~[catalina.jar:na] @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:198) ~[catalina.jar:na] @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:108) [catalina.jar:na] @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) [catalina.jar:na] @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:140) [catalina.jar:na] @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:79) [catalina.jar:na] @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:87) [catalina.jar:na] @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:349) [catalina.jar:na] @ org.apache.coyote.http11.http11processor.service(http11processor.java:784) [tomcat-coyote.jar:8.5.6-dev] @ org.apache.coyote.abstractprocessorlight.process(abstractprocessorlight.java:66) [tomcat-coyote.jar:8.5.6-dev] @ org.apache.coyote.abstractprotocol$connectionhandler.process(abstractprotocol.java:802) [tomcat-coyote.jar:8.5.6-dev] @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.dorun(nioendpoint.java:1410) [tomcat-coyote.jar:8.5.6-dev] @ org.apache.tomcat.util.net.socketprocessorbase.run(socketprocessorbase.java:49) [tomcat-coyote.jar:8.5.6-dev] @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) [na:1.8.0_121] @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) [na:1.8.0_121] @ org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run(taskthread.java:61) [tomcat-util.jar:8.5.6-dev] @ java.lang.thread.run(unknown source) [na:1.8.0_121] 

your problem comes config(application.properties) used springboot in naming column in database. if want solve problem, have either avoid capital letters in column name or change naming strategy in application.properties , use this

spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.physicalnamingstrategystandardimpl