[JIRA] (CDAP-18354) Not able to create connection to the Oracle database in wrangler.

[Sagar Kapare (Jira)]

Sagar Kapare created an issue

CDAP / CDAP-18354 Not able to create connection to the Oracle database in wrangler. Issue Type: Bug Affects Versions: 6.5.0 Assignee: Prerna Bellara Components: Wrangler Created: 13/Aug/21 10:50 AM Priority: Critical Reporter: Sagar Kapare I try to create connection to the oracle database. Following is the connection JSON obfuscated hostname and password { "name": "oracle", "description": "testoracle", "category": "Database", "plugin": { "category": "Database", "name": "Oracle", "type": "connector", "properties": { "host": "1.2.3.4", "port": "1521", "connectionType": "service", "role": "normal", "jdbcPluginName": "oracle-thin", "user": "dbzuser", "password": "pwd" }, "artifact": { "scope": "SYSTEM", "name": "oracle-plugin", "version": "1.6.0-SNAPSHOT" } } } Don't have an option to enter either SID or service name. There is an option to select which method to use though. Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Sagar Kapare (Jira)]

Sagar Kapare commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler. I am able to connect to Oracle in 6.4.1 by specifying advanced connection string:

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Sagar Kapare (Jira)]

Sagar Kapare commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler.

Not sure if service name or SID can be provided as a part of connection arguments which is not very intuitive anyway. Even if we can, then documentation will need improvement as well as connection properties now becomes required field. Ideally we should have separate field for SID or TNS service name and/or accept advanced connection string as wrangler in 6.4.1

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Amit Virmani (Jira)]

Amit Virmani commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler.

This can be done using the Generic Database connection, right? Sean Zhou and Sagar Kapare ?

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Sean Zhou (Jira)]

Sean Zhou commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler.

This is by design. For DB specific connection, we don’t allow user to specify database (here it’s SID or TNS Service name) , only generic database connection allows user to specify database. All old connections will be migrated to generic database connection.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Sagar Kapare (Jira)]

Sagar Kapare commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler.

I think SID/TNS service name is different and at higher level than the database name. For connecting to Oracle instance we need SID or TNS service name, but we don't need database name.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)

[Yaojie Feng (Jira)]

Yaojie Feng commented on CDAP-18354

Re: Not able to create connection to the Oracle database in wrangler.

Sean Zhou since this is a regression, can we just add a field about it so user still able to specify it in 6.5?

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100172-sha1:2680ea2)