All Questions
Tagged with java postgresql
32 questions
0
votes
0
answers
17
views
Maven error compiling GeoServer custom WPS [duplicate]
I'm attempting to build a custom GeoServer WPS plugin using Maven but I'm encountering issues during compilation. I've updated my POM file and added all the required dependencies, including GeoServer ...
- 1
1
vote
1
answer
2k
views
Solve invalid endian flag value encountered exception on PostGIS and Quarkus
I am trying to run a simple example with PostGIS but I am getting the error:
Caused by: java.lang.NoSuchMethodError: 'void org.hibernate.dialect.PostgreSQL81Dialect.registerColumnType(int, java.lang....
- 305
0
votes
1
answer
145
views
GeoTools error NumericConverterFactory and GeoServer 2.22.2 with Java 17
We've upgraded to GeoServer 2.22.2 (GeoTools 28.2, Java 17, Postgres 12.7 RDS, PostGIS 3.0.3, Tomcat 9.0.10). Everything runs well except that we get a GeoTools error for a WFS request with a Filter ...
0
votes
0
answers
212
views
Java code to join lines in PostgreSQL : No results were returned by the query
I have a line layer named verlegte_trasse in PostgreSQL that contains a lot of lines. I want to join the lines that are connected and have same value in attribute field 'bemerkung' in a new table ...
- 41
0
votes
0
answers
131
views
GeoNetwork 4.2.1 (Debian) install : error message
I work on a Linux Debian server. I downloaded the last war file v4.2.1. I pasted it into /var/lib/tomcat9/webapps. I have checked the permissions and i configured the postgresql DB. The GeoNetwork log ...
- 1,012
1
vote
0
answers
402
views
Load shapefile from local machine to database PostgreSQL
I have a method that imports shapefile to PostgreSQL (using GeoTools), it takes as arguments the path of the shapefile (it's working fine). The problem is I want the user to select a shapefile from ...
- 71
3
votes
1
answer
1k
views
PSQLException: ERROR: operator does not exist: public.geometry && public.geometry
I have database with PostGIS already installed. I am running the following query from pgAdmin and I am successfully able to run it without any errors.
But when I run it with Java, I am getting the ...
- 193
0
votes
0
answers
870
views
Inserting X,Y to Geometry in Spring Boot and PostgreSQL?
I use @query to Insert X,Y to Geometry in PostgreSQL.
@Modifying
@Query(value = " insert into mypoints (name,geom) values (:name,SRID=4326;POINT(:x :y))", nativeQuery = true)
@Transactional
void ...
0
votes
1
answer
347
views
Alternative of intersects ?# operator in postgres
Is there any way to find if a path is intersecting with a box in postgres without using ?# or using an alternative?
I have this query below and hibernate's EntityManager is throwing an exception ...
- 251
1
vote
1
answer
1k
views
Unable to deserialize entity which contains field with type org.postgresql.geometric.PGpath
I have an Entity which has a field named coordinates of type org.postgresql.geometric.PGpath :
public class Geometry
{
...
@Column
@NotNull
private PGpath coordinates;
I am trying to ...
- 251
1
vote
1
answer
1k
views
Creating a shapefile with SQL Query Using Geotools Hibernate and Java
Here is my context :
1] I have geometries in an postgresql database
2] My application uses JAVA/Hibernate
3] I Currently use Geotools to create a shapefile
How I do it ?
First i retrieve my ...
- 91
1
vote
0
answers
81
views
Why coordinates are saved like "0101000020110F00003CDBA337DCC351C06D37C1374D374840" in db? [closed]
On my DB, the data looks like this:
In the DAO I am executing a query:
public Object login(UserEntity user) {
StringBuffer sb = new StringBuffer();
sb.append("SELECT user FROM ...
- 61
2
votes
0
answers
618
views
Creating GeoJSON REST service
I'm trying to create a GeoJSON REST service from a PostgreSQL connection.
First I fetch GeoJSON as a string from PostgreSQL:
import java.util.*;
import java.sql.Connection;
import java.sql....
- 121
4
votes
2
answers
1k
views
OSM Line 'way' from PostgreSQL (PostGIS) to Java Linestring (from JTS library)
I would like to read the data from PostGIS OSM database to Java object. I have 'planet_osm_line' table. I'd like to get 'osm_id' and 'way' column read by ResultSet, as here:
stmt = con....
- 215
-1
votes
1
answer
1k
views
Get PostGIS geometry data and display it on map using GetMapRequest
How can I get the data from PostgreSQL db and display on map using GetMapRequest?
I have done connecting the PostgreSQL db which contains the geometry data.
Now I want to redirect that data to map ...
