Document Type | Troubleshooting
Category | Interface/Integration
Applicable Product Version | 6FS07
Document Number | TIITS005
Issue
When performing JAVA External Procedure with the same scenario, normal results were output in Tibero 6 FS07 CS2005 binary, but an error TBR-150008 occurred when performing JAVA External Procedure in Tibero 7 PatchSet binary. This document examines the operational differences between Tibero 6 FS07 CS2005 and Tibero 7 PatchSet binary versions.
NotePlease refer to the Tibero 7 online manual Java External Procedure section and proceed in the same manner.
Tibero 7 PatchSet Binary
SQL> CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "JavaExtproc" AS
package com.tmax;
public class SimpleMath {
public static int findMax(int x, int y) {
if (x >= y) return x;
else return y;
}
}
/
Java Source 'JavaExtproc' created.
SQL> CREATE OR REPLACE FUNCTION find_max(x PLS_INTEGER, y PLS_INTEGER)
RETURN PLS_INTEGER IS
LANGUAGE JAVA NAME 'SimpleMath.findMax(int, int) return int';
/
Function 'FIND_MAX' created.
SQL> select find_max(4,60) from dual;
TBR-150008:Invalid class name. - SimpleMath
Tibero 6 FS07_CS_2005 (build 202719) Binary
SQL> CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "JavaExtproc" AS
public class SimpleMath {
public static int findMax(int x, int y) {
if (x >= y) return x;
else return y;
}
}
/
Java Source 'JavaExtproc' created.
SQL> CREATE OR REPLACE FUNCTION find_max(x PLS_INTEGER, y PLS_INTEGER)
RETURN PLS_INTEGER IS
LANGUAGE JAVA NAME 'SimpleMath.findMax(int, int) return int';
/
Function 'FIND_MAX' created.
SQL> select find_max(4,60) from dual;
FIND_MAX(4,60)
60
1 row selected.
Cause
- In the case of Tibero 6 FS07_CS2005 binary, when performing drop or replace java source DDL, an error occurs because JEPA cannot handle the refresh message format error. Since the cached java source was used, there is a phenomenon where it executes normally without specifying the class path, so a patch is required.
- The operation of Tibero 7 PatchSet is normal. When JAVA_CLASS_PATH is set, a directory is created under the JAVA_CLASS_PATH path with the DB USER schema name by default. (Path: JAVA_CLASS_PATH / Schema Name / Class Name)
Solutions
Apply the patch to resolve the issue. (Applied patch: FS07_223058c )
CautionApply the patch through technical support provided by Tmax Tibero.