Lucee’s cfqueryparam for sqltype=“clob” explicitly calls createClob() method
which loads “oracle.sql.CLOB” class. We are using Teradata and this causes
errors in CLOB creation. I’d like to attempt to create a solution so Lucee
CLOBs can work on Teradata. If I’m successful, I can contribute the code to
the Lucee community. Can someone provide the listing of files, jars,
methods, etc that need to be modified in order to incorporate this
enhancement?
The error message detail:
[Teradata JDBC Driver] [TeraJDBC 15.00.00.08] [Error 165] [SQLState HY000]
createClob: function not supported in this version
Stracktrace:
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(
ErrorFactory.java:93):93
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(
ErrorFactory.java:68):68
at com.teradata.jdbc.jdbc_4.TDSession.createClob(TDSession.java:1623):1623
at lucee.runtime.db.driver.ConnectionProxy.createClob(Unknown Source):-1
at lucee.commons.sql.SQLUtil.toClob(Unknown Source):-1
at lucee.runtime.db.SQLCaster.setValue(Unknown Source):-1
at lucee.runtime.type.QueryImpl.setItems(Unknown Source):-1
at lucee.runtime.type.QueryImpl.(Unknown Source):-1
at lucee.runtime.tag.Query.executeDatasoure(Unknown Source):-1
at lucee.runtime.tag.Query.doEndTag(Unknown Source):-1
at dev.gss_helpdesk.wizardwritedata_cfm$cf.call(C:\inetpub\wwwroot\dev
GSS_Helpdesk\wizardWriteData.cfm:722):722
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at dev.gss_helpdesk.requestwizard_cfm$cf.call(C:\inetpub\wwwroot\dev
GSS_Helpdesk\requestWizard.cfm:33):33
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ClassicAppListener._onRequest(Unknown Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:303):303
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208):208
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241):241
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208):208
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve
.java:220):220
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve
.java:122):122
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
AuthenticatorBase.java:503):503
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
170):170
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
103):103
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:116):116
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
421):421
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190):190
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:611):611
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.
java:314):314
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java
:1145):1145
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
java:615):615
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread
.java:61):61
at java.lang.Thread.run(Thread.java:745):745