Cfconfig errors when trying to import Oracle DBs in CF2021

Description

When we try to use cfconfig to import our oracle DBs in CF2021 we get an error. The problem seems to be surrounding SID and Service name fields. You can only import/choose one of these when setting up an Oracle DB, but when you do – it complains that the datasource is missing the other field.

For example, below we tried to import the Oracle DB including the SID & it complained that the Service Name was missing.

Environment

None

Activity

Show:
Brad Wood
January 15, 2021, 9:39 PM

I need exact steps to reproduce this and any JSON in question. A screenshot doesn’t tell me what you did to get there.

Adam Ross Russell
January 15, 2021, 10:04 PM

After talking with Brad in the CFML slack channel it looks like this may be because the Service Name field is new in 2021.

This is not currently included as a field in cfconfig:
https://github.com/Ortus-Solutions/cfconfig/blob/master/models/BaseAdobeDSNMapper.cfc#L310-L387

Adam Ross Russell
January 15, 2021, 10:18 PM

For testing purposes this simple datasource JSON can be used to try to import a test oracle db:

"datasources": { "datasource-name": { "database": "dbname", "dbdriver": "Oracle", "host": "hostname.edu", "SID":"DEV", "password": "password", "port": "1521, "username": "username" } }

Assignee

Unassigned

Reporter

Adam Ross Russell

Labels

None

Priority

Major