Re: [Geoserver-users] H2 datastore configuration

[carlo c. <car...@ge...>]

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 <car...@ge...>

> 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 <jde...@op...>
>
>> 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 <
>> car...@ge...> 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
>>> Geo...@li...
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>
>
>
> --
> ==
> 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
>
> -------------------------------------------------------
>



-- 
==
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

-------------------------------------------------------