KS 10.3.1 - DBMS Keywords don't work anymore - missing orai18n.jar

Bug Report
, , ,
1

Hello,
could you please help me with this issue that showed up after the last update to Katalon Studio 10.3.1?

*Summary
We’ve been using DBMS Keywords (Katalon Store: DBMS Keywords ) for 4 years. After the last update to Katalon Studio 10.3.1 DBMS Keywords stoped working because of the error bellow.

Everything was fine in Katalon Studio 10.3.0.

WE use DB Oracle.

I read in the release note for 10.3.1 that one of the Enhancements was:
”Updated all JDBC libraries to the latest supported versions.” - maybe there is a connection to my issue

We have so many Katalon projects so before I add orai18n.jar to all of them, I would like to know if there is any other solution or if it’s just temporariy temporary bug.

*Actual Results
Caused by: java.sql.SQLException: Unsupported character set (add orai18n.jar to your classpath): EE8ISO8859P2

2025-08-20 16:30:06.048 INFO  c.k.katalon.core.main.TestCaseExecutor   - --------------------
2025-08-20 16:30:06.048 INFO  c.k.katalon.core.main.TestCaseExecutor   - START Test Cases/SMOKE/S_GPK-115_Campaigns
2025-08-20 16:30:06.394 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) ccdId = default
2025-08-20 16:30:06.395 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) campaignName = default
2025-08-20 16:30:06.429 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) partnerType = defaut
2025-08-20 16:30:06.430 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) birthNo = default
2025-08-20 16:30:06.432 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) firstName = default
2025-08-20 16:30:06.433 INFO  c.k.katalon.core.main.TestCaseExecutor   - (Default) surname = default
2025-08-20 16:30:07.844 INFO  k.k.c.m.CustomKeywordDelegatingMetaClass - cz.cpas.katalon.helpers.HighlightElement.pandemic is PASSED
2025-08-20 16:30:07.906 INFO  com.kms.katalon.core.util.KeywordUtil    - Microsoft Teams Incoming Webhook is empty.
2025-08-20 16:30:08.213 DEBUG testcase.S_GPK-115_Campaigns             - 1: connectionKCL = com.katalon.plugin.keyword.connection.DatabaseKeywords.createConnection(oracle, G_kclDbServer, G_kclDbPort, G_KclDbName, G_kclDbUser, G_kclDbPassword)
2025-08-20 16:30:09.444 INFO  k.k.c.m.CustomKeywordDelegatingMetaClass - com.katalon.plugin.keyword.connection.DatabaseKeywords.createConnection is PASSED
2025-08-20 16:30:09.453 DEBUG testcase.S_GPK-115_Campaigns             - 2: resultSet = com.katalon.plugin.keyword.connection.DatabaseKeywords.executeQuery(connectionKCL, "SELECT a.CCD_ID as CCDID, upper(c.CAMPAIGN_NAME) as CAMPAIGNNAME FROM kcl2.BDT_ADD_MAT a, kcl2.VW_BDT_CAMPAIGN_WAVE c WHERE a.CAMPAIGN_WAVE_ID = c.ID AND c.CAMPAIGN_STATE_ID = 2 AND a.ccd_id IS NOT NULL AND a.FIRST_NAME is NOT NULL AND a.SURNAME is NOT NULL AND a.COMPANY_NAME is NULL AND rownum < 2")
2025-08-20 16:30:09.972 INFO  k.k.c.m.CustomKeywordDelegatingMetaClass - com.katalon.plugin.keyword.connection.DatabaseKeywords.executeQuery is PASSED
2025-08-20 16:30:09.974 DEBUG testcase.S_GPK-115_Campaigns             - 3: ccdId = com.katalon.plugin.keyword.connection.ResultSetKeywords.getSingleCellValue(resultSet, 1, "ccdId")
2025-08-20 16:30:10.056 ERROR k.k.c.m.CustomKeywordDelegatingMetaClass - ❌ java.sql.SQLException: Nepodporovaná znaková sada (přidejte orai18n.jar ke své cestě třídy): EE8ISO8859P2
2025-08-20 16:30:10.060 ERROR c.k.katalon.core.main.TestCaseExecutor   - ❌ Test Cases/SMOKE/S_GPK-115_Campaigns FAILED.
Reason:
com.kms.katalon.core.exception.StepErrorException: org.codehaus.groovy.runtime.InvokerInvocationException: java.sql.SQLException: Nepodporovaná znaková sada (přidejte orai18n.jar ke své cestě třídy): EE8ISO8859P2
	at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.throwError(CustomKeywordDelegatingMetaClass.java:101)
	at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.invokeStaticMethod(CustomKeywordDelegatingMetaClass.java:73)
	at S_GPK-115_Campaigns.run(S_GPK-115_Campaigns:33)
	at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)
	at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)
	at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:486)
	at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:477)
	at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:456)
	at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:448)
	at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:322)
	at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:151)
	at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:139)
	at TempTestCase1755700195669.run(TempTestCase1755700195669.groovy:25)
	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)
Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: java.sql.SQLException: Nepodporovaná znaková sada (přidejte orai18n.jar ke své cestě třídy): EE8ISO8859P2
	at com.katalon.plugin.keyword.connection.ResultSetKeywords.invokeMethod(ResultSetKeywords.groovy)
	at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.invokeStaticMethod(CustomKeywordDelegatingMetaClass.java:55)
	at Script1648535298200.run(Script1648535298200.groovy:33)

