My Oracle Support Banner

Modify Oracle JDBC Driver Behavior to Align with DataDirect Driver for Handling Trailing Spaces (Doc ID 3062199.1)

Last updated on DECEMBER 09, 2024

Applies to:

JDBC - Version 19.12 and later
Information in this document applies to any platform.

Goal

The recent 19.24 RU caused significant issues with many of our Tibco integrations that utilize the DataDirect JDBC driver. Switching to the Oracle JDBC driver resolves the issue with 19.24 but introduces a new challenge. The DataDirect driver automatically trims trailing spaces when comparing a bind to both CHAR and VARCHAR2 columns, whereas the Oracle driver does not. Tibco has recommended working with Oracle to incorporate this behavior into your driver. Would it be possible to implement this?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.