[hop] branch master updated: added different ways of creating an oracle connection. fixes #2791

[ha...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

hansva pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hop.git


The following commit(s) were added to refs/heads/master by this push:
     new a866dd0e40 added different ways of creating an oracle connection. fixes #2791
     new 30c3a6f24e Merge pull request #2797 from bamaer/2791
a866dd0e40 is described below

commit a866dd0e40955d2e1663457e9abf64a1379c067d
Author: Bart Maertens <ba...@know.bi>
AuthorDate: Fri Mar 31 13:55:10 2023 +0200

    added different ways of creating an oracle connection. fixes #2791
---
 .../modules/ROOT/pages/database/databases/oracle.adoc       | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/docs/hop-user-manual/modules/ROOT/pages/database/databases/oracle.adoc b/docs/hop-user-manual/modules/ROOT/pages/database/databases/oracle.adoc
index aa39bef422..914b303625 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/database/databases/oracle.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/database/databases/oracle.adoc
@@ -34,3 +34,16 @@ under the License.
 
 TIP: Starting with Oracle Database 11g Release 1 (11.1), data type "Date" will be mapped to "Timestamp" by default. 
 Set JDBC property oracle.jdbc.mapDateToTimestamp=false to avoid data type "Date" being converted to data type "Timestamp".
+
+== Creating connections
+
+There are 3 ways to create a connection to an Oracle database in Apache Hop:
+
+* If you have a SID, 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 and port empty.
\ No newline at end of file