Hi Philippe, Thanks for your post. I suspected that but who would write those methods without STATIC. I switched to CERN COLT library which has pretty much all the statistical functions and they are STATIC. No need to instantiate the classes. I am done writing lengthy Java code, I want it non-procedural SQL Style.
Here is an example how I wrote HarmonicMean function from Cern Colt Library: create alias harmonicmean for "cern.jet.stat.Descriptive.harmonicMean"; select harmonicmean(100, 1000); PUBLIC.HARMONICMEAN(100, 1000) 0.1 (1 row, 0 ms) This library may not be as elaborate as Apache Commons but serves my purpose. thanks and regards BB23850 -- View this message in context: http://h2-database.66688.n3.nabble.com/H2-database-how-to-use-external-library-like-apache-commons-tp4033845p4033847.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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.