*Blocker?
Yes

Number of affected users?
10

*Operating System
Windows 11

*Katalon Studio version
Katalon Studio 10.3.1

Environment (for Web Testing)
Chrome 139.0.7258.139

Thank you so much
Petr

1 Like
2

Manually add the orai18n.jar file to your Katalon Studio project’s classpath

  1. Download the orai18n.jar file that matches your Oracle JDBC driver version

  2. Add it to your Katalon Studio project’s Drivers folder

  3. Restart Katalon Studio to ensure the library is loaded properly

3

Hello,

thank you for your reply. I know how to fix it though.

My questions was more about whether it was intentional or a mistake, because it’s been working for several years and suddenly it stopped working.

Maybe Katalon will add it back in the new update, because this plugin DBMS keywords is used by many people.

Petr

4

Intentional, but resulted an error unfortunately.

In the Katalon Studio Release Notes: Version 10.x | Katalon Docs, v10.3.1 includes

  • Updated all JDBC libraries to the latest supported versions.

On my machine, I have a Katalon project generated by Katalon Studio v10.3.0. It has a file .classpath. In that file I found a line

        pathentry kind="lib" path="/Applications/Katalon Studio.app/Contents/Eclipse/plugins/com.oracle.jdbc.ojdbc7_12.1.0.2.jar"/>

This means, Katalon Studio v10.3.0 (and the older versions) bundles com.oracle.jdbc.ojdbc7_12.1.0.2.jar.

You can find when this jar was released:

https://mvnrepository.com/artifact/com.oracle/ojdbc7/12.1.0.2

Oct 30, 2017

Well, it is pretty old.

The following Stackoverflow discussion looks similar to your issue.

I suppose, Katalon developers in US and Vietnam would never test the availability of the characterset EE8ISO8859P2 for Czech.

@petr.brezina

Please raise an official support request to Katalon if you are a paying customer.

I am afraid, Katalon developer would not notice your “advice” in this post in the customer forum.

c/c @Elly_Tran

1 Like
5

Hi,

In KS v10.3.1, we updated Oracle JDBC driver from ojdbc7 v12.1.0.2 to ojdbc11 v21.18.0.0.

ojdbc7contains all necessary support for globalization: Globalization Support, while newer Oracle JDBC versions do not. Oracle separated JDBC support to multiple jars and calls them companion jars : JDBC and UCP Downloads page

For your case, adding orai18n.jar may be a temporary solution for now.

2 Likes