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 <[email protected]>
> 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 <
> [email protected]> 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
>> [email protected]
>> 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
-------------------------------------------------------
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
