如何使用sql2o从具有Geometry类型的表中检索java对象

<dependency>
    <groupId>org.sql2o</groupId>
    <artifactId>sql2o</artifactId>
    <version>1.6.0</version>
</dependency>

String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";

Connection connection = new MySqlConnection(url, username, password);

Sql2o sql2o = new Sql2o(connection);

import com.vividsolutions.jts.geom.Geometry;

public class Location {
    private int id;
    private Geometry geometry;

    // Getters and setters
}

String query = "SELECT id, geometry FROM locations";
List<Location> locations = sql2o.createQuery(query)
        .addColumnMapping("geometry", "geometry")
        .executeAndFetch(Location.class);