*** Failure 7980 A JAVA method in the specified Jar which matches that in t
he EXTERNAL NAME clause was not found/etc/opt/teradata/tdconfig/jarlib/tdbs_1
Statement# 1, Info =0
*** Total elapsed time was 2 seconds.
Looks like its referring to the different path . can you suggest on how to resolve this?
It's hard to diagnose your problem without seeing all the pieces, including the Java source code for the Java stored procedure.
My initial reaction is that this line looks incorrect: EXTERNAL NAME 'jar1:test.Main.class.myjxsp1';
I would not expect to see .class in that literal, because the syntax is 'JarName:PackageName.ClassName.MethodName' (and note that PackageName can contain dots itself).
You might want to try removing the .class to like this: EXTERNAL NAME 'jar1:test.Main.myjxsp1';