db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Enyedi <robert.eny...@intland.com>
Subject Integer return type for Java functions
Date Wed, 30 Aug 2006 14:57:57 GMT
Hi,

According to this post 
http://mail-archives.apache.org/mod_mbox/db-derby-user/200602.mbox/%3c4404E53D.1050605@apache.org%3e

I can explicitly state the parameter bindings of a Java function. Can 
something similar be done for the return type too?

For example this statement

CREATE FUNCTION F1(FIRSTINT INTEGER, SECONDINT INTEGER) RETURNS INTEGER
 PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA
 EXTERNAL NAME 
'utils.CompatibilityFunctions.f1(java.lang.Integer,java.lang.Integer)';

expects that the return type of the utils.CompatibilityFunctions.f1 
method is "int" and _not_ "java.lang.Integer". But this way I cannot 
return a NULL value. Is there a workaround for this?

Regards,
Robert

Mime
View raw message