Presto: v0.241 Oracle Connector logon denied

Created on 28 Sep 2020  路  3Comments  路  Source: prestodb/presto

After installing and configuring Oracle Connector, the execution query shows "ORA-01017: invalid username/password; logon denied"

https://github.com/prestodb/presto/blob/715704fd0c09f354cb518d6c24ebc30a3f49d6a9/presto-oracle/src/main/java/com/facebook/presto/plugin/oracle/OracleClientModule.java#L47

It seems that ORACLE parameters are not processed?

picture shigechuanqi

Most helpful comment

As a workaround... this worked for me. Change your jdbc uri to this format:
jdbc:oracle:thin:user/password@//<host>[:<port>]/<service>

picture brokenjacobs on 8 Oct 2020
👍4

All 3 comments

Seeing the same thing here. Our custom oracle connector from previous versions worked.

brokenjacobs picture brokenjacobs on 8 Oct 2020

As a workaround... this worked for me. Change your jdbc uri to this format:
jdbc:oracle:thin:user/password@//<host>[:<port>]/<service>

brokenjacobs picture brokenjacobs on 8 Oct 2020
👍4

浣滀负瑙ｅ喅鏂规硶锛岃繖瀵规垜鏈夌敤銆傚皢鎮ㄧ殑jdbc uri鏇存敼涓轰互涓嬫牸寮忥細
jdbc:oracle:thin:user/password@//<host>[:<port>]/<service>

Thank you very much.

At present, it is also used in this way

shigechuanqi picture shigechuanqi on 9 Oct 2020
Was this page helpful?
0 / 5 - 0 ratings

Related issues

cps333 picture cps333  路  3Comments
haozhun picture haozhun  路  4Comments
electrum picture electrum  路  4Comments
synhershko picture synhershko  路  4Comments
tomz picture tomz  路  3Comments