INSERT INTO d_road_cross (id, the java.awt.geom) VALUES (' 1 ', 'ST_GeomFromText (' POINT (112.96041205 22.77140611), 4326)')

The kettle is spooled SQL, the back of the data type can only be defined as a string, afterward there will be a single quotes, lead to insert is not successful, no geometry in kette type, how to solve?

CodePudding user response:

Kettle with gis plug-ins, geospatial plug-in for it