hi, I have written a java function as below. I am testing it using squirrel sql client and embedded derby. The function is being invoked but jdbc:default:connection returns null. I have tried both adding and removing the Class.forName line with not much difference. My errorlog file shows me a java.lang.NullPointerException and my execution log has not gone beyond step 1 (that is it fails at getconnection). Can someone pelase help. Cheers -Milind
/* Declared as follows: CREATE FUNCTION GetActiveOrg (status STRING) RETURNS VARCHAR(255) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA EXTERNAL NAME 'com.mymunshi.derbyfunctions.ActiveOrg.GetActiveOrg'
Invoked as follows VALUES getactiveorg('Active') */