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 V7R2
Which could be the problem ?
Thanks in advance
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 V7R2
Which could be the problem ?
Thanks in advance
Comment