[Geoserver-users] Creation of a layer from an existing Postgis table

[François CELLIER]

Hi,

 

I am using geoserver 2.5 and geoserver-manager 1.5.2. I am trying to create
a layer from an existing table imported in Postgis using the following code
:

 

GSFeatureTypeEncoder fte = new GSFeatureTypeEncoder();

fte.setName(item.getSigName()); //item.getSigName() is my Postgis table name

fte.setSRS(tmp.getCrs());

fte.setNativeBoundingBox(-5.0, -5.0, 5.0, 5.0, tmp.getCrs());

 

GSLayerEncoder layerEncoder = new GSLayerEncoder();

layerEncoder.setEnabled(true);

layerEncoder.setQueryable(true);

 

// source.getVirtualItem().getSigName() is the name of the datastore

if(!manager.getPublisher().publishDBLayer(WORKSPACE,
source.getVirtualItem().getSigName(), fte, layerEncoder)){     

System.out.print(“error”);

}

 

 

Geoserver logs are :

 

2015-05-12 11:15:23,646 INFO [org.geoserver] - Loaded feature type
'tt_1431420716200', enabled

2015-05-12 11:15:23,802 ERROR [geoserver.rest] - :Error occurred creating
table

2015-05-12 11:15:23,802 ERROR [geoserver.rest] - 

org.geoserver.rest.RestletException: java.io.IOException: Error occurred
creating table

                at
org.geoserver.rest.ReflectiveResource.handleException(ReflectiveResource.jav
a:325)

                at
org.geoserver.rest.ReflectiveResource.handlePost(ReflectiveResource.java:123
)

                at org.restlet.Finder.handle(Finder.java:296)

                at
org.geoserver.rest.BeanDelegatingRestlet.handle(BeanDelegatingRestlet.java:3
7)

                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:204)

                at
com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.ja
va:129)

                at
org.geoserver.rest.RESTDispatcher.handleRequestInternal(RESTDispatcher.java:
86)

                at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstrac
tController.java:153)

                at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(Si
mpleControllerHandlerAdapter.java:48)

                at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServl
et.java:923)

                at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServle
t.java:852)

                at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:882)

                at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.jav
a:789) 

 

The logs makes me think that geoserver tries to create the table but it
already exists so an error occurred.

 

What is the correct way to create a layer from an existing table ?

 

Best regards,

François


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users