After a deployment to our prod server, some pages do not display and we see this error in the logs:
java.lang.NoSuchMethodError: org.hibernate.hql.antlr.HqlBaseParser.recover(Lantlr/RecognitionException;Lantlr/collections/impl/BitSet;)V
It smells like a lib issue, but its not, its actually an HQL syntax issue
It smells like a lib issue, but its not, its actually an HQL syntax issue
the offending HQL was this - can you spot the problem:
'select dattrDesc, dattrDesc.deviceLocalContent.displayName, dattrDesc.deviceLocalContent.deviceContentId, dattrDesc.attributeName, dattrDesc.attributeValue, dattrDesc.link, '', '', '' from DeviceAttributes dattrDesc'
this thing was commited into a database table.
Solution:
This part , '', '', '' created an issue, it should have been , '''', '''', '''' to escape the quotes for SQL.
thanks! couldn't see how to quote a quote in HQL until I spotted this!
ReplyDeleteBut don't quote a quote quote unless you also quote the quote quote quote.
ReplyDeleteCan I quote you on that?
ReplyDeleteTHANKS FOR POSTING.
ReplyDeleteI TOO FACED THE PROBLEM.
NOW RESOLVED.
THANK YOU SOOOOO MUCH
useful
ReplyDeleteThanks It is Useful
ReplyDeletela ni la hu na ji pola ki kola
ReplyDelete