Hi to all
im trying to install geoserver on ubuntu linux
When i start geoserver i get this message:
tsoler@…923…:~/geoserver/bin$ ./startup.sh
The JAVA_HOME environment variable is not defined
This environment variable is needed to run this program
Whetre to i set up the environment variable ??
On 2/8/07, geoserver-users-request@lists.sourceforge.net <geoserver-users-request@lists.sourceforge.net> wrote:
Send Geoserver-users mailing list submissions to
geoserver-users@lists.sourceforge.netTo subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/geoserver-users
or, via email, send a message with subject or body ‘help’ to
geoserver-users-request@lists.sourceforge.netYou can reach the person managing the list at
geoserver-users-owner@lists.sourceforge.netWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Geoserver-users digest…”Today’s Topics:
- Re: A exception on Geoserver1.4.0 (Andrea Aime)
- Re: Could not count Request All Features (Andrea Aime)
- Re: SQL Error building feature type (Virginie BERRE)
Message: 1
Date: Thu, 08 Feb 2007 14:54:07 +0100
From: Andrea Aime <aaime@…1…>
Subject: Re: [Geoserver-users] A exception on Geoserver1.4.0
To: taixingjason < taixingjason@…887…>, geoserver users
<geoserver-users@lists.sourceforge.net>
Message-ID: < 45CB2B7F.8030209@…1…>
Content-Type: text/plain; charset=x-gbk; format=flowedPlease, do use the users mailing list, don’t send me private mails.
The mailing list gives you a higher chance of finding someone that
knows how to address your issues, and makes my answers searchable
by other people too.taixingjason ha scritto:
I try to use Geoserver1.4.0 . These are some exception like :
SEVERE: SQL Exception reading geometry column
org.geotools.data.DataSourceException: SQL Exception reading geometry column
…
Caused by: java.sql.SQLException: Logical handle no longer valid
…
at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:494)
at oracle.sql.STRUCT.getOracleAttributes(STRUCT.java:411)
at
org.geotools.data.oracle.sdo.GeometryConverter.asGeometry (GeometryConverter.java:99)Yes, someone reported this issue already, but I have no idea on
how to reproduce it. Does this happen always, only when the
server is under load?Cheers
Andrea
Message: 2
Date: Thu, 08 Feb 2007 14:55:33 +0100
From: Andrea Aime <aaime@…1…>
Subject: Re: [Geoserver-users] Could not count Request All Features
To: leewse@…440…
Cc: geoserver-users@lists.sourceforge.net
Message-ID: < 45CB2BD5.5080600@…1…>
Content-Type: text/plain; charset=ISO-8859-1; format=flowedleewse@…440… ha scritto:
Hi,
We are still unable to resolve this issue. We have tried our best to
ensure what should be done are done.The feature we are trying to create is from a view. What we did is to
create a view, ensure there is a record for it in the geometry_columns. We
have another very similar view to this one and everything worked out fine
for that view, thus we are really losing ideas of what could be wrong with
this.To be more specific, here is the full stack trace:
2007-02-08 21:01:34 StandardWrapperValve[action]: Servlet.service() for
servlet action threw exception
org.geotools.data.DataSourceException: Could not count Request All Features
…
Caused by: org.postgresql.util.PSQLException: ERROR: function
extent(geometry) does not exist!!! The extent function cannot be found?
How old is your postgis? The extent function has been around for quite a
bit of time as far as I know… The postgis change log seems to suggest
it has been introduced in August 2004. Can you try to run a direct
query? May it be that the postgis functions are not properly registered?Cheers
Andrea
Message: 3
Date: Thu, 8 Feb 2007 15:18:19 +0100
From: “Virginie BERRE” <vberre@…81…>
Subject: Re: [Geoserver-users] SQL Error building feature type
To: “Andrea Aime” <aaime@…1…>
Cc: geoserver-users@lists.sourceforge.net
Message-ID: < 20D1EFF28EBD434E9DFC82683BBEB217347097@…849…>
Content-Type: text/plain; charset=“iso-8859-1”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@…1…]
Envoy? : mercredi 7 f?vrier 2007 19:21
? : Virginie BERRE
Cc : geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] SQL Error building feature typeVirginie 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
-------------- next part --------------
An HTML attachment was scrubbed…
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-usersEnd of Geoserver-users Digest, Vol 9, Issue 16
–
Γεώργιος Τσολάκης - Περιβαλλοντολόγος
Γραφείο Περιβαλλοντικών Μελετών
Ζήνωνος 57. Περιστέρι. Αθήνα
tel: +30 210 5727615
fax: +30 210 5727995
mobile: + 30 6977 158693
email: tsoler@…832…
URL : www.mpe.gr
