Search code examples
javaweblogic12c

Weblogic 12.2.1.4 - java.sql.SQLException / CLOB Compatibility Issue

After upgrading to Weblogic 12.2.1.4, we're seeing that certain functions (for example length() and getCharacterStream()) that read CLOB data are throwing java.sql.SQLException: Connection has already been closed errors. Is there some kind of compatibility issue with WL 12.2.1.4? Is there an alternative way of processing CLOBs?

Solution

  • I have solved this error by changing the settings in Weblogic connection pool used . https://docs.oracle.com/middleware/1212/wls/WLACH/taskhelp/jdbc/jdbc_datasources/DisableWrapping.html Advanced setting : In Wrap Data Types, deselect the checkbox todisable wrapping