[Jaspa-users] Questions
Spatial extension for relational database system. Follows OGC standars
Brought to you by:
jomarlla
|
From: Simon G. <si...@sp...> - 2012-01-10 02:54:02
|
Jaspa Users,
I have a question. I am looking at either porting JASPA to Oracle to work in conjunction with SDO_GEOMETRY
or to pull out particular methods for use on their own augmenting Oracle Sdo_Geometry functionality.
Firstly, I note that Jaspa appears to have its own version of JTS as its definition of Coordinate.java includes a measure.
I am currently working with JTS1.12 and its Coordinate.java does not have a measure ordinate. Is this the case? How deep
do the changes go? Is there a plan to fold them back into JTS?
Secondly, I prefer to work with Java 1.4 as Oracle 10gR2 is 1.4 and only 11g is 1.5. All in all this doesn't look too difficult an issue
if I pull out functions but more so if I work with Jaspa as a whole.
Thirdly, JASPA seems to allow for auto conversion of primitive ints to Integers, boolean to Boolean in its functions .... when moving
back to an earlier JVM it is a pain because one has to do formal conversions eg
public static Double ST_Area(Geometry geom) {
if (Core.isNullGeometry(geom)) return null;
return geom.getArea();
}
public static Double ST_Area(Geometry geom) {
if (Core.isNullGeometry(geom)) return null;
return new Double(geom.getArea()) ;
}
I can see why one might use class types over the primitive types but wouldn't more formal casting/conversion from JTS to JASPA be
better than compiler based conversion? But I have to admit I am not a vastly experienced Java programmer. When going from Oracle's
PL/SQL to the JVM I use primitive types.
That is all for now.
regards
Simon
--
Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: si...@sp...
Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3 |