Re: [Exist-open] sql: java.sql.sqlexception: unsupported feature: getmetadata java for oracle ojdbc8

[Willem v. d. W. <wi...@kw...>]

Hi Dannes,

Thank you for responding. We upgraded from 3.3.3 to 6.2, and that is 
when the oracle connections gave us problems. We cannot seem to get the 
connection pool working, and we get the error in two cases:

1. When we do any statement other than select, it returns the error. We 
created a workaround, which traps the error when its not a select query, 
but the logs are cluttered with the error.

2026-03-16 15:31:33,156 [qtp942804532-2925] WARN (LogFunction.java 
[writeLog]:202) - (Line: 54 
/db/kwantu-resource/modules/notificationModule.xqm) $url 
"https://epwprs.dpw.gov.za/"
2026-03-16 15:31:33,252 [qtp942804532-2848] ERROR (ExecuteFunction.java 
[eval]:192) - sql:execute() Caught SQLException "Unsupported feature: 
getMetaData" for SQL: "UPDATE COL_XMLSOURCE SET UPDATEDDATETIME = 
TO_DATE(SYSDATE, 'yyyy/mm/dd'), MIGRATEDFLAG='Pending', PROCESSUUID = 
'3ef916eb-3114-4ffe-89c2-fb37fa5cb012', XML_FILENAME = 
'867b79cd-9b4b-4458-bb79-cd9b4b74587e.xml' WHERE COMPANYID='3' AND 
PROFILEID='152864' AND APPLICATIONID='EPWPRS' AND COMPONENTID=17 AND 
SEQ= 5.643704E6"
java.sql.SQLException: Unsupported feature: getMetaData
         at 
oracle.jdbc.driver.ArrayDataResultSet.getMetaData(ArrayDataResultSet.java:1080) 
~[ojdbc8.jar:19.24.0.0.0]
         at 
org.exist.xquery.modules.sql.ExecuteFunction.resultAsElement(ExecuteFunction.java:300) 
~[exist-sql-6.2.0.jar:6.2.0]
         at 
org.exist.xquery.modules.sql.ExecuteFunction.eval(ExecuteFunction.java:189) 
~[exist-sql-6.2.0.jar:6.2.0]
         at org.exist.xquery.BasicFunction.eval(BasicFunction.java:73) 
~[exist-core-6.2.0.jar:6.2.0]
         at 
org.exist.xquery.InternalFunctionCall.eval(InternalFunctionCall.java:62) 
~[exist-core-6.2.0.jar:6.2.0]
         at org.exist.xquery.LetExpr.eval(LetExpr.java:98) 
~[exist-core-6.2.0.jar:6.2.0]
         at 
org.exist.xquery.ConditionalExpression.eval(ConditionalExpression.java:98) 
~[exist-core-6.2.0.jar:6.2.0]
         at 
org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:71) 
~[exist-core-6.2.0.jar:6.2.0]
         at org.exist.xquery.PathExpr.eval(PathExpr.java:280) 
~[exist-core-6.2.0.jar:6.2.0]

2. Previously we used a stored procedure that we called, but that is now 
failing. We noted that there is an exist/oracle module which is disabled 
by default. But uncommenting this did not work. It will be very useful 
to get that active if possible. We are happy to contribute to someone 
updating it.

Regards

Willem

On 2026/03/13 21:58, Dannes Wessels wrote:
> Hi Willem,
>
>
>> Is there somewhere that we can find a way to resolve this problem 
>> with exist 6.
>>
>> existdb oracle sqlexception "unsupported feature: getmetadata" for 
>> sql: java.sql.sqlexception: unsupported feature: getmetadata java
>
>
> There are a few questions….
>
>   * Is there a stack trace in the log file?
>   * Can you share a part of the relevant query?
>   * Which SQL database are you using? Oracle… which version?
>
>
> regards
>
> Dannes
>
>