pahervin opened a new issue, #4225: URL: https://github.com/apache/hop/issues/4225
### Apache Hop version? 2.8 ### Java version? openJdk 11.0.2 ### Operating system Windows ### What happened? In the Metadata tab, set a Relational Database Connection 1. Set the Connection name 2. Set the Connection type : Oracle 3. Use the default provided Driver 4. Set the Username and the Password 5. Set the connection URL with the ojbdc alias syntax : jdbc:oracle:thin:@my_alias 6. In Options tab, set JDBC option : oracle.net.tns_admin=my_path_to_tnsnames.ora_directory 7. Set leave empty the other fields 8. Check the TNS_ADMIN environnement variable is properly set 9. Click on the Test button The connection attempt produce an exception. This connection URL is used successfully with other java tools (sqldevelopper, Talend). 1. Change the Connection URL : jdbc:oracle:thin:@my_alias?TNS_ADMIN=my_path_to_tnsnames.ora_directory 2. Click again on the Test button The connection attempt produce an exception again. 1. Change the Connection URL : jdbc:oracle:thin:@my_hostname:1521:my_SID 2. Click again on the Test button The connection is established successfully. ### Issue Priority Priority: 2 ### Issue Component Component: Hop Gui -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
