'AWS Crawler Throwing Connection Error When Glue Connection Test Passes

I'm hitting an error on AWS and oogle has not been much help thus far. Here is the problem I have. I have setup a connection in Glue to my Oracle RDS. When I test the connection it passes. When I run the Crawler it fails with the following error:

ERROR : Error crawling database my_oracle_db:
SQLException:
SQLState: 08006
Error Code: 17002
Message: IO Error: Invalid connection string format, a valid format is: "host:port:sid"

I have manually altered the JDBC connection string so that the / between port and SID is replaced with : I did test the connection both ways, and the test passed. What could be causing the error to get thrown?

aws-glue

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'AWS Crawler Throwing Connection Error When Glue Connection Test Passes

Sources

Related Questions