search

epicureanism / inspire-foss

Automatically exported from code.google.com/p/inspire-foss
GNU General Public License v3.0
0 stars 0 forks source link

PostgreSQL/PostGIS driver conflict during webapp init #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. having multiple (deegree) instances using PostgreSQL/GIS drivers 
2. when starting the container the deegree3 (most recent) webapps gives JDBC 
loading exception ("No suitable driver found" see exception below)
3. happens with cold startup restart or redeploy

Running on Ubuntu, Java6, PostgreSQL 8.3, PostGIS 1.4, Tomcat 6.0.20

What is the expected output? What do you see instead?
Normal init. The strange thing is that all JDBC actions go ok after, so the 
driver is initialized.

This is the observed output.

[10:46:52] ERROR: [FeatureStoreManager] Error creating feature store: No 
suitable driver found for jdbc:postgresql://localhost:5432/inspire_blob
org.deegree.feature.persistence.FeatureStoreException: No suitable driver found 
for jdbc:postgresql://localhost:5432/inspire_blob
    at org.deegree.feature.persistence.postgis.PostGISFeatureStore.init(PostGISFeatureStore.java:518)
    at org.deegree.feature.persistence.FeatureStoreManager.registerAndInit(FeatureStoreManager.java:209)
    at org.deegree.feature.persistence.FeatureStoreManager.init(FeatureStoreManager.java:131)
    at org.deegree.commons.config.DeegreeWorkspace.initAll(DeegreeWorkspace.java:216)
    at org.deegree.services.controller.OGCFrontController.initWorkspace(OGCFrontController.java:888)
    at org.deegree.services.controller.OGCFrontController.init(OGCFrontController.java:868)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
.jar

Please use labels and text to provide additional information.
Within the Tomcat container I have the following webapps. These start in this 
order and have the following driver versions:

1. deegree-wfs v2.4 OK
postgresql-8.3-603.jdbc3.jar
postgis-1.3.3.jar

2. deegree(3) inspire demo OK (uses memory store only)
postgresql-8.4-701.jdbc4.jar
postgis-jdbc-1.3.3.jar

3. deegree3 FAILS ("No suitable driver found")
postgresql-8.4-701.jdbc4.jar
postgis-jdbc-1.3.3.jar

4. GeoServer 2.0+ OK
postgresql-8.4-701.jdbc3.jar
gt-jdbc-postgis-2.6.4

1. and 3. use the same username but different DBs (inspire and inspire_blob)...

If I make 3. the only webapp in the Tomcat container then init is OK.

Original issue reported on code.google.com by jus...@gmail.com on 20 Sep 2010 at 12:49

GoogleCodeExporter commented 9 years ago 
Strange: even if I make webapp #1 use postgresql-8.4-701.jdbc4.jar
 so all deegree webapps use the same driver versions, I still get the error.

Original comment by jus...@gmail.com on 20 Sep 2010 at 12:54

GoogleCodeExporter commented 9 years ago 
This is fixed in deegree 3.0+ so can be closed.

Original comment by jus...@gmail.com on 1 Dec 2010 at 2:15