Comments by Auto Samachar (Top 3 by date)

Auto Samachar 22-Sep-22 6:00am View

13:07:33.054 [http-nio-8001-exec-2] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 10 ms
13:08:28.032 [http-nio-8001-exec-1] INFO com.recruit.api.utils.Constants - /2022-09-22 13:08:28/Manager Details /create/{"vmsContactPhone":"123456","vmsPortal":"vms","vmsContactName":"dharma","vmsContactEmail":"ad@ad.com","state":"nc","managerId":"1234566666"}/100
13:08:29.217 [http-nio-8001-exec-1] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 1054, SQLState: 42S22
13:08:29.217 [http-nio-8001-exec-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Unknown column 'vms_contact_email' in 'field list'
13:08:29.674 [http-nio-8001-exec-1] INFO com.recruit.api.utils.Constants - /2022-09-22 13:08:29/Manager Details /create/could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement/500

Auto Samachar 22-Sep-22 5:59am View

@Modifying
@Transactional
@Query("UPDATE manager_details md SET md.vmsContactName=:VMSContactName, md.vmsContactPhone=:VMSContactPhone, md.vmsContactEmail=:VMSContactEmail, md.vmsPortal=:VMSPortal, md.state=:State, md.updatedAt=:updatedAt WHERE md.managerId = :manager_id")
int updateManager(@Param("manager_id") String managerId, @Param("VMSContactName") String vmsContactName, @Param("VMSContactPhone") String vmsContactPhone, @Param("VMSContactEmail") String vmsContactEmail, @Param("VMSPortal") String vmsPortal, @Param("State") String state,@Param("updatedAt") String updatedAt);

Auto Samachar 22-Sep-22 5:58am View

Deleted

`@Modifying
@Transactional
@Query("UPDATE manager_details md SET md.vmsContactName=:VMSContactName, md.vmsContactPhone=:VMSContactPhone, md.vmsContactEmail=:VMSContactEmail, md.vmsPortal=:VMSPortal, md.state=:State, md.updatedAt=:updatedAt WHERE md.managerId = :manager_id")
int updateManager(@Param("manager_id") String managerId, @Param("VMSContactName") String vmsContactName, @Param("VMSContactPhone") String vmsContactPhone, @Param("VMSContactEmail") String vmsContactEmail, @Param("VMSPortal") String vmsPortal, @Param("State") String state,@Param("updatedAt") String updatedAt);`