Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name

Question

Table name in Databse is: empCode

Spring boot table mapping :

@Column(name="empCode")
    String empCode;

getting error this:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'emp_code'.

RestController:

@GetMapping("/employee")
    public List<Employee> findAll() {
        return employeeService.findAll();
    }

I didn't define this emp_code anywhere, please assist why?

I changed the name in table from empCode to empCODE then it is working but in my office project I am facing same error but there I can't change column name because other organisation also using same database.

See baeldung.com/hibernate-naming-strategy

Lesiak
– Lesiak

2022-11-07 12:51:20 +00:00
Commented Nov 7, 2022 at 12:51 — Lesiak
– Lesiak, Commented Nov 7, 2022 at 12:51

Arie · Accepted Answer · 2022-11-07 12:59:59Z

1

Surround your column name with backticks:

@Column(name = "`empCode`")

This way hibernate will use the specific name instead of renaming it according to its own convention

answered Nov 7, 2022 at 12:59

Arie

1786 bronze badges

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

2 Comments

user9409705 Over a year ago

Not working still facing the same error.

Arie Over a year ago

And when you use @Column(name = "\"empCode\"") ?

Collectives™ on Stack Overflow

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related