[GitHub] [hop] bamaer opened a new issue, #2791: [Task]: improve Oracle database connection docs

["bamaer (via GitHub)" <gi...@apache.org>]

bamaer opened a new issue, #2791:
URL: https://github.com/apache/hop/issues/2791

   ### What needs to happen?
   
   https://chat.project-hop.org/hop/pl/7r5ar8dyjiboudcuh5srzqt61y
   
   @nadment: There are 3 ways to setup a connection for oracle in Hop.
   
   If you have a SID, to use this (old) format: jdbc:oracle:thin:@HOSTNAME:PORT:SID
   Put the SID as is in the database name
   
   If you have a service name, use this (newer) format: jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME
   Put the service name with '/' prefix in the database name
   
   If you want to use TNS format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host) (PORT=port)) (CONNECT_DATA=(SERVICE_NAME=service_name))
   Put the TNS description in the database name and leave the hostname empty as well as the port.
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Database, Component: Documentation


-- 
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: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [hop] hansva closed issue #2791: [Task]: improve Oracle database connection docs

["hansva (via GitHub)" <gi...@apache.org>]

hansva closed issue #2791: [Task]: improve Oracle database connection docs
URL: https://github.com/apache/hop/issues/2791


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org