Error in Hibernate when executing web project

Question

Error in Hibernate when executing web project

Navigation

#1 by (0 votes)

1

I have an error that I could not solve, I started my project and it runs right. When I access the project via the web, I log in and it enters. When I click on any button, it gives this error below:

Hibernate:

select
    person0_.id as id1_3_,
    person0_.accessUserName as accessUs2_3_,
    person0_.hourPay as hourPay3_3_,
    person0_.name as name4_3_,
    person0_.version as version5_3_ 
from
    Person person0_ 
where
    person0_.accessUserName=?

Error:

2017-01-10 11: 46: 32,889 [http-bio-8080-exec-1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: column person0_.accessusername does not exist Tip: Perhaps you meant to reference the column "person0_.access_user_name". Position: 31

sql java hibernate

asked by anonymous 10.01.2017 / 15:02

1 answer

Remote Connection Mysql 5.6 and Ubuntu 15.10 How to encrypt and decrypt data in Swift 3 to form native without using any external lib

score 0 · Answer 1

The error message is very clear - the accessusername column of your select does not exist, but the access_user_name column exists.

So, what you have to do is fix your SQL query by correcting the spelling of that column name.