Connecting an Oracle Db hosted on Amazon RDS to my Flask project on IDEA Ultimate
Answered
Hi All,
I'm working on a web application using the Flask framework. I have been trying to connect my Oracle DB hosted on Amazon RDS, but am having a lot of trouble. Here is what it looks like for me:
By the way, I have ensured that my db instance allows for inbound traffic from my computer using the appropriate security settings on AWS.
Please sign in to leave a comment.
JDBC syntax URL seems to be invalid/unsupported, see the related issue https://youtrack.jetbrains.com/issue/DBE-7541.
URL syntax is "jdbc:
driver://hostname:port/dbName?user=userName&password=password".See also: https://docs.aws.amazon.com/glue/latest/dg/console-connections.html:
To connect to an Amazon RDS for Oracle data store with an employee service name:
jdbc:oracle:thin://@xxx-cluster.cluster-xxx.us-east-1.rds.amazonaws.com:1521/employee
The syntax for Amazon RDS for Oracle can follow the following patterns:
jdbc:oracle:thin://@host:port/service_name
jdbc:oracle:thin://@host:port:SID
Thank you for the super quick reply! I think the link to the Amazon documentation is expired. Should I be following this format then?
"jdcbc:oracle:thin:<endpoint link for AWS instance>"
I apologize for the followup question and/or if I am not being clear enough.
It should start with jdbc:oracle:thin.
Here is what I put for my URL:
"jdbc:oracle:thin:hostname:port:SID"
Where
hostname = endpoint URL for AWS RDS Oracle DB instance
port = 1521
SID = db name
but, I'm getting this error:
jdbc:oracle:thin://host:port/
Did you forget the double slashes?
I did! Thank you! Now I am getting this error:
Which baffles me, since I am pretty sure I am putting in the correct SID (my db name).
I used this format for the url:
jdbc:oracle:thin://host:port:SID
Where
host = endpoint URL for AWS RDS Oracle DB instance
port = 1521
SID = db name
Got it to work!! Checked my configuration tab on AWS which shows a different db name than what is shown on the summary tab.