Erik Anderson
2004-02-07 01:29:24 UTC
I am attempting to convert our database structures to use the new EXTERNAL
LANGUAGE JAVA call methodology, instead of just calling the java objects
directly. Server machine is ASA 8.0.2.4322.
(1): I have successfully converted two java functions so far, but they both
immediately throw exceptions when they are called. I'm hoping this issue
can be answered here before I start creating java test objects to try to
isolate this issue.
For instance, the command:
select
com.teamwork.analysis.ResourceTargetSpread.staticGetDefaultTarget('SCHD')
will return -1, but the following command:
GRANT CONNECT TO java;
CREATE FUNCTION java.getDefaultTarget(in WorkSet varchar(4)) RETURNS
integer
EXTERNAL NAME
'com.teamwork.analysis.ResourceTargetSpread.staticGetDefaultTarget
(Ljava/lang/String;)I'
LANGUAGE JAVA;
select java.getDefaultTarget('SCHD')
will throw an SQLException. This exact same symptom has also occurred with
the only other signature I've gotten to work so far.
(2) What signature do I use for 'final' ? For instance, the java signature:
public static float staticFindPTTM(final String WorkSet, final String
whereClause, final Timestamp toDate)
throws SQLException
does NOT convert to
(Ljava/lang/String;Ljava/lang/String;Ljava/sql/Timestamp)I
and i think it might be the 'final' stuff messing things up.
LANGUAGE JAVA call methodology, instead of just calling the java objects
directly. Server machine is ASA 8.0.2.4322.
(1): I have successfully converted two java functions so far, but they both
immediately throw exceptions when they are called. I'm hoping this issue
can be answered here before I start creating java test objects to try to
isolate this issue.
For instance, the command:
select
com.teamwork.analysis.ResourceTargetSpread.staticGetDefaultTarget('SCHD')
will return -1, but the following command:
GRANT CONNECT TO java;
CREATE FUNCTION java.getDefaultTarget(in WorkSet varchar(4)) RETURNS
integer
EXTERNAL NAME
'com.teamwork.analysis.ResourceTargetSpread.staticGetDefaultTarget
(Ljava/lang/String;)I'
LANGUAGE JAVA;
select java.getDefaultTarget('SCHD')
will throw an SQLException. This exact same symptom has also occurred with
the only other signature I've gotten to work so far.
(2) What signature do I use for 'final' ? For instance, the java signature:
public static float staticFindPTTM(final String WorkSet, final String
whereClause, final Timestamp toDate)
throws SQLException
does NOT convert to
(Ljava/lang/String;Ljava/lang/String;Ljava/sql/Timestamp)I
and i think it might be the 'final' stuff messing things up.