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 (
).
Update version was done by next steps:
-
Stop Railo Service
-
Renaming (or deleting) the old JAR file C:\railo\lib\ ojdbc14.jar to C:\railo\lib\
ojdbc14.jar_
-
Copying the new JAR file ojdbc7.jar
-
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 (
JDBC and UCP Downloads page
).
Update version was done by next steps:
-
Stop Railo Service
-
Renaming (or deleting) the old JAR file C:\railo\lib\ ojdbc14.jar to C:\railo\lib
ojdbc14.jar_
-
Copying the new JAR file ojdbc7.jar
-
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
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 (
JDBC and UCP Downloads page
).
Update version was done by next steps:
-
Stop Railo Service
-
Renaming (or deleting) the old JAR file C:\railo\lib\ ojdbc14.jar
to C:\railo\lib\ ojdbc14.jar_
-
Copying the new JAR file ojdbc7.jar
-
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.