View Issue Details

IDProjectCategoryView StatusLast Update
0000541SymmetricDSImprovementpublic2012-01-05 06:43
ReporterAssigned To 
Status closedResolutionfixed 
Product Version2.5.0 
Target Version2.5.8Fixed in Version2.5.8 
Summary0000541: Support GeoSpatial data type (SDO_GEOMETRY) in oracle spatial
Description"symmetricds didn't support Geometry datatype in postgresql+postgis environment and oracle. in database, geoemtry datatype alwayse store as binary format(in postgresql is WKB), when create sym_data sql, symmetricds throw errors and report can't process geometry data. My proposal is transform the binary to text(WKT, a text format to present geometry type) 1. add a ""geometryColumnTemplate"" node in postgresql.xml and oracle.xml 2. process the geometry column in org.jumpmind.symmetric.db.SqlTemplate class I post those files i have modified (search ""WuSheng patched""). hope this can do some help."


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change