ClassCastException: org.postgresql.util.PGobject cannot be cast to org.postgis.Point

Question

I take columns from result set and retrieve geolocation as PGObject. In the next step I want to convert it to org.postgis.Point but I get the following exception.

Do you know how can get latitude and longitude from PGObject? Actually I want to convert PGObject type to org.postgis.Point.

I tried this, but does not work. In the result set:

(PGobject) rs.getObject("geolocation"),

In the constructor of object.

this.geolocation = (Point) geolocation;

Exception:

java.lang.ClassCastException: org.postgresql.util.PGobject cannot be cast to org.postgis.Point
at com.kaloudia.api.domain.custom.CompanyResultView.<init>(CompanyResultView.java:87) ~[classes/:na]
at com.kaloudia.api.manager.SearchManager.lambda$searchCompanies$0(SearchManager.java:166) ~[classes/:na]
at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93) ~[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]

Marat · Accepted Answer · 2016-06-19 09:52:37Z

4

If you want to use org.postgis.Point yout need to install postgis plugin to your postgres and postgis jdbc driver as well as postgres jdbc driver.

After that, if your column type is postgis point, you will be able to do PGgeometry geolocation = (PGgeometry) rs.getObject("geolocation");. Note that postgres geometry types are not the same with postGIS geometry types.

And finally you should do an extra action: org.postgis.Geometry geom = geolocation.getGeometry(); The geom should be of org.postgis.Point type.

answered Jun 19, 2016 at 9:52

Marat

2371 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

pik4 Over a year ago

My column is type of geography(Point,4326)

pik4 Over a year ago

Actually I took PGobject geolocation from ResultSet and then I implemented the code below:

String g = geolocation.getValue();   try {        Geometry fr = new PGgeometry().geomFromString(g);        Point p = fr.getPoint(0);        this.geolocation = p;   } catch (SQLException e) {        e.printStackTrace();   }

But I think that this code is not good code...

Željko Trogrlić · Accepted Answer · 2017-03-20 09:22:15Z

1

This is the shortest version without any unnecessary object creation or method calls:

PGobject pGobject = (PGobject) rs.getObject("geolocation");
Point postgisPoint = (Point) PGgeometry.geomFromString(pGobject.getValue());

To make it work, you will need both PotgreSQL and PostGIS jars; if you use Maven or similar, note that PostGIS moved from org to net domain.

edited Mar 20, 2017 at 9:22

answered Mar 19, 2017 at 19:44

Željko Trogrlić

2,9351 gold badge20 silver badges22 bronze badges

1 Comment

Dev-iL Over a year ago

While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value. It also doesn't hurt to mention why this answer is more appropriate than others.

pik4 · Accepted Answer · 2017-10-16 12:47:03Z

1

That works for me and I think that is the proper solution.

String g = geolocation.getValue(); 
try { 
    Geometry fr = new PGgeometry().geomFromString(g); 
    Point p = fr.getPoint(0); this.geolocation = p; 
} catch (SQLException e) 
{ 
    e.printStackTrace(); 
}

answered Oct 16, 2017 at 12:47

pik4

1,3734 gold badges23 silver badges62 bronze badges

1 Comment

jspetrak Over a year ago

New there is new PGgeometry(String) constructor, but the solution still works.

Pere · Accepted Answer · 2017-12-13 15:18:10Z

0

I haven't ever used postGIS, but I bet there's probably (for most of contexts) easier solution than installing postgis jdbc driver (as Marat proposed). You can always extend the type from PGobject and add it to your connection this way:

Connection conn = Database.getConnectionFromPool(); // you probably have something like this

((org.postgresql.PGConnection)conn).addDataType("PGgeometry", (Class<? extends PGobject>) Class.forName("org.postgis.PGgeometry"));

answered Dec 13, 2017 at 15:18

Pere

1,07512 silver badges20 bronze badges

Collectives™ on Stack Overflow

ClassCastException: org.postgresql.util.PGobject cannot be cast to org.postgis.Point

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related