Hi Team,
I am migrating ColdFusion application(windows) to Lucee(Ubuntu). My application is using Teradata Database, where DB schema is configured to use CLOB data type. SO, from the application, passing the data to the stored procedure “”.
When i submit the form, Getting the below exception:
“Severity”,“ThreadID”,“Date”,“Time”,“Application”,“Message”
“ERROR”,“http-nio-8008-exec-9”,“02/24/2021”,“08:17:13”,“StoredProc”,"[Teradata JDBC Driver] [TeraJDBC 16.20.00.12] [Error 165] [SQLState HY000] createClob: function not supported in this version;[Teradata JDBC Driver] [TeraJDBC 16.20.00.12] [Error 165] [SQLState HY000] createClob: function not supported in this version;java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.12] [Error 165] [SQLState HY000] createClob: function not supported in this version
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:95)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:70)
at com.teradata.jdbc.jdbc_4.TDSession.createClob(TDSession.java:1459)
at lucee.commons.sql.SQLUtil.toClob(SQLUtil.java:164)
at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:182)
at lucee.runtime.tag.StoredProc.doEndTag(StoredProc.java:590)
at efixprocess.api_buildrequest_insert_cfm$cf.call(/etars/EfixProcess/API_BuildRequest_Insert.cfm:85)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:914)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at efixprocess.buildrequestaction_cfm$cf.call(/etars/EfixProcess/BuildRequestAction.cfm:111)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:914)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1127)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1073)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
OS: Ubuntu 18.04.5 LTS
Java Version: openjdk version “11.0.7” 2020-04-14
Tomcat Version: Apache Tomcat Version 9.0.35
Lucee Version: lucee-5.3.6.61
Can someone help me here.