JUDF and 5600 Error creating UDF/XSP/UDM/UDT: no compiler available.

Extensibility
Enthusiast

JUDF and 5600 Error creating UDF/XSP/UDM/UDT: no compiler available.

Hello,

I'm using two different types of Java :

C:\Program Files\Teradata\jvm\jre5_32\
C:\Program Files\Java\jre6

which I can switch in : Teradata Service Manager -> Update TDJRE ( so Register value on JRE is changed )

I'm also using plugin for eclipse and Teradata Express v13.00.00.12 / Windows 32 bit

I'm able to:

- connect to database,
- create user
- create schema
- in teradata command pompt I can see path to java.
- I have all grants to create JUDFs ( inc. ALTR EXTERNAL PROCEDURE )
- I have SQLJ schema with INSTALL procedure
- Java is set to 1.5

but I can't deploy jar file ( error 5600 )

When I use ANT to create jar file and BTEQ script for import:

.logon 127.0.0.1/JUDF,XXXX;
diagnostic JAVALANGUAGE on for session;
diagnostic JAVA32 on for session;
diagnostic javalogging on for session;

CALL SQLJ.INSTALL_JAR('cj!C:\javaudf\SomeClassJarFile.jar', 'SomeClassJarId', 0);

REPLACE FUNCTION "TEST"."someMetoda" (
"varchar1" VARCHAR(255))
RETURNS VARCHAR(255)
SPECIFIC "someMetoda"
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
DETERMINISTIC
CALLED ON NULL INPUT
EXTERNAL NAME 'SomeClassJarId:somePackage.SomeKlasa.someMetoda(java.lang.String) returns java.lang.String';

I still get the same error code.

Any ideas why I need compiler for compiled jar?

Thanks.