v0.241 Oracle Connector logon denied

[shigechuanqi]

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

presto/presto-oracle/src/main/java/com/facebook/presto/plugin/oracle/OracleClientModule.java

Line 47 in 715704f

public static ConnectionFactory connectionFactory(BaseJdbcConfig config, OracleConfig oracleConfig)

It seems that ORACLE parameters are not processed?

[brokenjacobs]

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

[brokenjacobs]

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

[shigechuanqi]

作为解决方法，这对我有用。将您的jdbc uri更改为以下格式：
jdbc:oracle:thin:user/password@//<host>[:<port>]/<service>

Thank you very much.

At present, it is also used in this way

[rahmanmd007]

I am using Presto 0.265.1 and it is not working for me.
I have tried both:
connector.name=oracle
connection-url=jdbc:oracle:thin:@example.net:1521/ORCLCDB
connection-user=root
connection-password=secret
When I used the above, I get ORA-01017 error
AND when I use the following I get 'Invalid URL Specified' Error. Can someone please help?
connector.name=oracle
connection-url=jdbc:oracle:thin:user/password@//[:]/

[jameskim0987]

The docs here helped me. http://www.orafaq.com/wiki/JDBC

jdbc:oracle:thin:[<user>/<password>]@//<host>[:<port>]/<service>

[rahmanmd007]

@jameskim0987 That worked.. Thanks!