Skip to content
Advertisement

Spring boot “oracle.jdbc.OracleDatabaseException: ORA-00904: invalid identifier” Error while creating table

In spring boot, I create tables of the database using the Code-First approach. then while running the application, the result for one of tables shows this error:

JavaScript

The class entity is as follow:

JavaScript

Does anyone know where is the problem?

Advertisement

Answer

This is wrong:

JavaScript

date is a reserved word for Oracle datatype. Change column name to something else, e.g. datum, c_date, statistic_date, … and then run

JavaScript
User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement