java.sql.SQLException: Unknown column 'departmen4_1_.VALID_SECTOR' in 'where clause'


Solutions on the web

Solution icon of hibernate
via Hibernate JIRA by user1, 1 year ago
Unknown column 'departmen4_1_.VALID_SECTOR' in 'where clause'

Solution icon of hibernate
via Hibernate JIRA by user1, 1 year ago
Unknown column 'departmen4_1_.VALID_SECTOR' in 'where clause'

Solution icon of web
via developpez.net by Unknown author, 1 year ago
Unknown column ' ' in 'where clause'

Solution icon of hibernate
via Hibernate JIRA by Sven Henckel, 1 year ago
Unknown column 'ls' in 'where clause'

Solution icon of oraclecommunity
via Oracle Community by 843859, 10 months ago
Unknown column 'ortet' in 'where clause'

Solution icon of oraclecommunity
Unknown column 'avg_rating' in 'where clause'

Solution icon of hibernate
via Hibernate JIRA by Sven Henckel, 1 year ago
Unknown column 'ls' in 'where clause'

Solution icon of stackoverflow
Unknown column 'flag' in 'where clause'

Solution icon of sourceforge
Unknown column 'T\_designation.DEPARTMENT\_ID' in 'where clause'

Solution icon of web
Column not found, message from server: "Unknown column 'false' in 'where clause'"

Stack trace

java.sql.SQLException: Unknown column 'departmen4_1_.VALID_SECTOR' in 'where clause'
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
	at org.hibernate.loader.Loader.doList(Loader.java:2147)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
	at org.hibernate.loader.Loader.list(Loader.java:2021)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 2 months ago
2 times, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 week ago
5 times, 3 months ago
23 more bugmates