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 <[email protected]>
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
