From: Andrea A. <and...@ge...> - 2011-05-29 08:24:12
|
On Sun, May 29, 2011 at 2:16 AM, Jiri Novak <nov...@gm...> wrote: > Based on pieces of advice I found in other threads of this email list I > managed to export to PostGIS without any problem. Nevertheless, when I > change my dependencies back to oracle libraries, I manage to get exported > all of the attributes data, but the_geom collumn which remains null. And > there is still the warning causing all the troubles: > > May 28, 2011 9:02:36 PM org.geotools.jdbc.JDBCDataStore getMapping > WARNING: No mapping for com.vividsolutions.jts.geom.Point > > Am I missing some additional jar dependency? It seems to me that there is > some problem with OracleDialect class inicialization, but I have no clue > where and why :( Oracle forces all the attributes to uppercase, you have to compensate for that when doing the copy. The attached class did work for me in the past, though it may need to be updated a bit to follow the last api changes. Generally speaking you cannot pretend the schema created in the target store to follow the structure you asked for, depending on the target abilities there may be changes in the names, types and position of the attributes. Oracle cannot have lowercase attributes, shapefile has just one geometry, it's the first attribute as it's called "the_geom", SDE will prefix the type name with some schema bit and so on. Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- |