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