Hi Team,
Please help me to solve the below issue:
org.mule.module.db.internal.domain.connection.ConnectionCreationException: java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:Ramarao/admin123@PXDTHCLAA8277:1521:XE : The Network Adapter could not establish the connection (java.sql.SQLException) (org.mule.module.db.internal.processor.DbConnectionException).
app url: http://sbi-applications.cloudhub.io/api/Bank
i have successfully deploy the application onto cloud but when i try to copy the url into web browser it's showing the above error.
Your application is deployed successfully and this can be verified using http://sbi-applications.cloudhub.io/console but when you send any request its trying to connect to the database from cloudhub and failing.
Firstly check if the connection parameter are correct.
If yes, you need to check if there are any firewall rules or any IP filter at the database end that allows incoming traffic only from specific IPs. If yes you need to allocate a static IP to your instance in CloudHub and configure the same on the database side, so connections from Cloudhub to database are established successfully.