Hi Andrea
Ok, I had not chosen the VERBOSE_LOGGING.properties log4j file. Once I did, I
got
2010-10-08 14:30:53,997 DEBUG [geotools.jdbc] - Gathering sql view result
structure: select * from (select * from myfunc(,'')) as "vtable" LIMIT 0
So I put in defaults and then it worked. But I swear I originally had defaults
:).
Anyway, this was me trying to recreate a view that was giving trouble and I
wanted to make sure I had created it properly. Other than it not being able to
auto generate the bounding boxes I think it's ok (and the queries work from
psql just fine).
So my problem is now that I get a null pointer exception when trying to use the
layer (from layer preview or an openlayers app).
Any idea what's going on here?
Thanks,
charles
2010-10-08 14:37:08,763 DEBUG [geoserver.filters] - filtering
http://localhost:8080/geoserver/web/
2010-10-08 14:37:08,763 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/web/]
2010-10-08 14:37:08,763 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/web/]
2010-10-08 14:37:08,780 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/screen.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,782 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/print.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,783 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/geoserver.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,785 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/ie.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,786 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/geoserver-ie.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,788 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/js/jquery-1.2.6.min.js
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:08,790 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/js/jquery.inline-info.js
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:12,374 DEBUG [geoserver.filters] - filtering
http://localhost:8080/geoserver/wms
2010-10-08 14:37:12,375 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/wms]
2010-10-08 14:37:12,375 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/wms]
2010-10-08 14:37:12,375 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/wms]
2010-10-08 14:37:12,375 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/wms]
2010-10-08 14:37:12,375 DEBUG [geoserver.ows] - Getting layers and styles from
LAYERS and STYLES
2010-10-08 14:37:12,376 DEBUG [geotools.styling] - number of fts set 1
2010-10-08 14:37:12,376 DEBUG [geoserver.ows] - establishing line style for
myWorkspace:mylayer
2010-10-08 14:37:12,377 DEBUG [responses.GetMapResponse] - setting up map
2010-10-08 14:37:12,377 ERROR [geoserver.ows] -
org.vfny.geoserver.wms.WmsException: java.lang.NullPointerException
at
org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:530)
at
org.geoserver.ows.adapters.ResponseAdapter.getMimeType(ResponseAdapter.java:49)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:761)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:233)
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:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:48)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
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:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at
org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:144)
at $Proxy8.getDataStore(Unknown Source)
at
org.geoserver.wms.MapLayerInfo.getFeatureSource(MapLayerInfo.java:310)
at
org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:271)
... 57 more
2010-10-08 14:37:19,985 DEBUG [geoserver.filters] - filtering
http://localhost:8080/geoserver/web/
2010-10-08 14:37:19,986 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/web/]
2010-10-08 14:37:19,986 DEBUG [ows.OWSHandlerMapping] - Looking up handler for
[/web/]
2010-10-08 14:37:19,989 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/screen.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,991 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/print.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,992 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/geoserver.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,994 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/blueprint/ie.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,995 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/css/geoserver-ie.css
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,997 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/js/jquery-1.2.6.min.js
to file (URI is not hierarchical), falling back to the inputstream for polling
2010-10-08 14:37:19,999 DEBUG [geoserver.web] - cannot convert url:
jar:file:/opt/apache-tomcat-6.0.29/webapps/geoserver/WEB-INF/lib/web-core-2.1-beta1.jar!/org/geoserver/web/js/jquery.inline-info.js
to file (URI is not hierarchical), falling back to the inputstream for polling
On Oct 8, 2010, at 2:08 PM, Andrea Aime wrote:
> I don't exaclty know what is going on, but sql views params just make a text
> substitution,
> so you should find the exact query GeoServer is sending to the database in
> the logs
> somewhere before the exception.
>
> Once you have that sql you can what's wrong and hopefully find a solution
>
> Cheers
> Andrea
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
