andreaswbartels / jgisshell Goto Github PK

Hi
Accessing my Postgresql database with PostGis 3 installed.
I see the list of tables representing the layers within JGISShell.
However when tying to access the layer. I get the error below. The function is not in the database.
Database schema owned by the user specified in the connection, who has DBA privileges.
Access the database with mapsever / openlayers via WMS works.
java.io.IOException: org.postgresql.util.PSQLException: ERROR: function st_estimated_extent(name, name, name) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 251
at net.anwiba.spatial.database.layer.io.AbstractDatabaseLayerMetaDataReader.getGeometryMetaData(AbstractDatabaseLayerMetaDataReader.java:92)
at net.anwiba.spatial.database.layer.io.AbstractDatabaseLayerDescriptionReader.read(AbstractDatabaseLayerDescriptionReader.java:65)
at net.anwiba.spatial.database.layer.io.AbstractDatabaseLayerDescriptionReader.read(AbstractDatabaseLayerDescriptionReader.java:45)
at net.anwiba.jgisshell.swing.viewer.module.layer.LayerDataAccessOperatorsRegistry.read(LayerDataAccessOperatorsRegistry.java:229)
at net.anwiba.spatial.swing.map.action.LoadLayerNodeInViewProcess.execute(LoadLayerNodeInViewProcess.java:82)
at net.anwiba.commons.thread.process.ProcessRunner.run(ProcessRunner.java:83)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at net.anwiba.commons.thread.queue.WorkQueue$ProcessScheduledFuture.run(WorkQueue.java:77)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.postgresql.util.PSQLException: ERROR: function st_estimated_extent(name, name, name) does not exist