JBEDS "Native query" with jdbc-simple translator errors about needing an alias
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.