Issue on loading data using JDBC data source

Amitra Bhunia
Tera Expert

‎10-15-2023 09:01 AM

I have installed mid server and mySQL database in docker in 2 deferent container,

AmitraBhunia_3-1697385190563.png

 

when I am tryin to connect the data base using data source from servicenow I am getting bellow error :

MID Server reported error: SQLState: null
java.sql.SQLException: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=127.0.0.1)(port=3306)(type=master) : Connection refused (Connection refused).

AmitraBhunia_0-1697384556971.png

 

 below is my data source configuration:

 

AmitraBhunia_1-1697384684013.png

I am able to connect the database and execute mySQL query from VS Code using below connection:

AmitraBhunia_2-1697385054663.png

Please help me on establishing the connection if anyone have worked on this.

 

 

0 Helpfuls
  • 2,655 Views
13 REPLIES 13

Amitra Bhunia
Tera Expert

‎10-16-2023 06:43 AM

I really need help on this thread. Thanks in advance.

0 Helpfuls

Amitra Bhunia
Tera Expert

‎10-18-2023 03:11 AM

Any help is appreciated.

0 Helpfuls

VivekSattanatha
Mega Sage
Mega Sage

‎10-18-2023 03:22 AM

It appears that the mid server running within the Docker container is experiencing a network connectivity issue with the SQL database, resulting in the reported firewall error. The action you are attempting to perform from Visual Studio Code involves connecting to the localhost of your local device, be it a laptop, desktop, or server. However, the mid server within the Docker container does not recognize the address 127.0.0.1, leading to the problem.

0 Helpfuls

Amitra Bhunia
Tera Expert
In response to VivekSattanatha

‎10-18-2023 04:27 AM

Then How can I identify the ip for the database server in docker, any idea? 

0 Helpfuls