AFAIK you can only create aliases for static methods. You would have to create static method that instantiates StandardDeviation, invokes the method and return the result. Then you would create an alias for this static method.
Cheers Philippe On Friday, January 6, 2017 at 8:03:55 PM UTC+1, BB23850 wrote: > > I was trying to use H2 Database. I want to call methods in Apache Commons > Library i.e. commons-maths3.jar. I created variable > CLASSPATH=d:\H2\commons-maths3.3.6.1.jar and reloaded through H2.bat. > > > But when accessing the library method with the following: > > CREATE ALIAS sd for > "org.apache.commons.math3.stat.descriptive.moment.StandardDeviation"; > > > I am getting 90086 error. > > Class "org.apache.commons.math3.stat.descriptive.moment" not found; SQL > statement: create alias sd for > "org.apache.commons.math3.stat.descriptive.moment.StandardDeviation" > [90086-193] 90086/90086 > > Also, please suggest me how to know that a library is accessible to H2 > something like DESCRIBE StandardDeviation. > > I hope if this method succeeds then I should be able to use other library > like Lucene, ActiveMQ or Kafka etc. > > Thanks and regards > > BB23850 > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
