Question
DXC Technology
BG
Last activity: 16 Sep 2020 6:47 EDT
java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 2075, maximum: 2000)
Hello,
we are involved in a project where some Oracle databases have to be configured in the Arcsight Oracle Smart Connector using JDBC connection string. I am responsible to provide it to my colleague and for me it seems without any issues but here is the error that occurred:
*I filled with stars the hosts and the service name because it is confidentional information.
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(CONNECT_TIMEOUT=3)(RETRY_COUNT=1)(ADDRESS_LIST=(LOAD_BALANCE=off)(ADDRESS=(PROTOCOL=tcp)(HOST=*******)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=*****)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=*****)))
*** Passes initial Validation, but the below error appears in the log file. *** INFO | jvm 46 | 2020/09/10 15:48:52 | FATAL EXCEPTION: INFO | jvm 46 | 2020/09/10 15:48:52 | java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 2075, maximum: 2000)
Could you please explain me or at least clarify why this kind of error had occurred? My first reply to my colleague was to contact a developer because this error ORA-22835 is not related to the connection string but he asked me to escalate to someone else who can check. On the other servers we didn't face this error.
Thank you in advance!