[Solved] SAP DBTech JDBC: Cannot convert SQL type VARCHAR to Java type java.sql.Clob.

[Former Member]

Hello,

I have an issue with getting records from a table wiith CLOB columns. I am using spring boot to access HANA using JPA query. Some of the clob column values can be null.

When doing any retrieval like findAll(), i get the error:

Wed Mar 04 12:14:01.840 PST 2020 [scheduling-1:::::] [o.h.e.jdbc.spi.SqlExceptionHelper: WARN ][] [] - SQL Error: -11214, SQLState: 07006
Wed Mar 04 12:14:01.840 PST 2020 [scheduling-1:::::] [o.h.e.jdbc.spi.SqlExceptionHelper: ERROR][] [] - SAP DBTech JDBC: Cannot convert SQL type VARCHAR to Java type java.sql.Clob.

Can anyone help me ?

Edit: I was able to figure it out. The issue is pretty interesting. The column apparently was a VARCHAR column previously which was altered to a CLOB column. Turns out, we should never do that. The right way is to create a temp column, move the contents from this col to the temp and drop the previous column (edited)

[lbreddemann]

You might want to take a deeper look into how your result set is mapped to the query/table in HANA. The error message indicates that a VARCHAR on HANA should be mapped to a CLOB in JAVA/JDBC.

Based on https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/5be923a2e5bc45afaee4937f98... this is not a valid conversion.