I am using macOS High Sierra on MacBook Pro 2017. I upgraded to macOS Mojave and used the same test case which connects to a database from Katalon Studio. It could not connect to the database. On Katalon, I went to Project ➞ Settings ➞ Database and filled in the connection. It looked like the connection was timed out.
I proved it by formatting my MacBook back to macOS High Sierra. The test case could run normally and on Project Settings it said Connection Successful. Then, I upgraded to macOS Mojave again. All failed. Neither restarting MacBook nor reinstalling Katalon helped at all.
I need to stick to using macOS High Sierra for the sake of database connection while I have re-written the test case to avoid it for my colleagues who are using macOS Mojave. I will try to update the error message from console as soon as possible since it is a long holiday here now.
Error Message:
Connection failed! SQL Server did not return a response. The connection has been closed.
It simply says it can’t connect to the database, but this happens on Mojave only, not on High Sierra.
Has anyone found this issue before?
Could you please try connecting to the database server using another client and see if it works?
It is happening to all Mojave macbooks.
Are there any logs to read?
I also found that database cannot be connected on macOS Catalina either. Not sure if this becomes specific to these macOS on MacBook Pro 2017
No one has really given me any clue nor can I still find the solution.
@duyluong
Currently, I have my colleagues test two computers where the connection does not work.
- Katalon version 7.2.1, MS SQL Server 12.00.2000, macOS Catalina (10.15.4)
- Katalon version 7.2.1, MS SQL Server 12.00.2000, macOS Mojave (10.14.4)
Database settings are done by navigating to Project ➞ Settings ➞ Database and the error is as shown in the figure. Here I need to censor some prominent words.
Tracing back older versions, I have tried since Katalon version 6.x.x on Mojave and couldn’t make it. On their computers, we have tried another database tool, such as DBeaver, and it can connect to the databases normally.
I am using macOS High Sierra (10.13.6) on my MacBook without any issue regardless of Katalon versions at this moment.
@duyluong
The same error occurs.
What is different from my previous settings is adding more arguments in the connection URL, is it?
No luck for me, is there?
@kawin.k
Please try with pre-release v7.4.4: https://github.com/katalon-studio/katalon-studio/releases/tag/v7.4.4. We updated the MSSQL JDBC driver from 4.1 to 6.2.2
@duyluong
Superb, it can connect to the database now, tested on Mojave. Did that happen because of JDBC driver being too old to be compatible with the new macOS versions? Is there a way to update the driver manually in Katalon’s current version?
