I get these (might be the same ones before I moved the postgresql-9.3-1101.jdbc41.jar into C:\Program Files\Apache Software Foundation\Tomcat 8.0\lib
Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot load JDBC driver class 'org.postgresql.driver'
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1778)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:905)
at org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:300)
at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:114)
at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:547)
... 112 more
Caused by: java.sql.SQLException: Cannot load JDBC driver class 'org.postgresql.driver'
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2000)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1896)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1764)
... 116 more
Caused by: java.lang.ClassNotFoundException: org.postgresql.driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1333)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1180)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:1991)
... 119 more
---- Andrea Aime <andrea.aime@anonymised.com> wrote:
On Fri, Jun 13, 2014 at 5:25 PM, <ebarker111@anonymised.com> wrote:
> Andrea,
>
> Until now, no, so I did that. I do get a different error in the logs
> (so a step closer):
>
> 2014-06-13 15:20:52,501 ERROR [geotools.jdbc] - There's code using JDBC
> based datastore and not disposing them. This may lead to temporary loss of
> database connections. Please make sure all data access code calls
> DataStore.dispose() before freeing all references to it
> 2014-06-13 15:20:52,502 ERROR [geotools.jdbc] - There's code using JDBC
> based datastore and not disposing them. This may lead to temporary loss of
> database connections. Please make sure all data access code calls
> DataStore.dispose() before freeing all references to it
> 2014-06-13 15:20:52,502 ERROR [geotools.jdbc] - There's code using JDBC
> based datastore and not disposing them. This may lead to temporary loss of
> database connections. Please make sure all data access code calls
> DataStore.dispose() before freeing all references to it
>Eh, not sure about these. Aren't you getting any other error or stack trace
before? These are normally by-products of some
other issueCheers
Andrea--
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.Ing. Andrea Aime
@geowolf
Technical LeadGeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549http://www.geo-solutions.it
http://twitter.com/geosolutions_it-------------------------------------------------------