Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

SQL: Stored Procedure DATE variable is initialized using deprecated constructor.

Stored Procedure DATE variable is initialized using a deprecated constructor in the statement:
Calendar cal = new GregorianCalendar(1997, 2, 10);

The Stored Procedure DATE variable is initialized using a deprecated constructor if the java code of the Stored Procedure has a syntax error. For example:
CREATE PROCEDURE getDate(
IN abcd CHAR(100),
OUT fotosetDate DATE)
IMPORT
import java.util.*;
import java.sql.*;
BEGIN
STRING a = NEW STRING b;
abcd = new String();
Calendar cal = new GregorianCalendar(1997, 2, 10);
fotosetDate = new java.sql.Date(cal.getTime().getTime());
END;
COMMIT WORK;

The above Stored Procedure has the intentional syntax error in the statement:
STRING a = NEW STRING b;

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.x
All Supported Operating Systems
OpenEdge 10.0B

CAUSE:

Bug# OE00124355

FIX:

None at this time. A work around is to ensure that the java code of the Stored Procedure is syntax error free.