Oracle and Railo: query insert using CLOB throws an error (SOLVED)

[karniolus]

Today I had a problem with the combination of Railo and Oracle 11g Release.

In case of database insert using cfqueryparam type="cf_sql_clob" for CLOB field I got an error:

setString can only process strings of less than 32,766 chararacters

I was thinking and so I solved the error by updating the Oracle JDBC driver JAR file from 10.1.0.5.0 to the latest version 12.1.0.2.0 downloaded from the official Oracle website (http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html).

Update version was done by next steps:

1. Stop Railo Service

2. Renaming (or deleting) the old JAR file C:\railo\lib\ ojdbc14.jar to C:\railo\lib\ ojdbc14.jar_

3. Copying the new JAR file ojdbc7.jar

4. Starting Railo Service

I would suggest Lucee team to equip the new Lucee release with updated JAR file for Oracle if possible so that error could not happen again.

I hope I helped someone.

[Michael Offner]

FYI

Lucee 5 is moving the oracle datasource driver to an extension that can be maintained independent of the core ...

Micha

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/cfdd4a53-b71e-439f-a861-f76724f4fdcc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[karniolus]

If it will work then OK :) 

P.S: When will the Lucee installer for IIS be out for download?

Dne ponedeljek, 09. februar 2015 22.02.29 UTC+1 je oseba Micha napisala: