java.sql.SQLException: Unknown column 'T\_designation.DEPARTMENT\_ID' in 'where clause'

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via openxava by janesh
, 1 year ago
Unknown column 'T\_designation.DEPARTMENT\_ID' in 'where clause'
via Oracle Community by 814491, 1 year ago
Syntax error or access violation message from server: "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 ''enrollment'' at line 1"
via Google Groups by Diego, 1 month ago
Syntax error or access violation, message from server: " You have an error in your SQL syntax near 'UNION SELECT Data_Scadenza,User FROM oggetti_permuta' at line 1"
via manageengine.com by Unknown author, 1 year ago
Communication link failure, message from server: "Server shutdown in progress"
via java2s.com by Unknown author, 1 year ago
General error, message from server: "Too many tables. MySQL can only use 31 tables in a join"
via sourceforge.net by Unknown author, 1 year ago
Column not found, message from server: "Unknown = column 'hostName' in 'field list'"
java.sql.SQLException: Unknown column 'T\_designation.DEPARTMENT\_ID' in 'where clause'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.openxava.tab.impl.JDBCTabProvider.nextBlock(JDBCTabProvider.java:235)
at org.openxava.tab.impl.JDBCTabProvider.nextChunk(JDBCTabProvider.java:258)
at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:35)
at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:296)
at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:120)
at org.openxava.tab.impl.TableModelBean.getValueAt(TableModelBean.java:171)
at org.openxava.tab.impl.XTableModelDecoratorBase.getValueAt(XTableModelDecoratorBase.java:63)
at org.openxava.tab.impl.HiddenXTableModel.getValueAt(HiddenXTableModel.java:70)
at org.openxava.calculators.DescriptionsCalculator.read(DescriptionsCalculator.java:105)
at org.openxava.calculators.DescriptionsCalculator.calculate(DescriptionsCalculator.java:58)
at org.openxava.calculators.DescriptionsCalculator.getDescriptions(DescriptionsCalculator.java:150)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
2 times, 1 day ago
2 times, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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