JBEDS "Native query" with jdbc-simple translator errors about needing an alias

Solution Verified - Updated -

Issue

  • We have the issue with native queries in our JBEDS environment. To be precise it is related only to PI system to which we are connecting using PI JDBC Driver (com.example.jdbc.Driver) configured with the jdbc-simple translator. When we run our query we receive the following error:
Error: alias needed. When native query is being used, then alias name must be defined for table in the query.

SQLState:  38000

ErrorCode: 0

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.3.0

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