java.sql.SQLException: No suitable driver found for jdbc:postgresql

After opening the Katalon Studio, this warning message showing every time but if I click okay and then click on fetch data then the data show perfectly. The problem is when I’m scheduling the test suite on test ops its giving error when it is trying to run on its scheduled time. The database connection is Okay, also i had put the postgres driver on the Library Management. How to solve this issue?

java.sql.SQLException: No suitable driver found for jdbc:postgresql://QTSUATPOST1:54205/forte?currentSchema=public
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:706)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)
at com.kms.katalon.core.db.DatabaseConnection.getConnection(DatabaseConnection.java:145)
at com.kms.katalon.core.db.DatabaseConnection.getConnection(DatabaseConnection.java:116)
at com.kms.katalon.composer.testdata.parts.DBTestDataPart$7.run(DBTestDataPart.java:305)
at org.eclipse.swt.widgets.Display.runTimer(Display.java:4152)
at org.eclipse.swt.widgets.Display.messageProc(Display.java:3272)
at org.eclipse.swt.internal.win32.OS.DispatchMessage(Native Method)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3640)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(ModalContext.java:166)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:368)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:470)
at com.kms.katalon.composer.testcase.parts.TestCaseCompositePart.setScriptContentToManual(TestCaseCompositePart.java:542)
at com.kms.katalon.composer.testcase.parts.TestCaseCompositePart.initComponent(TestCaseCompositePart.java:446)
at com.kms.katalon.composer.testcase.handlers.OpenTestCaseHandler.execute(OpenTestCaseHandler.java:271)
at com.kms.katalon.composer.testcase.handlers.OpenTestCaseHandler.openTestCase(OpenTestCaseHandler.java:111)
at com.kms.katalon.composer.testcase.handlers.OpenTestCaseHandler$1.handleEvent(OpenTestCaseHandler.java:98)
at org.eclipse.e4.ui.services.internal.events.UIEventHandler.lambda$0(UIEventHandler.java:38)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4029)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3645)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1155)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:643)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:550)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:171)
at com.kms.katalon.core.application.WorkbenchApplicationStarter.start(WorkbenchApplicationStarter.java:23)
at com.kms.katalon.application.Application.runGUI(Application.java:205)
at com.kms.katalon.application.Application.start(Application.java:112)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596)
at org.eclipse.equinox.launcher.Main.run(Main.java:1467)

image
image


1 Like

Hi there,

Thank you very much for your topic. Please note that it may take a little while before a member of our community or from Katalon team responds to you.

Thanks!

Hi,

I will ask my team and back to you soon

Hi,

Can you please help share Katalon version, OS, …? Thank you

Hi, Can I ask for your KS version, OS, steps to reproduce…?

1 Like

Hi, sorry for replying late.
KS version: 9.3.0
OS: Windows 10
Steps to reproduce: This error shows whenever I first open the project, and it tries to recover the previously opened Data Files folder.

Hi Elly, any update?

The JDBC driver should be set to “org.postgresql.Driver”

Let me know if the error still occurs after changing that.

2 Likes

Hi Philip, thanks for the solution. The error is not showing anymore.

1 Like