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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.