Query External Database: This connection has been closed

0
Hi,   I have establish a Postgre database connection and it is fine when I am running a query in Studio pro. I created the entity based on the response.   However, when I calling this query from microflow using the "Query external database" and run the application locally, I am receiving the error that the connection is closed. Anything i missed?            
asked
1 answers
0

Regarding debugging, since you have external db connector installed, you should see a Log Node by the same name. You can find this in your Console View > Advanced > Set log levels > external database connector > set it to Trace.

It should give you outputs like below 

executeQuery: jdbc:postgresql://localhost:5432/testdb, root, select * from employees

Getting connection from data source in connection pool for [url=jdbc:postgresql://localhost:5432/testdb, user=root]

Result list count: 3

See if you can spot something abnormal there. This should reveal enough information for you to find the RCA.

answered