Inserts of Metadata with Apostrophes Into IBM UDB/DB2 Database Throws SQL Error: "SQLCODE: -104, SQLSTATE: 42601"
(Doc ID 446945.1)
Last updated on MAY 10, 2023
Applies to:
Oracle WebCenter Content - Version 7.0 and laterInformation in this document applies to any platform.
This issue can occur when attaching to an IBM DB2/UDB database with Content Server via JDBC.
d
Symptoms
Inserts of metadata with apostrophes, including inserts of Options List data, into an IBM UDB/DB2 Database during check-in or Configuration Manager use, fail with DB2 SQL Error:
SQL0104N An unexpected token ....... SQLSTATE=42601
or
Error Updating options list. Unable to execute service UPDATE_OPTIONS_LIST and
function updateOptionsList.
(System Error: Unable to execute query 'Ioption(INSERT INTO OptionsList (dKey,
dOption, dOrder) values (N'ClientNameList',N'Customer''s Name',3))'.
DB2 SQL error: SQLCODE: -104, SQLSTATE:42601, SQLERRMC: 's Name';
ntNameList',N'Customer';<space>)
function updateOptionsList.
(System Error: Unable to execute query 'Ioption(INSERT INTO OptionsList (dKey,
dOption, dOrder) values (N'ClientNameList',N'Customer''s Name',3))'.
DB2 SQL error: SQLCODE: -104, SQLSTATE:42601, SQLERRMC: 's Name';
ntNameList',N'Customer';<space>)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |