How to deserialize / serialize type Geometry in spring boot?

Question

I have an entity with attributes of type MultiPolygon and Point; so I'm making a get request but this is returning a SerializationException.

I researched it and saw that I have to put some notes, create a configuration class and put the corresponding dependency in pom.xml. Follow as I did below:

Entity:

package com.zxventures.model;

@Entity
@Table(name = "pdv")
public class PDV implements Serializable {

private static final long serialVersionUID = 1L;

 @Column(name="coverage_area")
 @JsonSerialize(using = GeometrySerializer.class)
 @JsonDeserialize(contentUsing = GeometryDeserializer.class)
 private MultiPolygon coverageArea;

 @Column(name="address")
 @JsonSerialize(using = GeometrySerializer.class)
 @JsonDeserialize(contentUsing = GeometryDeserializer.class)
 private Point address;
}

Config class:

package com.zxventures.config;

@Configuration
public class JacksonConfig {

 @Bean
 public JtsModule jtsModule() {
  return new JtsModule();
 }
}

pom.xml:

<dependency>
<groupId>com.bedatadriven</groupId>
<artifactId>jackson-datatype-jts</artifactId>
<version>2.4</version>
</dependency>

The exception occurs:

could not deserialize; nested exception is 
org.hibernate.type.SerializationException: could not deserialize

I think I'm missing some code but I can not detect it; I think I put all the code I saw in similar questions.

@RoddyoftheFrozenPeas Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: could not deserialize; nested exception is org.hibernate.type.SerializationException: could not deserialize] with root cause java.io.StreamCorruptedException: invalid stream header: 00000000 — philabreu, Jul 03 '19 at 01:07
You seem to be confusing Java serialization and JSON serialization. — chrylis -cautiouslyoptimistic-, Jul 03 '19 at 01:10
@chrylis No, I'm not confusing; the error only happens when I deserialize those specific type of fields ... when I omit them, it works perfectly ... this is not the problem. — philabreu, Jul 03 '19 at 01:12
Jackson has nothing whatsoever to do with the sort of serialization in your error messages. — chrylis -cautiouslyoptimistic-, Jul 03 '19 at 02:04
@philabreu I'm having the same problem. Did you find a solution for this? — geschema, Sep 24 '22 at 15:54

score 2 · Answer 1 · answered Jan 07 '20 at 06:39

2

I had the same issue and added below line to application.properties then it works.

spring.jpa.database-platform=org.hibernate.spatial.dialect.postgis.PostgisDialect

answered Jan 07 '20 at 06:39

caglar

380
3
8

score 0 · Accepted Answer · answered Jul 03 '19 at 05:05

0

You're using Spatial data types, so need to include below dependency to work

<dependency>
  <groupId>org.hibernate</groupId>
  <artifactId>hibernate-spatial</artifactId>
</dependency>

And change dialect accordingly e.g. org.hibernate.spatial.dialect.mysql.MySQL56InnoDBSpatialDialect

See Spatial data types

answered Jul 03 '19 at 05:05

Sukhpal Singh

2,130
9
20

When I put these snippets, I now get a `java.io.StreamCorruptedException: invalid stream header: 00000000` I researched, but I did not find any solution for spatial type. – philabreu Jul 11 '19 at 19:01
1

Bingo! Along with what you said, I had to change `import org.geojson.MultiPolygon; import org.geojson.Point;` per `import com.vividsolutions.jts.geom.MultiPolygon; import com.vividsolutions.jts.geom.Point;` Thanks very much! – philabreu Jul 11 '19 at 19:26

How to deserialize / serialize type Geometry in spring boot?

2 Answers2

Linked