When I use P15 character set encoding in Oracle, I can see that some of the Business Events tables are not getting populated neither an error is thrown during insert, how to solve it?

When I use P15 character set encoding in Oracle, I can see that some of the Business Events tables are not getting populated neither an error is thrown during insert, how to solve it?

book

Article ID: KB0091516

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
The investigation shows that this is NOT a problem with normal fields, but with a linked table type structures, the reason that no errors are thrown during an insert is because the underlying JDBC calls does not throw an exception back to the caller.

The solution is to include orai18n.jar in the lib/ext directory, or in the classpath that you have mentioned in your .TRA file.

Issue/Introduction

When I use P15 character set encoding in Oracle, I can see that some of the Business Events tables are not getting populated neither an error is thrown during insert, how to solve it?