Article

JDBC connection adds username to table name in error

Information

 
Article Number000091472
EnvironmentProduct: OpenEdge
Version: 11.7
OS: Windows 7
Question/Problem Description
Trying to make a SQL call connection through the JDBC driver and the driver seems to add the username to the front of the database table name in the call. 
The database is owned by another user. How to make the call querying the database in another user schema?
Steps to Reproduce
Clarifying Information
Running the SQL command:
SELECT TBLOWNER FROM sysprogress.systabauth WHERE TBL = '<table-name>';
returns "PUB" as the table owner.
Error Message[DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "<username>.<table-name>" cannot be found. (15814)
Defect/Enhancement Number
Cause
When the user runs SQL queries and he is not the table owner, it is necessary to specify the table owner before the table name.
Resolution
Fix the SQL command adding the table owner in front of the table name.
I.e:
SELECT * FROM PUB.<table-name>;

 
Workaround
Create a public synonym for the user:

CREATE PUBLIC SYNONYM <synonynm-name> FOR PUB.<table-name>;
Notes
Attachment 
Last Modified Date9/10/2018 6:49 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025