Hi, Read this thread: http://sourceforge.net/mailarchive/forum.php?thread_name=29621032.post%40talk.nabble.com&forum_name=geoserver-users
-Jukka Rahkonen- -----Alkuperäinen viesti----- Lähettäjä: Fernando Barbat [mailto:[email protected]] Lähetetty: ma 13.9.2010 17:51 Vastaanottaja: [email protected] Aihe: Re: [Geoserver-users] GeoServer fails to load layers when using JNDI By the way, what is "Primary key metadata table"? It's a field of the JNDI Postgis configuration, but it doesn't appear on the documentation (here: http://docs.geoserver.org/2.0.0/user/data/postgis.html) Thanks. 2010/9/13 Fernando Barbat <[email protected]> > I'm using WinXP SP3, GeoServer 2.0.2 and Glassfish v3.0.1ml. > I configured a PostGIS database via JNDI. When I was going to add a layer > from that datasource, GeoServer thorws an exception. > If I do the same, but with a "standard" PostGIS configuration (not JNDI), > everything works fine. > Any idea? > Thanks. > > The exception showed in the administration interface: > > java.lang.RuntimeException: Error occurred while building the resources for > the configuration page at > org.geoserver.web.data.layer.NewLayerPage.buildLayerInfo(NewLayerPage.java:202) > at > org.geoserver.web.data.layer.NewLayerPage$3.onClick(NewLayerPage.java:173) > at org.geoserver.web.wicket.SimpleAjaxLink$1.onClick(SimpleAjaxLink.java:44) > at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:65) > at > org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163) > at > org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297) > at > org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:104) > at > org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91) > at > org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1239) > at org.apache.wicket.RequestCycle.step(RequestCycle.java:1316) at > org.apache.wicket.RequestCycle.steps(RequestCycle.java:1418) at > org.apache.wicket.RequestCycle.request(RequestCycle.java:532) at > org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356) at > org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:124) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at > org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158) > at > org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) > at > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) > at > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at > org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at > org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) > at > org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) > at > org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) > at > org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) > at > org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at > org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641) > at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97) at > com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185) > at > org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226) > at > com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165) > at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791) > at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693) at > com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954) at > com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170) > at > com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135) > at > com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102) > at > com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88) > at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76) > at > com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53) > at > com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57) > at com.sun.grizzly.ContextTask.run(ContextTask.java:69) at > com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330) > at > com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309) > at java.lang.Thread.run(Thread.java:619) > > Caused by: java.io.IOException: Error looking up primary key at > org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:825) at > org.geotools.jdbc.JDBCFeatureSource.<init>(JDBCFeatureSource.java:76) at > org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:709) > at > org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:383) > at > org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:348) > at > org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:647) > at > org.geoserver.catalog.CatalogBuilder.buildFeatureType(CatalogBuilder.java:324) > at > org.geoserver.web.data.layer.NewLayerPage.buildLayerInfo(NewLayerPage.java:198) > ... 84 more > > Caused by: org.postgresql.util.PSQLException: ERROR: no existe la columna > «a» Position: 8 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) at > org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455) > at $Proxy181.executeQuery(Unknown Source) at > com.sun.gjc.spi.jdbc40.StatementWrapper40.executeQuery(StatementWrapper40.java:233) > at > org.geotools.jdbc.HeuristicPrimaryKeyFinder.createPrimaryKey(HeuristicPrimaryKeyFinder.java:129) > at > org.geotools.jdbc.HeuristicPrimaryKeyFinder.getPrimaryKey(HeuristicPrimaryKeyFinder.java:56) > at > org.geotools.jdbc.CompositePrimaryKeyFinder.getPrimaryKey(CompositePrimaryKeyFinder.java:42) > at org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:813) ... > 91 more ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
