Receive "java.sql.SQLException: Missing IN or OUT parameter at index:: 1" in JBoss DV when executing FORMATTIMESTAMP function against an Oracle source

Solution Verified - Updated -

Issue

  • Errors in FORMATTIMESTAMP function
  • When executing formattimestamp against a column that is defined as timestamp(6) in the underlying data source, a "java.sql.SQLException: Missing IN or OUT parameter at index:: 1" is thrown.

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.0.0
  • Oracle data source

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content