I am using a GeoServer 1.6.0 and Oracle 10g Spatial 10.1.0.2. I am trying to
visualize a road network, so when i go to FeatureType Editor: i declare a
style and add the SRS. WHEN i click the GENERATE button at BOUNDING BOX. it
gives the following error:
GeoServer - Exception
The following exception was thrown:
org.geotools.data.DataSourceException: Could not count Request All Features
I have earlier visualized similar road network data with less data column
and has no problem in visualizing them but with the following data set,
which has more data column, it returns the above error.
Is it because of the size of the data column?
Please throw some light on this problem.
Following is the description of the road network table, which is giving the
problem.
SQL> desc BZ_ROADS2_LINK;
Name Null? Type
----------------------------------------- --------
----------------------------
LINK_ID NOT NULL NUMBER
LINK_NAME VARCHAR2(200)
START_NODE_ID NOT NULL NUMBER
END_NODE_ID NOT NULL NUMBER
LINK_TYPE VARCHAR2(200)
ACTIVE VARCHAR2(1)
LINK_LEVEL NUMBER
GEOMETRY MDSYS.SDO_GEOMETRY
COST NUMBER
BIDIRECTED VARCHAR2(1)
GC_ID VARCHAR2(8)
GC_CODICE VARCHAR2(8)
GC_CODAGGR VARCHAR2(8)
GC_QMED NUMBER
GC_COUNT NUMBER(38)
GC_SVIL NUMBER
ID NUMBER
FEATTYP NUMBER(38)
FT NUMBER(38)
F_JNCTID NUMBER
F_JNCTTYP NUMBER(38)
T_JNCTID NUMBER
T_JNCTTYP NUMBER(38)
PJ NUMBER(38)
METERS NUMBER
FRC NUMBER(38)
NET1CLASS NUMBER(38)
NET2CLASS NUMBER(38)
NAME VARCHAR2(70)
NAMELC VARCHAR2(3)
SOL NUMBER(38)
JUMP VARCHAR2(1)
ROUTENUM VARCHAR2(10)
RTETYP NUMBER(38)
RTEDIR VARCHAR2(2)
RTEDIRVD VARCHAR2(2)
PROCSTAT NUMBER(38)
COD_REG VARCHAR2(2)
COD_PROV VARCHAR2(3)
COD_COM VARCHAR2(3)
GC_DESCR VARCHAR2(80)
LONG1 NUMBER
LONG2 NUMBER(38)
IDASSE NUMBER(38)
LST_ONEWAY VARCHAR2(4)
LST_PUT VARCHAR2(3)
ID_STRASSE NUMBER(38)
TEXT_D VARCHAR2(254)
TEXT_I VARCHAR2(254)
TEXT_DIL VARCHAR2(254)
ANNOTAZION VARCHAR2(254)
NODO_VL VARCHAR2(8)
CORSIABUS VARCHAR2(1)
NUMCORSIE VARCHAR2(10)
NODO_MT VARCHAR2(8)
--
View this message in context: http://www.nabble.com/org.geotools.data.DataSourceException%3A-Could-not-count-Request-All-Features-tp14993335p14993335.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
I am using a GeoServer 1.6.0 and Oracle 10g Spatial 10.1.0.2. I am trying to
visualize a road network, so when i go to FeatureType Editor: i declare a
style and add the SRS. WHEN i click the GENERATE button at BOUNDING BOX. it
gives the following error:
GeoServer - Exception
The following exception was thrown:
org.geotools.data.DataSourceException: Could not count Request All Features
Unfortunately the GeoServer UI does not give much information
about what went wrong. You should look into the GeoServer log and report
the full stack trace for that exception. The log file is in the
geoserver data directory, logs/geoserver.log file. For example, if you
installed geoserver under windows the file should be more or less at
c:\program files\geoserver\data_dir\logs\geoserver.log
If you cannot make head or tails of the stack trace, send it to the
users list and we'll look at it together.
Thanks for a fast reply. i went through the geoserver log file and found
that the following error is thrown:
2008-01-21 10:08:24,265 WARN [action.RequestProcessor] - Unhandled Exception
thrown: class org.geotools.data.DataSourceException
Can you make something out of it?
No, I need a full stack trace. It's something that looks like the following:
java.io.FileNotFoundException: fred.txt
at java.io.FileInputStream.<init>(FileInputStream.java)
at ExTest.readMyFile(ExTest.java:19)
at ExTest.main(ExTest.java:7)
(make sure to include it with all the "Caused By" elements, if there
is any).
Cheers
Andrea
I have attached below the geoserver log file. Please note that the postgres
error is there because i was using a postgres db together with oracle
spatial.
thank you
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: password authentication failed for user
"postgres")
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.geotools.data.jdbc.datasource.DataSourceUtil.buildDefaultDataSource(DataSourceUtil.java:120)
... 105 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication
failed for user "postgres"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 107 more
2008-01-21 10:25:35,953 WARN [config.DataConfig] - Could not use bla
datastore was unavailable!
2008-01-21 10:25:35,953 WARN [config.DataConfig] -
java.lang.NullPointerException
at
org.vfny.geoserver.config.DataConfig.getFeatureTypeIdentifiers(DataConfig.java:951)
at
org.vfny.geoserver.form.data.DataFeatureTypesNewForm.getNewFeatureTypes(DataFeatureTypesNewForm.java:31)
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.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
at
org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1132)
at
org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686)
at
org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715)
at
org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290)
at
org.apache.struts.taglib.html.OptionsTag.getIterator(OptionsTag.java:371)
at org.apache.struts.taglib.html.OptionsTag.doEndTag(OptionsTag.java:243)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_options_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:208)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_select_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:178)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_form_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:112)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspService(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)
at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:614)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:99)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:135)
at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:760)
at
org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:892)
at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:462)
at
org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp._jspx_meth_tiles_insert_7(org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp:1418)
at
org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp._jspService(org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp:639)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:268)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.doForward(MultipleDelegatingTilesRequestProcessor.java:346)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.processTilesDefinition(MultipleDelegatingTilesRequestProcessor.java:212)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.processForwardConfig(MultipleDelegatingTilesRequestProcessor.java:81)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1054)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
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:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1045)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1045)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:358)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:303)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:452)
at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:721)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:509)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:349)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:320)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
2008-01-21 10:25:35,968 WARN [config.DataConfig] - Could not use mysql
datastore was unavailable!
2008-01-21 10:25:35,968 WARN [config.DataConfig] -
java.lang.NullPointerException
at
org.vfny.geoserver.config.DataConfig.getFeatureTypeIdentifiers(DataConfig.java:951)
at
org.vfny.geoserver.form.data.DataFeatureTypesNewForm.getNewFeatureTypes(DataFeatureTypesNewForm.java:31)
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.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773)
at
org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1132)
at
org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686)
at
org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715)
at
org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290)
at
org.apache.struts.taglib.html.OptionsTag.getIterator(OptionsTag.java:371)
at org.apache.struts.taglib.html.OptionsTag.doEndTag(OptionsTag.java:243)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_options_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:208)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_select_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:178)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspx_meth_html_form_0(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:112)
at
org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp._jspService(org.apache.jsp.WEB_002dINF.pages.data.featureTypes.New_jsp:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)
at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:614)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:99)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:135)
at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:760)
at
org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:892)
at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:462)
at
org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp._jspx_meth_tiles_insert_7(org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp:1418)
at
org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp._jspService(org.apache.jsp.WEB_002dINF.pages.layouts.mainLayout_jsp:639)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:268)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.doForward(MultipleDelegatingTilesRequestProcessor.java:346)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.processTilesDefinition(MultipleDelegatingTilesRequestProcessor.java:212)
at
org.vfny.geoserver.config.web.tiles.MultipleDelegatingTilesRequestProcessor.processForwardConfig(MultipleDelegatingTilesRequestProcessor.java:81)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:459)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1054)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
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:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1045)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1045)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:358)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:231)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:629)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:453)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:303)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:452)
at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:721)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:509)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:349)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:320)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
2008-01-21 10:25:58,203 WARN [action.RequestProcessor] - Unhandled Exception
thrown: class org.geotools.data.DataSourceExceptionCaused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: password authentication failed for user
"postgres")
--
View this message in context: http://www.nabble.com/org.geotools.data.DataSourceException%3A-Could-not-count-Request-All-Features-tp14993335p14993939.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
I have attached below the geoserver log file. Please note that the postgres
error is there because i was using a postgres db together with oracle
spatial.
All the errors reported in the stack trace are related to postgres, there is none relating to Oracle that I can see. I suggest you stop
geoserver, wipe out the logs, restart geoserver and redo the request
that fails on oracle and look again in the logs.
Hmm... ok. That one has nothing to do with GeoServer thought. My guess
when I see that error is that something in the oracle spatial index
is corrupt. I'm no Oracle expert, but I'd suggest to check geometry
validity (there are Oracle functions to perform this check, but can't
remeber their names) and eventually to redo the spatial index.
Hmm… ok. That one has nothing to do with GeoServer thought. My guess
when I see that error is that something in the oracle spatial index
is corrupt. I’m no Oracle expert, but I’d suggest to check geometry
validity (there are Oracle functions to perform this check, but can’t
remeber their names) and eventually to redo the spatial index.
I'm just seeing this post about connecting to an Oracle datasource.
My question is what are the "correct privileges" to set up, to be able to
connect to an Oracle datasource.
I'm using geoserver 1.7.
When I set up a connection with a user account of Oracle, the connection
works, i can see the different tables but i can't use the tables : when I
click on "generate bouding box" it fails.
When I set up a connection with an administrator account of my Oracle
database, the connection works and the generation of the bounding box works.
So I guess, it's a problem of privileges.
I'm not allowed to use the administrator account. So I wonder which
privileges are necessary.
(It's really wierd because with ArcIMS I manage to set up a map by
connecting to the oracle datasource with the user account used below).
Thanks a lot for your help.
Bertrand.
gisrob wrote:
You probably also want to check that the oracle user has the correct
privileges set up.
On 21/01/2008, Andrea Aime <aaime@anonymised.com> wrote:
Hmm... ok. That one has nothing to do with GeoServer thought. My guess
when I see that error is that something in the oracle spatial index
is corrupt. I'm no Oracle expert, but I'd suggest to check geometry
validity (there are Oracle functions to perform this check, but can't
remeber their names) and eventually to redo the spatial index.
Hi, are you sure it is an issue with privileges? It might just be an issue with GeoServer accessing the table. You said you get an error when geoserver tries to generate the bounds? Can you include the error from the log?
Thanks,
-Justin
btignon wrote:
Hi !
I'm just seeing this post about connecting to an Oracle datasource.
My question is what are the "correct privileges" to set up, to be able to
connect to an Oracle datasource.
I'm using geoserver 1.7.
When I set up a connection with a user account of Oracle, the connection
works, i can see the different tables but i can't use the tables : when I
click on "generate bouding box" it fails.
When I set up a connection with an administrator account of my Oracle
database, the connection works and the generation of the bounding box works.
So I guess, it's a problem of privileges.
I'm not allowed to use the administrator account. So I wonder which
privileges are necessary.
(It's really wierd because with ArcIMS I manage to set up a map by
connecting to the oracle datasource with the user account used below).
Thanks a lot for your help.
Bertrand.
gisrob wrote:
You probably also want to check that the oracle user has the correct
privileges set up.
On 21/01/2008, Andrea Aime <aaime@anonymised.com> wrote:
Choe ha scritto:
Hi,
Following is the Caused by error i found in the START GEOSERVER
Hmm... ok. That one has nothing to do with GeoServer thought. My guess
when I see that error is that something in the oracle spatial index
is corrupt. I'm no Oracle expert, but I'd suggest to check geometry
validity (there are Oracle functions to perform this check, but can't
remeber their names) and eventually to redo the spatial index.
