× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi all

I'm try to consume a web service with this statement:



SELECT *

FROM JSON_TABLE(

Systools.HTTPPOSTCLOB(

'https://wsurl/zzz/changexx',

'<httpHeader> <header name="content-type"
value="application/json" /> </httpHeader> ' ,




'{"user":"MYUSER","psw":"mypass":"123","order_id":"6","sts":"A","sub":"X"}')
,

'$'

COLUMNS(

"status" VARCHAR(30) PATH 'lax $.status' DEFAULT '' ON
EMPTY,

"err" VARCHAR(1024) PATH 'lax $.err' DEFAULT '' ON EMPTY

)

) AS x;



but i receive this error:



Message: [SQL4302] The Java stored procedure or user-defined function
SYSTOOLS.HTTPPOSTCLOB and the specific name HTTPP00013 aborted with an error
"com.ibm.jsse2.util.h: PKIX path building failed:
java.security.cert.CertPathBuilderException: PKIXCertPathBuilderImpl could
not build a valid CertPath.; internal cause is:

java.security.cert.CertPathValidatorException: The certificate expired at
Sat May 30 12:48:38 CEST 2020; internal cause is:

java.security.cert.CertificateExpiredException: NotAfter: Sat May 30
12:48:38 CEST 2020". It causes . . . : The Java stored procedure or
user-defined function was aborted with a Java exception. If the SQJAVA
component trace is active, the component trace for the job contains a Java
stack for the interrupted method. Correction. . : Debug the Java method to
eliminate the error.



I'm running V/R2



Which could be the problem ?



Thanks in advance


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.