Hi,

It should be ok that geoserver did not auto detect the native srid of your
data. As long as you force to declared it should work ok.

This error sounds to me like perhaps there is an issue with the style you
are attempting to use. Are you using a custom style? I would perhaps try
with one of the built in styles (point,line,polygon) to see if works with
that first.

Also what version of gs are you running?

-Justin

2010/9/12 Игорь Григорьев <[email protected]>

> Hello,
>
> I'm pretty new to geoserver, and I'm stuck trying to setup layer from SQL
> server data store. I made a table with geometry column, containing points
>
> CREATE TABLE [dbo].[NETWORK_ELEMENT](
>     [IP_ADDRESS] [varchar](15) NULL,
>     [LAT] [float] NULL,
>     [LON] [float] NULL,
>     [Q1_ADDRESS] [int] NOT NULL,
>     [S_TIMESTAMP] [datetime] NOT NULL,
>     [GEOMETRY_COLUMN] [geography] NULL,
>  CONSTRAINT [PK_NETWORK_ELEMENT] PRIMARY KEY CLUSTERED
> (
>     [Q1_ADDRESS] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY =
> OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
>
> I created data store successfully, but when I'm trying to create layer it
> seems that geoserver can't find any geodata, it finds no native SRS or
> bounding box. The following exeptions fall, when I'm trying to test layer
> with force declared SRS configured as EPSG:4326 and default style as point.
>
> Are there any special requierements for data or something else with SQL
> server data store? Where I can find any usefull example on SQL server?
>
> I tried latest stable version of geoserver and nightly builds. I use
> glassfish v3 as container (it requires JRE 6) and MS SQL 2008 R2 with mssql
> jdbc 3.0 driver.
>
> INFO: 12 сен 17:37:54 ERROR [geotools.rendering] -
> java.lang.NullPointerException
>         at
> org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1771)
>         at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:722)
>         at
> org.geotools.renderer.shape.ShapefileRenderer.renderWithStreamingRenderer(ShapefileRenderer.java:1563)
>         at
> org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:1404)
>         at
> org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:381)
>         at
> org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:437)
>         at
> org.geoserver.ows.adapters.ResponseAdapter.getMimeType(ResponseAdapter.java:48)
>         at org.geoserver.ows.Dispatcher.response(Dispatcher.java:712)
>         at
> org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
>         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.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
>         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.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: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)
>
> INFO: 12 сен 17:37:54 ERROR [geoserver.ows] -
> org.vfny.geoserver.wms.WmsException: org.vfny.geoserver.wms.WmsException:
> Rendering process failed
>         at
> org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:458)
>         at
> org.geoserver.ows.adapters.ResponseAdapter.getMimeType(ResponseAdapter.java:48)
>         at org.geoserver.ows.Dispatcher.response(Dispatcher.java:712)
>         at
> org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
>         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.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
>         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.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: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: org.vfny.geoserver.wms.WmsException: Rendering process failed
>         at
> org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:405)
>         at
> org.vfny.geoserver.wms.responses.GetMapResponse.execute(GetMapResponse.java:437)
>         ... 68 more
> Caused by: java.lang.Exception: Exception rendering layer
> FeatureCollectionMapLayer[ NETWORK_ELEMENT, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=point],
> data=org.vfny.geoserver.global.geoserverfeaturesou...@58b586, query=Query:
>    feature type: NETWORK_ELEMENT
>    filter: [Filter.INCLUDE AND Filter.INCLUDE]
>    [properties:  ALL ]]
>         at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:726)
>         at
> org.geotools.renderer.shape.ShapefileRenderer.renderWithStreamingRenderer(ShapefileRenderer.java:1563)
>         at
> org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:1404)
>         at
> org.vfny.geoserver.wms.responses.DefaultRasterMapProducer.produceMap(DefaultRasterMapProducer.java:381)
>         ... 69 more
> Caused by: java.lang.NullPointerException
>         at
> org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1771)
>         at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:722)
>         ... 72 more
>
>
> --
> Igor Grigoryev
>
>
> ------------------------------------------------------------------------------
> 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
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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

Reply via email to