Android Question jRDC2 problem with SQL nvarchar(MAX) columns

[Mostez]

I use jRDC2.2 with MS SQL server 2012, I have column with type nvarchar(max) when I try to get data, I receive (RuntimeException) java.lang.RuntimeException: Cannot serialize object:

I debugged ExecuteQuery2 in jRDC, this line

Dim ct As Int = rsmd.RunMethod("getColumnType", Array(i + 1))

returns 2005 if column type is nvarchar(max) or 12 if column type is sized to n number of chars say 2000, nvarchar(2000)
I set col size to 4000 to solve this problem for now, but I still need to fix it in jRDC cause I will face this problem with the rest of other tables!

 

[Mostez]

I added this line, it works ok, but don't know if is it 100% correct

Else if ct = 2005 Or ct = 12 Then 'SQL nvarchar(max), sized nvarchar and varchar data types
row(i) = jrs.RunMethod("getString", Array(i + 1))

 

[aeric]

Else If ct = 2005 Then ' Clob
    row(i) = rs.GetString2(i)

https://www.b4x.com/android/forum/threads/jrdc2-connect-to-mssqllocaldb.126513/post-801190

Another method is to set useLOBs=false in JdbcURL

JdbcUrl=jdbc:jtds:sqlserver://192.168.0.1:1433/DBName;useLOBs=false

 

[OliverA]

@aeric , @Mostez
Make a wish to have jRDC2 code updated to handle Clobs. This issue has been encountered more than once and it probably would be good if the base jRDC2 code would handle this case

 

[Erel]

Make a wish to have jRDC2 code updated to handle Clobs. This issue has been encountered more than once and it probably would be good if the base jRDC2 code would handle this case

Implemented in v2.23