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

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.

FYI

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

MichaOn Mon, Feb 9, 2015 at 7:12 PM, karniolus <@karniolus> wrote:

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.


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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/cfdd4a53-b71e-439f-a861-f76724f4fdcc%40googlegroups.com
https://groups.google.com/d/msgid/lucee/cfdd4a53-b71e-439f-a861-f76724f4fdcc%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

If it will work then OK :slight_smile:

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:>

FYI

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

Micha

On Mon, Feb 9, 2015 at 7:12 PM, karniolus <alojz....@gmail.com <javascript:>> wrote:

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.


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 <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/cfdd4a53-b71e-439f-a861-f76724f4fdcc%40googlegroups.com
https://groups.google.com/d/msgid/lucee/cfdd4a53-b71e-439f-a861-f76724f4fdcc%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.