Yes your right. I had to change that, forgot to update the sample. The function does get invoked when I call it using squirrel and I see the ActiveOrgError.txt and it does not go beyond the get connection line. Did the jdbc:default:connection work for you or did you get any errors for that line? Thanks -Milind
> Date: Sun, 23 Mar 2008 22:00:32 +0530 > From: [EMAIL PROTECTED] > Subject: Re: jdbc:default:connection fails > To: [email protected] > > > > /* > > 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' > > > > > You have used the STRING datatype here, running the same command in gives me > > ERROR 42X01: Syntax error: Encountered "status" at line 1, column 31. > > changing String to VARCHAR(20) makes this definition work. > > Narayanan
