[Geoserver-users] Problems creating a new H2 datastore (v 2.3.1)

GeoServer GeoServer User
1

Hi,
I’m trying to figure out how to create a new H2 datastore to store from vectors to be served out through WFS.
I’ve gone to Add New Store (H2 Embedded)
I put in a Data Source Name, however, I’m not sure what to put in for any of the connection parameters. I always receive this error with the defaults:

Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (Connection is broken [90067-119])

Since this is an embedded H2 instance, what would the connection parameters be?

Please CC directly as well.

Thanks.

– James

2

Hey James,

There is an issue with the default parameters, the way they are set up the connection tries to set up a TCP connection, rather than a direct connection. You can simply remove the “host” parameter and it should work.

If you want to file a bug report in jira i’ll fix the default parameters.

-Justin

···

On Wed, Apr 24, 2013 at 3:34 PM, James Lamanna <jlamanna@anonymised.com> wrote:

Hi,
I’m trying to figure out how to create a new H2 datastore to store from vectors to be served out through WFS.
I’ve gone to Add New Store (H2 Embedded)
I put in a Data Source Name, however, I’m not sure what to put in for any of the connection parameters. I always receive this error with the defaults:

Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (Connection is broken [90067-119])

Since this is an embedded H2 instance, what would the connection parameters be?

Please CC directly as well.

Thanks.

– James

Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr

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.