Read From Database Filter Crashes With Null Pointer Exception When The SQL Is Passed As Variable

(Doc ID 1608477.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle API Gateway - Version 11.1.2 and later
Information in this document applies to any platform.

Symptoms

While using the "Retrieve from or write to database" filter to query a table from DB, an NPE error is encountered. The query works fine if the SQL is static; after changing the SQL to be read from a message variable instead, the Filter throws an NPE Exception:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms