I followed Nicholas's testing by creating a SQL View with no parameter. Assign the SRS and hit save. On the layer screen the correct native bounding box is displayed. If I hit compute from data I get funny bounds: 0, 0, -1, -1. Couldn't get a preview either.
Here's my log file (running with XP and Jetty) 127.0.0.1 - - [23/Dec/2010:16:21:04 +0000] "GET /geoserver/web/?wicket:bookmarkablePage=:org.geoserver.web.data.layer.LayerPage HTTP/1.1" 200 5399 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/blueprint/screen.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.apache.wicket.markup.html.WicketEventReference/wicket-event.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/js/jquery.inline-info.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/geoserver.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.apache.wicket.ajax.WicketAjaxReference/wicket-ajax.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/js/jquery-1.2.6.min.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/blueprint/print.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow/res/modal.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow/res/modal.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.StatusPage/null/img/icons/silk/server_chart.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.ContactPage/null/img/icons/silk/vcard.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.JAIPage/null/img/icons/silk/cog_photo.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.GlobalSettingsPage/null/img/icons/silk/server.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.wfs.web.WFSAdminPage/server_vector.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.wms.web.WMSAdminPage/server_map.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.workspace.WorkspacePage/null/null/img/icons/silk/folder.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.store.StorePage/null/null/img/icons/silk/database.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.layer.LayerPage/null/null/img/icons/silk/picture_empty.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.AboutGeoServerPage/img/icons/silk/help.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.layergroup.LayerGroupPage/null/null/img/icons/silk/layers.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.wms.web.data.StylePage/palette.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.gwc.web.GWCAdminPage/geowebcache-16.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.service.ServiceAccessRulePage/null/null/img/icons/silk/shape_square_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.catalog.CatalogModePage/null/null/img/icons/silk/application_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.wcs.web.WCSAdminPage/server_raster.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/silk/line_blue.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/silk/tick.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/geosilk/vector.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.LogPage/null/img/icons/silk/page_white_text.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/silk/shape_square_blue.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/geosilk/raster.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/ajax-loader.gif HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/icons/silk/bullet_blue.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.data.DataAccessRulePage/null/null/img/icons/silk/database_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:07 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.user.UserPage/null/null/img/icons/silk/user.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:15 +0000] "GET /geoserver/web/?wicket:bookmarkablePage=:org.geoserver.web.data.resource.ResourceConfigurationPage&name=Roads_SQL_View&wsName=NSL HTTP/1.1" 200 4808 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/blueprint/print.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/blueprint/screen.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/css/geoserver.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/js/jquery-1.2.6.min.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/js/jquery.inline-info.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.apache.wicket.markup.html.WicketEventReference/wicket-event.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.apache.wicket.ajax.WicketAjaxReference/wicket-ajax.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow/res/modal.js HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow/res/modal.css HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.StatusPage/null/img/icons/silk/server_chart.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.LogPage/null/img/icons/silk/page_white_text.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.GlobalSettingsPage/null/img/icons/silk/server.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.JAIPage/null/img/icons/silk/cog_photo.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.AboutGeoServerPage/img/icons/silk/help.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.wfs.web.WFSAdminPage/server_vector.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.store.StorePage/null/null/img/icons/silk/database.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.workspace.WorkspacePage/null/null/img/icons/silk/folder.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.gwc.web.GWCAdminPage/geowebcache-16.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.wms.web.WMSAdminPage/server_map.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.admin.ContactPage/null/img/icons/silk/vcard.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.wcs.web.WCSAdminPage/server_raster.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.layer.LayerPage/null/null/img/icons/silk/picture_empty.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.data.layergroup.LayerGroupPage/null/null/img/icons/silk/layers.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.user.UserPage/null/null/img/icons/silk/user.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.wms.web.data.StylePage/palette.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.service.ServiceAccessRulePage/null/null/img/icons/silk/shape_square_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.catalog.CatalogModePage/null/null/img/icons/silk/application_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.security.data.DataAccessRulePage/null/null/img/icons/silk/database_key.png HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:16 +0000] "GET /geoserver/web/resources/org.geoserver.web.GeoServerBasePage/img/ajax-loader.gif HTTP/1.1" 304 0 127.0.0.1 - - [23/Dec/2010:16:21:25 +0000] "POST /geoserver/web/?wicket:interface=:1:resource:tabs:panel:theList:0:content:referencingForm:computeNative::IActivePageBehaviorListener:0:&wicket:ignoreIfNotActive=true&random=0.45715727913193405 HTTP/1.1" 200 361 -- View this message in context: http://old.nabble.com/2.1-beta2-failure-to-calculate-native-bounds-for-SQL-View-tp30523388p30523388.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
