Hi Andrea !
Let see the geoserver stack trace :
org.geotools.data.DataSourceException: SQL Error building FeatureType for adresse ERROR: relation “adresse” does not exist
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:296)
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getMapper(DefaultFIDMapperFactory.java:95)
at org.geotools.data.jdbc.JDBC1DataStore.buildFIDMapper(JDBC1DataStore.java:1037)
at org.geotools.data.jdbc.FeatureTypeHandler.getFIDMapper(FeatureTypeHandler.java:234)
at org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:200)
at org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:169)
at org.geotools.data.jdbc.JDBC1DataStore.getSchema(JDBC1DataStore.java:360)
at org.vfny.geoserver.action.data.DataFeatureTypesNewAction.execute(DataFeatureTypesNewAction.java:86)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: ERROR: relation “adresse” does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
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:585)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
at $Proxy5.executeQuery(Unknown Source)
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.isAutoIncrement(DefaultFIDMapperFactory.java:345)
at org.geotools.data.postgis.fidmapper.PostgisFIDMapperFactory.isAutoIncrement(PostgisFIDMapperFactory.java:69)
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:278)
…
About the structure of my table, nothing is interesting, its schema is not public that’s all. So my table’s name is paris.adresse and it contains a geometry column.
Thanks for your help!
Virginie
-----Message d’origine-----
De : Andrea Aime [mailto:aaime@anonymised.com]
Envoyé : mercredi 7 février 2007 19:21
À : Virginie BERRE
Cc : geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] SQL Error building feature type
Virginie BERRE ha scritto:
Dear all !
I have a postgis database and tables which schema is not public. I’ve
configured the datastore with success. When I try to create a new
entity, it lists me all the tables but when I select one a click “New”
(I have a French version so I hope the button’s label is what I wrote!)
it tells me : “SQL Error building feature type my_table ; relation
“my_table” does not exists”. One the one hand I think it doesn’t care
about the schema because it would have tell “my_schema.my_table” and on
the other hand it lists me all the table which are in my schema…
It defaults to reporting only the tables in the public schema, unless
you specify one.
Unfortunately I don’t know what’s the issue, can you send me the
Geoserver logs by private mail? There I may find a stack trace,
which may inform me about the issue.
Also, can you dump the database structure for me?
If you use the command line psql tool, once logged in, you can get
it using “\d tablename”.
Cheers
Andrea Aime