Proper syntax for passing double array to java language procedure

Jorge Garcia de Alba <[email protected]> Wed, 4 Aug 2021 20:36:29 -0500
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <CAEVgvV-SO7NtNS-P27opPuFByNXUrNUDuQDcA_mjU3Ykh56sCw@mail.gmail.com>
Hello,

I am trying to create the java language procedure below but I keep
getting an error and I think it is because I am not using proper
syntax. How would you declare double array in java language procedure
signature?

-----This is example sort method is in my LPModel class-----

public static void sort(double[] a) {
        Arrays.sort(a);
        //Other stuff
    }

-----This the java language procedure I am trying to create-----

CREATE PROCEDURE sort(a DOUBLE ARRAY?)
NO SQL
LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL NAME 'CLASSPATH:io.github.xjrga.linearprogram.LPModel.sort';

-----

An error occurred when executing the SQL command:
CREATE PROCEDURE  sort(a DOUBLE)
 NO SQL
LANGUAGE JAVA PARAMETER STYLE JAVA
 EXTERNAL NAME 'CLASSPATH:io.github.xjrga.linearprogram.LPModel.sort';

Java execution: unresolved class name, method name or signature [SQL
State=46103, DB Errorcode=-6013]
1 statement failed.