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;
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';
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.