Search code examples
castingjtds

net.sourceforge.jtds.jdbc.clobimpl cannot be cast to java.lang.string(jTDS)

useBlobs=false using XAPoolDataSource.

Throws an exception like 'title description while call resultset.getObject()'

I don`t know what the issue is.

Solution

  • Common Connection String

    jdbc:jtds:sqlserver://ServerName;DatabaseName=xxx;instance=xxx

    Rule from official site

    jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

    My Solution to solve exception as title mentioned

    jdbc:jtds:sqlserver://ServerName;useLOBs=false;DatabaseName=xxx;instance=xxx

    please put useLOBs=false; as first param