[Geoserver-users] H2 datastore configuration

GeoServer GeoServer User
1

Hi,
I’m having some problem configuring the an H2 datastore.
I’ve translated a working postgis table into an h2 table using geotools and I’m able to query that table via h2 web interface.
Now, I’d like to configure a store pointing to that DB but I’m not able to get it working.
I tried to setup the datastore as database embedded:
database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host =
port =

with no success:
I get a popup saying Could not acquire data access ‘sdw_h2’ but no error is given into logs using VERBOSE_LOGGING.properties.

I’v also tried to point my h2 database via tcp:

  1. started an h2 instance on the same VM using the port 9902 and configured with the below DB using the web gui:
    jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore

  2. configured a store as following

database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host = localhost
port = 9902

I’ve also tried setting database = /data/geoData/tech-cdr/TEMP/sdw_datastore with no success.

It’s not so clear how to proceed to debug this and which is the best way to configure it. Have you ever configured an existing DB as H2 store? if so, in which way?

Thank you,
Carlo

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

2

Hey Carlo,

Yeah, this one was reported by another user about a week ago. Basically if the host parameter is set the connection will attempt a tcp connection rather than an embedded one. It is an issue with the H2JDBCDataStoreFactory. We should probably had an explicit flag to it.

Anyways, workaround is to simply clear out the host parameter.

-Justin

···

On Thu, May 2, 2013 at 9:57 AM, carlo cancellieri <carlo.cancellieri@anonymised.com> wrote:

Hi,
I’m having some problem configuring the an H2 datastore.
I’ve translated a working postgis table into an h2 table using geotools and I’m able to query that table via h2 web interface.
Now, I’d like to configure a store pointing to that DB but I’m not able to get it working.
I tried to setup the datastore as database embedded:
database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host =
port =

with no success:
I get a popup saying Could not acquire data access ‘sdw_h2’ but no error is given into logs using VERBOSE_LOGGING.properties.

I’v also tried to point my h2 database via tcp:

  1. started an h2 instance on the same VM using the port 9902 and configured with the below DB using the web gui:
    jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore

  2. configured a store as following

database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host = localhost
port = 9902

I’ve also tried setting database = /data/geoData/tech-cdr/TEMP/sdw_datastore with no success.

It’s not so clear how to proceed to debug this and which is the best way to configure it. Have you ever configured an existing DB as H2 store? if so, in which way?

Thank you,
Carlo

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

3

Ciao Justin,
Yes, I have read that mail but the problem seems that I can’t get it working at all (also removing the host parameter).
This is why I’m asking if you ever get it working on an existing database (mine is about 1 Gb).
Which is the correct string I have to use? may I have to exclude the jdbc:h2 part? do you have a working datastore configuration?
NOTES: I’m working on GeoServer 2.2.x.

Thank you for any details.
Cheers,
Carlo

···

2013/5/2 Justin Deoliveira <jdeolive@anonymised.com>

Hey Carlo,

Yeah, this one was reported by another user about a week ago. Basically if the host parameter is set the connection will attempt a tcp connection rather than an embedded one. It is an issue with the H2JDBCDataStoreFactory. We should probably had an explicit flag to it.

Anyways, workaround is to simply clear out the host parameter.

-Justin

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

On Thu, May 2, 2013 at 9:57 AM, carlo cancellieri <carlo.cancellieri@anonymised.com> wrote:

Hi,
I’m having some problem configuring the an H2 datastore.
I’ve translated a working postgis table into an h2 table using geotools and I’m able to query that table via h2 web interface.
Now, I’d like to configure a store pointing to that DB but I’m not able to get it working.
I tried to setup the datastore as database embedded:
database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host =
port =

with no success:
I get a popup saying Could not acquire data access ‘sdw_h2’ but no error is given into logs using VERBOSE_LOGGING.properties.

I’v also tried to point my h2 database via tcp:

  1. started an h2 instance on the same VM using the port 9902 and configured with the below DB using the web gui:
    jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore

  2. configured a store as following

database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host = localhost
port = 9902

I’ve also tried setting database = /data/geoData/tech-cdr/TEMP/sdw_datastore with no success.

It’s not so clear how to proceed to debug this and which is the best way to configure it. Have you ever configured an existing DB as H2 store? if so, in which way?

Thank you,
Carlo

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

4

Ok i reproduced it locally and found the problem, it was due to an incompatibility within h2 versions:

https://groups.google.com/forum/?fromgroups=#!topic/h2-database/FhKHtE0R7BY

I have to use an updated version of h2 (with 1.3.171 it works).
Thank you,
Carlo

···

2013/5/2 carlo cancellieri <carlo.cancellieri@anonymised.com>

Ciao Justin,
Yes, I have read that mail but the problem seems that I can’t get it working at all (also removing the host parameter).
This is why I’m asking if you ever get it working on an existing database (mine is about 1 Gb).
Which is the correct string I have to use? may I have to exclude the jdbc:h2 part? do you have a working datastore configuration?
NOTES: I’m working on GeoServer 2.2.x.

Thank you for any details.
Cheers,
Carlo

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

2013/5/2 Justin Deoliveira <jdeolive@anonymised.com1…>

Hey Carlo,

Yeah, this one was reported by another user about a week ago. Basically if the host parameter is set the connection will attempt a tcp connection rather than an embedded one. It is an issue with the H2JDBCDataStoreFactory. We should probably had an explicit flag to it.

Anyways, workaround is to simply clear out the host parameter.

-Justin

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

On Thu, May 2, 2013 at 9:57 AM, carlo cancellieri <carlo.cancellieri@anonymised.com> wrote:

Hi,
I’m having some problem configuring the an H2 datastore.
I’ve translated a working postgis table into an h2 table using geotools and I’m able to query that table via h2 web interface.
Now, I’d like to configure a store pointing to that DB but I’m not able to get it working.
I tried to setup the datastore as database embedded:
database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host =
port =

with no success:
I get a popup saying Could not acquire data access ‘sdw_h2’ but no error is given into logs using VERBOSE_LOGGING.properties.

I’v also tried to point my h2 database via tcp:

  1. started an h2 instance on the same VM using the port 9902 and configured with the below DB using the web gui:
    jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore

  2. configured a store as following

database = jdbc:h2//data/geoData/tech-cdr/TEMP/sdw_datastore
host = localhost
port = 9902

I’ve also tried setting database = /data/geoData/tech-cdr/TEMP/sdw_datastore with no success.

It’s not so clear how to proceed to debug this and which is the best way to configure it. Have you ever configured an existing DB as H2 store? if so, in which way?

Thank you,
Carlo

–

==
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.