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

Current Customers and Partners

Log in for full access

Log In