5602 Error creating UDF/XSP/UDM/UDT/JAR: problem accessing the external file %VSTR

Problem:
DATABASE test;
CALL SQLJ.INSTALL_JAR('SJ?/tmp/gdpr/gdpr.jar', 'Encrypt_JAR', 0);
Failed [5602 : HY000] Error creating UDF/XSP/UDM/UDT/JAR: problem accessing the external fileĀ  '/tmp/gdpr/gdpr.jar '.

Solution:
Check the permission for the jar file and provide read permission.

SMP001-01:/tmp # ls -lrt gdpr
-rw-r----- 1 ec2-user users 1751 Dec 28 08:37 gdpr.jar
SMP001-01:/tmp # chmod 775 -R gdpr
SMP001-01:/tmp # ls -lrt gdpr
-rwxrwxr-x 1 ec2-user users 1751 Dec 28 08:37 gdpr.jar

Comments