Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

If you are connecting

D s product
to any relational source of data, such as Redshift or Oracle, you must add the
D s item
itemService
to your whitelist for those resources.For more information, see Getting Started with Cloud Dataprep.

Supported Versions: 5.7 and 8.0 Community

  • Read: Supported
  • Write: Supported

...

Error messageDescription
1042 - ER_BAD_HOST_ERROR

Unable to connect to host. Please verify the host and port values.

1045 - ER_ACCESS_DENIED_ERROR

Credentials failed to connect. Please verify your credentials.

Tip

Tip: Click the Test Connection button to verify that your credentials are working properly.

Error: zero date value prohibited

Set the following option in the connect string options:

Code Block
zeroDateTimeBehavior=convertToNull
Prepared statement needs to be re-prepared.

Database Cursor is not compatible with PREPARED statements in MySQL. The fix is to set the following in the Connect String Options:

Code Block
useCursorFetch=false

For more information on error messages for this connection type, see https://dev.mysql.com/doc/refman/8.0/en/error-handling.html.

...