java.sql.SQLSyntaxErrorException: Unknown column 'orderDate' in 'field list'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by russellhoff
, 7 months ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null WHERE key ='SV2'' at line 1
via Hibernate JIRA by Binoy Shah, 11 months ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint UK_8eumjccoobf7t6psn9exu4gnh' at line 2
via Stack Overflow by ieXcept
, 11 months ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''create_and_populate_schema'() BEGIN DECLARE '_rollback' BOOL DEFAULT 0; ' at line 1
via GitHub by ffauteux
, 2 months ago
Unknown table 'osiam_client' in information_schema
via GitHub by xuminwlt
, 2 months ago
Unknown column 'playplayer_id' in 'on clause'
java.sql.SQLSyntaxErrorException: Unknown column 'orderDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:686)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2041)
at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1827)
at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2041)
at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1977)
at com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:4963)
at com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1962)

Users with the same issue

80 times, 1 year ago
2 times, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago
6703 times, 4 days ago
Once, 3 weeks ago
7 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.