Support Questions

Find answers, ask questions, and share your expertise

NiFi QueryDatabaseTable and Oracle process: unable to get timestamp literal

Explorer

I am trying to incrementally ingest data from Oracle databases. In order to do that, I am using QueryDatabaseTable processor and then convert it to JSON using ConvertAvroToJSON processor. It pulls data successfully, however, when I examine JSON flowflies, I can see that timestamp and datetime columns hasn't been properly converted.

For example, when I am pulling data from a table that has column name updatedatetime_utc in a format of 22-MAR-17 08.28.05.000000000 AM, it is getting converted to something like:

 {"updatedatetime_utc": "oracle.sql.TIMESTAMP@4ac16a2a"}

What might the problem here?

2 REPLIES 2

New Contributor

Hi Yan

Are you able to resolve this issue, I am also facing the same issue.

New Contributor

I am able to resolve this by adding the following java argument to the bootstrap.conf available in nifi/conf directory

-Doracle.jdbc.J2EE13Compliant=true

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.