[Geoserver-users] Solved: AW: Layer creation using GeoServer Rest API fails with "invalid identifier" using Oracle

[Nachtigall, J. (init) <Jen...@in...>]

Solved, it was just a typo in the layer identifier (case sensitivity was not taken care of). Sorry for the noise.


Von: Nachtigall, Jens (init) [mailto:Jen...@in...]
Gesendet: Dienstag, 30. Juni 2015 13:41
An: geo...@li...
Betreff: [Geoserver-users] Layer creation using GeoServer Rest API fails with "invalid identifier" using Oracle

Hi,

using geoserver manager (1.6.0) I ask the GeoServer REST API to create a new Layer. The Oracle DB throws an "ORA-00904: : invalid identifier" error. (We use http://docs.geoserver.org/latest/en/user/data/database/oracle.html, which works fine otherwise)


Here is the request that geoserver manager sents out to GeoServer:
<?xml version="1.0" encoding="UTF-8"?>
<featureType>
  <enabled>true</enabled>
  <metadata />
  <keywords />
  <metadataLinks />
  <attributes />
  <srs>EPSG:31468</srs>
  <nativeBoundingBox>
    <minx>-74.047185</minx>
    <maxy>40.882078</maxy>
    <maxx>-73.90782</maxx>
    <miny>40.679648</miny>
    <crs>EPSG:31468</crs>
  </nativeBoundingBox>
  <name>shp_poly_landmarks</name>
</featureType>


The Response I get is:
Bad response: code[500] msg[Internal Server Error] url[http://myserver.com:28081/geoserver/rest/workspaces/BNB/datastores/bnb/featuretypes] method[PostMethod]: :Error occurred creating table


Any ideas? Is this a bug in GeoServer or the GeoServer Oracle Plugin? I found this issue that PostGIS and Oracle handle identifiers in a different way (http://gis.stackexchange.com/questions/25829/publishing-oracle-spatial-table-in-geoserver) but I am not sure if this is related.

Best,
Jens

PS

Here is the traceback as printed by GeoServer (loglevel set to GEOSERVER_DEVELOPER_LOGGING)


2015-06-30 13:15:44,128 INFO [org.geoserver] - Loaded feature type 'shp_poly_landmarks', enabled
2015-06-30 13:15:44,129 WARN [catalog.impl] - Failed to load actual store for FeatureTypeInfoImpl[shp_poly_landmarks]
2015-06-30 13:15:44,199 ERROR [geoserver.rest] - :Error occurred creating table
2015-06-30 13:15:44,200 ERROR [geoserver.rest] -
org.geoserver.rest.RestletException: java.io.IOException: Error occurred creating table
         at org.geoserver.rest.ReflectiveResource.handleException(ReflectiveResource.java:326)
         at org.geoserver.rest.ReflectiveResource.handlePost(ReflectiveResource.java:124)
         at org.restlet.Finder.handle(Finder.java:296)
         at org.geoserver.rest.BeanDelegatingRestlet.handle(BeanDelegatingRestlet.java:38)
         at org.restlet.Filter.doHandle(Filter.java:105)
         at org.restlet.Filter.handle(Filter.java:134)
         at org.restlet.Router.handle(Router.java:444)
         at org.geoserver.rest.RESTDispatcher$1.handle(RESTDispatcher.java:205)
         at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:129)
         at org.geoserver.rest.RESTDispatcher.handleRequestInternal(RESTDispatcher.java:87)
         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:923)
         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75)
         at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71)
         at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)
         at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:50)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)
         at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
         at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)
         at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)
         at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)
         at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
         at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:54)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)
         at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)
         at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)
         at org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:83)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)
         at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
         at org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:53)
         at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)
         at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
         at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
         at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:135)
         at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:76)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:48)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:48)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:44)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
         at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.IOException: Error occurred creating table
         at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:757)
         at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144)
         at org.geoserver.catalog.rest.FeatureTypeResource.handleObjectPost(FeatureTypeResource.java:137)
         at org.geoserver.rest.ReflectiveResource.handlePost(ReflectiveResource.java:121)
         ... 95 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
         at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
         at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
         at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
         at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
         at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:749)
         ... 98 more