Re: sql: java.sql.sqlexception: unsupported feature: getmetadata java for oracle ojdbc8
Willem van der Westhuizen <[email protected]> Mon, 16 Mar 2026 15:37:11 +0200
| Newsgroups | gmane.text.xml.exist |
|---|---|
| Organization | Kwantu Infomrmation Technology |
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============7248571339907750600==
Content-Type: multipart/alternative;
boundary="------------BGpcoCLY8hM26A7BuHPrQA8A"
Content-Language: en-US
This is a multi-part message in MIME format.
--------------BGpcoCLY8hM26A7BuHPrQA8A
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
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
>
>
--------------BGpcoCLY8hM26A7BuHPrQA8A
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Dannes,</p>
<p>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:</p>
<p>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.</p>
<p>2026-03-16 15:31:33,156 [qtp942804532-2925] WARN
(LogFunction.java [writeLog]:202) - (Line: 54
/db/kwantu-resource/modules/notificationModule.xqm) $url
<a class="moz-txt-link-rfc2396E" href="https://epwprs.dpw.gov.za/">"https://epwprs.dpw.gov.za/"</a><br>
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"<br>
java.sql.SQLException: Unsupported feature: getMetaData<br>
at
oracle.jdbc.driver.ArrayDataResultSet.getMetaData(ArrayDataResultSet.java:1080)
~[ojdbc8.jar:19.24.0.0.0]<br>
at
org.exist.xquery.modules.sql.ExecuteFunction.resultAsElement(ExecuteFunction.java:300)
~[exist-sql-6.2.0.jar:6.2.0]<br>
at
org.exist.xquery.modules.sql.ExecuteFunction.eval(ExecuteFunction.java:189)
~[exist-sql-6.2.0.jar:6.2.0]<br>
at
org.exist.xquery.BasicFunction.eval(BasicFunction.java:73)
~[exist-core-6.2.0.jar:6.2.0]<br>
at
org.exist.xquery.InternalFunctionCall.eval(InternalFunctionCall.java:62)
~[exist-core-6.2.0.jar:6.2.0]<br>
at org.exist.xquery.LetExpr.eval(LetExpr.java:98)
~[exist-core-6.2.0.jar:6.2.0]<br>
at
org.exist.xquery.ConditionalExpression.eval(ConditionalExpression.java:98)
~[exist-core-6.2.0.jar:6.2.0]<br>
at
org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:71)
~[exist-core-6.2.0.jar:6.2.0]<br>
at org.exist.xquery.PathExpr.eval(PathExpr.java:280)
~[exist-core-6.2.0.jar:6.2.0]<br>
<br>
</p>
<p>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.</p>
<p>Regards</p>
<p>Willem<br>
</p>
<div class="moz-cite-prefix">On 2026/03/13 21:58, Dannes Wessels
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:[email protected]">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi Willem,
<div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>
<blockquote type="cite">
<div>
<div>Is there somewhere that we can find a way to
resolve this problem with exist 6.<br>
<br>
existdb oracle sqlexception "unsupported feature:
getmetadata" for sql: java.sql.sqlexception:
unsupported feature: getmetadata java<br>
</div>
</div>
</blockquote>
<br>
</div>
<div><br>
</div>
<div>
<div>There are a few questions….</div>
<div><br>
</div>
<div>
<ul class="MailOutline">
<li>Is there a stack trace in the log file?</li>
<li>Can you share a part of the relevant query?</li>
<li>Which SQL database are you using? Oracle… which
version?</li>
</ul>
<div><br>
</div>
</div>
<div>regards</div>
<div><br>
</div>
<div>Dannes</div>
<div><br>
</div>
</div>
<br>
</div>
</div>
</blockquote>
</body>
</html>
--------------BGpcoCLY8hM26A7BuHPrQA8A--
--===============7248571339907750600==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============7248571339907750600==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Exist-open mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/exist-open
--===============7248571339907750600==--