[Geoserver-users] data

Are there any know issues with connection from an older geoserver (1.6.5) on
our server to a newer postGIS (1.3) database. I'm trying to connect to a
different data store, and I get 'invalid connection parameters". I'm able
to connect from a geoserver 1.7 on my local machine. I think I have all the
pg_hba.conf stuff set correctly. The geoserver log is below.

Thanks,
Steve

Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University

2009-02-27 15:19:16,816 WARN [geotools.data] - Could not acquire PostGIS
spatial database:org.geotools.data.DataSourceException: Connection test
failed
org.geotools.data.DataSourceException: Connection test failed
        at
org.geotools.data.jdbc.datasource.DataSourceUtil.buildDefaultDataSource(Data
SourceUtil.java:122)
        at
org.geotools.data.postgis.PostgisDataStoreFactory.getDefaultDataSource(Postg
isDataStoreFactory.java:216)
        at
org.geotools.data.postgis.PostgisDataStoreFactory.createDataStore(PostgisDat
aStoreFactory.java:193)
        at
org.geotools.data.DataStoreFinder.getDataStore(DataStoreFinder.java:91)
        at
org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.java:62)
        at
org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils.java:
51)
        at
org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataSt
oresEditorAction.java:134)
        at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:431)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
        at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterE
ncodingFilter.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:16
3)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:264)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
        at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:110)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:217)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:229)
        at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
        at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
        at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:175)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128
)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102
)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http
11Protocol.java:584)
        at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Timer already cancelled.
        at java.util.Timer.sched(Unknown Source)
        at java.util.Timer.schedule(Unknown Source)
        at
org.apache.commons.pool.impl.GenericObjectPool.startEvictor(GenericObjectPoo
l.java:1077)
        at
org.apache.commons.pool.impl.GenericObjectPool.setTimeBetweenEvictionRunsMil
lis(GenericObjectPool.java:652)
        at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:1173)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:8
80)
        at
org.geotools.data.jdbc.datasource.DataSourceUtil.buildDefaultDataSource(Data
SourceUtil.java:120)
        ... 59 more

Stephen Crawford wrote:

Are there any know issues with connection from an older geoserver (1.6.5) on
our server to a newer postGIS (1.3) database. I'm trying to connect to a
different data store, and I get 'invalid connection parameters". I'm able
to connect from a geoserver 1.7 on my local machine. I think I have all the
pg_hba.conf stuff set correctly. The geoserver log is below.

Mumble... the stack trace looks funny, I have no specific idea, but I
know that I removed some parameters in the DBCP pool configuration
because they were causing too many reconnects in Oracle databases.
So probably this explains why 1.7 can connect, and 1.6.5 cannot.
I know of no good workaround to make 1.6.5 work thought.

Cheers
Andrea