How can I implement an optional input parameter for a virtual procedure in DV

Solution Verified - Updated -

Issue

  • Stored procedures not properly handling nullable inputs
  • Error: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryPlannerException: No valid criteria specified for procedure parameter myModel.inputParameter, SQL State: 50000, Error Code: 0
  • Virtual procedure requiring a value in the input parameter, even though it is modeled as NULLABLE
  • Error: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryPlannerException: Join region with unsatisfied access patterns cannot be satisfied by the join criteria, Access patterns: [Access Pattern: Unsatisfied [...] History [[...]]] , SQL State: 50000, Error Code: 0"

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.3

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.