[h2] unable to initialize spatial function

I just downloaded h2gis for the first time and try to initialize spatial function using this syntax: CREATE ALIAS IF NOT EXISTS H2GIS_EXTENSION FOR "org.h2gis.ext.H2GISExtension.load"; CALL H2GIS_EXTENSION(); but it didnt work. These are the error messages I got: CREATE ALIAS IF NOT EXISTS

[h2] Can't initialize the spatial function.

Hi, I try to run the h2 console for the first time and try to run these command: CREATE ALIAS IF NOT EXISTS H2GIS_EXTENSION FOR "org.h2gis.ext.H2GISExtension.load"; CALL H2GIS_EXTENSION(); as specified in the quick start guide. however, it says: CREATE ALIAS IF NOT EXISTS SPATIAL_INIT FOR

Re: [h2] Concurrent update error in append only table

in the short term, don't violate the constraint? in the longer term, if you could make us a standalone test case, I could look at throwing a more useful exception On 17 May 2017 at 15:23, Marco Willemart wrote: > I understand, so what can be done? > > -- > You

[h2] H2 database connect to the wrong IP address

Hello, When I start the H2 console, it always connect ot the wrong IP address. It use the ip of my virtualBox host-only network, but not the ip of my local network. But when I use the localhost:8082, it can connect. Is somme one has the idea how H2 detect the IP address? Thanks, Sally --

Re: [h2] Split DB based on Date

We have only around 4 tables and dont have foreign key references between them, so deleting older db is not a problem. Let me know if there is still a option to split date wise. Also thought about the other solution you provided ( Creating daily db ), but we have a UI where a date range based

[h2] Any negative effects of a large varchar type?

I have this table with a varchar of size 10K create table doc( id BIGINT, name VARCHAR(50), body VARCHAR(1) ); More often than not, the table will only store small values (less than 200 characters) in the "body" column. However, I want it to be big just in case. My

[h2] Re: Does data file splitting increase performance?

Unfortunately I didn't get any answer although one week has passed. is this a stupid question? Or what? Please, any hint. пятница, 12 мая 2017 г., 13:39:15 UTC+3 пользователь iJava написал: > > Hi all > > > As I understand by default H2 stores all data in one file. However, if I > get more and

Re: [h2] Split DB based on Date

Thats awesome..Thanks guys.. -Naren On Thursday, May 18, 2017 at 5:14:10 PM UTC-4, Rami Ojares wrote: > > Well let me try. > Learn to think for yourself. > It can take you far. > It took us to the moon. > > - Rami > > On 18-May-17 23:36, Kerry Sainsbury wrote: > > Sorry, I can't help further. >

Re: [h2] Split DB based on Date

Well let me try. Learn to think for yourself. It can take you far. It took us to the moon. - Rami On 18-May-17 23:36, Kerry Sainsbury wrote: Sorry, I can't help further. On 19 May 2017 at 03:58, Narendran Balasubramaniam > wrote: We

Re: [h2] Split DB based on Date

Sorry, I can't help further. On 19 May 2017 at 03:58, Narendran Balasubramaniam wrote: > We have only around 4 tables and dont have foreign key references between > them, so deleting older db is not a problem. Let me know if there is still > a option to split date wise. > >