java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

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 Atlassian JIRA by William Crighton [CCC], 1 year ago
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
via Atlassian JIRA by William Crighton [CCC], 1 year ago
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
via jtds by cpalmera
, 1 year ago
Column or parameter \#1: Specified column precision 38 is greater than the maximum precision of 28.
via jtds by jwdavison
, 1 year ago
The identifier that starts with 'LastNacreate proc \#jdbc\#16(@P1 decimal(38,0), @P2 decimal(38,0), @P3 decimal(38,0), @P4 decimal(38,0), @P5 decimal(38,0), @P6 de' is too long. Maximum length is 128.
via springframework by *anonymous
, 1 year ago
Violation of UNIQUE KEY constraint 'UQ\_\_system\_\_00082F07'. Cannot insert duplicate key in object 'system'.
via jtds by syncat
, 1 year ago
The cursor is READ ONLY.
java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
at net.sourceforge.jtds.jdbc.Tds.submitProcedure(Tds.java:235)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

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