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.