[h2] H2 database how to use external library like apache.commons

2017-01-06 Thread BB23850
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

Re: [h2] MySQL mode

2017-01-06 Thread Noel Grandin
yeah, just move it to the main directory​ is prob the easiest -- 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 h2-database+unsubscr...@googlegroups.com. To post

Re: [h2] MySQL mode

2017-01-06 Thread dmcnamara
Thanks for the responses! Do you think it is worthwhile to open a PR to either: compile a separate tools jar as part of the build or move the FunctionsMySQL.java file to the src/main directory, or a different solution? On Friday, January 6, 2017 at 4:25:34 AM UTC-5, Thomas Mueller Graf

Re: [h2] Re: Index hints

2017-01-06 Thread Steve McLeod
Pull request submitted. Surprisingly, while doing this I discovered we already accept Sybase's format for index hints, although the hints are ignored: // Sybase compatibility with // "select * from test (index table1_index)" On Thursday, 5 January 2017 10:30:03 UTC+1, Thomas Mueller Graf

Re: [h2] MySQL mode

2017-01-06 Thread Thomas Mueller Graf
Hi, Actually, it is in the src/tools directory of H2. It was an attempt to modularize the code. It was probably not a good idea. It is not included in the H2 jar file, so you would need to manually add it to the classpath or possibly your code. Regards, Thomas On Fri, Jan 6, 2017 at 7:18 AM,