jaspa-users Mailing List for Jaspa
Spatial extension for relational database system. Follows OGC standars
Brought to you by:
jomarlla
Menu
▾
▴
jaspa-users — Jaspa users mailing list
You can subscribe to this list here.
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2012 |
Jan
(5) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
|
From: Simon G. <si...@sp...> - 2012-10-23 06:42:43
|
Jose, > At this moment there is no planned any jaspa release. We already developed the Oracle port (Marta) and H2 driver for gvsig (UOC), but we >havent tested still and make documentation. I hope before next summer I can make it but so far Im too busy with other projects. OK > As you said MySQL does not support java stored procedures so Jaspa can not be ported to MySQL. You can use JDBC to get/store a binary >type from MySQL (BLOB) and then use the Jaspa functions to serialize/deserialize to/from java objects in order to developed a client >application. In the server side maybe the library GEOS and PostGIS code can help you with the WKB/EWKB writers/readers because its c++. The MySQL binary format appears to be WKB but with Bytes 00-03 containing the SRID. So, I guess, if I got the blob in Jaspa I would strip out the first 4 bytes and give the rest to your converter. regards Simon > > > best, > Jose > > > On 20/10/2012 23:39, Simon Greener wrote: >> Jose, >> >> Any new releases imminent? >> >> I am looking for some Java to read the MySQL geometry binary format directly. >> >> I came across this: http://www.mj10777.de/cgi-bin/fossil/qgeomcoll/doc/tip/wiki/Database_Formats/>>Internal_Geometry_Format_MySql.wiki >> >> While I am aware that one cannot deploy Java into MySQL database, I note that Jaspa has some rich classes for dealing with >>binary WKB etc. How difficult would it be to create a reader/writer using Jaspa code for MySQL as MySQL's format looks close >>to WKB? If possible, but you don't want to do it, could you give me some pointers as to what classes I would have to >>implement in Jaspa to be able to read/write MySQL? >> >> 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 > > -- 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 |
|
From: Jose C. M. L. <jom...@cg...> - 2012-10-21 09:22:34
|
Hi Simon, At this moment there is no planned any jaspa release. We already developed the Oracle port (Marta) and H2 driver for gvsig (UOC), but we havent tested still and make documentation. I hope before next summer I can make it but so far Im too busy with other projects. As you said MySQL does not support java stored procedures so Jaspa can not be ported to MySQL. You can use JDBC to get/store a binary type from MySQL (BLOB) and then use the Jaspa functions to serialize/deserialize to/from java objects in order to developed a client application. In the server side maybe the library GEOS and PostGIS code can help you with the WKB/EWKB writers/readers because its c++. best, Jose On 20/10/2012 23:39, Simon Greener wrote: > Jose, > > Any new releases imminent? > > I am looking for some Java to read the MySQL geometry binary format > directly. > > I came across this: > http://www.mj10777.de/cgi-bin/fossil/qgeomcoll/doc/tip/wiki/Database_Formats/Internal_Geometry_Format_MySql.wiki > > While I am aware that one cannot deploy Java into MySQL database, I > note that Jaspa has some rich classes for dealing with binary WKB etc. > How difficult would it be to create a reader/writer using Jaspa code > for MySQL as MySQL's format looks close to WKB? If possible, but you > don't want to do it, could you give me some pointers as to what > classes I would have to implement in Jaspa to be able to read/write MySQL? > > 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 |
|
From: Simon G. <si...@sp...> - 2012-10-20 21:40:10
|
Jose, Any new releases imminent? I am looking for some Java to read the MySQL geometry binary format directly. I came across this: http://www.mj10777.de/cgi-bin/fossil/qgeomcoll/doc/tip/wiki/Database_Formats/Internal_Geometry_Format_MySql.wiki While I am aware that one cannot deploy Java into MySQL database, I note that Jaspa has some rich classes for dealing with binary WKB etc. How difficult would it be to create a reader/writer using Jaspa code for MySQL as MySQL's format looks close to WKB? If possible, but you don't want to do it, could you give me some pointers as to what classes I would have to implement in Jaspa to be able to read/write MySQL? 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 |
|
From: Simon G. <si...@sp...> - 2012-01-12 01:26:40
|
Carlos,
>> OK, look I have been working on exposing JTS in Oracle's JVM now for quite a while. I am doing it more directly looking a functionality
>> that complements or fills gaps in the Oracle stack rather than any theoretically complete OGC/SFS compliant API. The results of my work
>> are documented on my website under what is called the GEOPROCESS PL/SQL package. I have actually renamed this to JTS and added
>> in a lot more functionality. It is ready to go up on my site to replace GEOPROCESS but it may not happen till next week. Still, GEOPROCESS
>> gives you a feel for what I have done.
> Thats good to know Simon, I think Marta already learned things from your blog about oracle. Im gonna meet her maybe tomorrow or Friday to see her work. She already told me though that at the beginning she started with Oracle 10.2 and java >1.4 but she changed to oracle 11 because she had problems with Jaspa, probably because java 1.5
Looking at Jaspa and its dependence on JTS I can see that there are really very few uses of Java 1.5 in its code that could not be easily converted back to 1.4.
This may not optimal for the future, but I still have lots of customers still on 10gR2 (all my Java/JTS code/packaging works fine on 10gR2 and 11gR2). Also,
this is a bit moot until JTS finally moves away from 1.4.
>> What are your plans for circular arc and geodetic support given that JTS doesn't support either?
>>
> Geodetic support is very attractive research for me, specially because my mayor is Engineering in Geodesy and Cartography but before trying to implement Geodetic support in a serious way Jaspa must implement a tolerance system, as cluster in >ArcGIS. Unfortunately PostGIS does not implement a tolerance system either and its incredible!!
>
> I think Martin Davis is working in geodetic support in JTS but JTS does not support tolerance system either.
Geodetic is very important. Currently I tell people to project to something planar, do the work, then project back. It would be nice not to have to do this.
My Geodesy knowledge (three years at Uni ending up with Geodesy III which was about the math keeping satellites in the sky!) is now 30 years old. I might
have gotten High Distinctions for all three years but I can't remember diddly squat. So, over to you!
>
>> (Aside: How is it that PostGIS etc all seem to use JTS/GEOS but from that basis extend to support circular arcs etc but don't work to help JTS/GEOS get that support?)
> The support of PostGIS with curve geometries is very limited. In fact, if you wanna use the main spatial functionality you have to convert from and to curve geometries. It does not make sense for me.In my opinion PostGIS project should have funded a lot the JTS project because the JTS project is the PostGIS Core.
It has been limited for quite a while. Oracle's support is not all that good but it appears a little better than the others. SQL Server Spatial Denali, from a cursory look, looks pretty good.
> The only other changes I needed to make (for 1.4 compliance as JTS is 1.4 compliant) were to change things like List<Geometry> ... to List and add in casts when needed. This was actually very simple to do as JASPA
> doesn't seem to use LinkedHashMaps etc with key/value typing. The only pain is:
>
> public static <U> U[] removeNulls(U array[]) {
I would prefer to keep going with Oracle 11 and not change the Jaspa code about using java 1.4. I remember that I changed many methods with parametric types as List. e. g.: List <Geometry> list = ...
The latter List<Geometry> aren't a problem. (Pity Java doesn't have conditional compilation.) It is things like above that I don't understand how to code in 1.4. Also, LinkedHashMap<String,Geometry>
cannot be easily implemented in 1.4.
> I would be happy to change the code for you in agreed areas but only once the Oracle integration has occurred. Also, I am happy to offer to test Marta's work if you are interested.Perhaps once Marta is finished I could be involved as the maintainer of this branch of the code? But isn't one thing about JASPA to offer an alternate type system to Oracle (BTW
> aggregates with Java in Oracle are awful!) My needs are for a solution that is about integration.
>
> Happy to keep talking or get involved in any way you are comfortable with.
We are happy too you can get involved in the Jaspa project. When Marta finishes her work (I think soon), we will send it to you and we will keep talking about that.
Marta is going to start working in a company so probably no one is going to maintain the Oracle branch code, so you are very welcome.
OK. Let's see what happens when we get there.
I will talk to Marta about testing her project too.
Again, OK. Happy help.
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 |
|
From: Jose C. M. L. <jom...@cg...> - 2012-01-11 20:07:08
|
Hi Simon,
On 11/01/2012 2:56, Simon Greener wrote:
> Jose,
>
> Hi Simon, I know you because of the mailing list and your great
> blog.
>
>
> Most kind. I know this is hard to believe but I get little recognition
> for what I do so it is nice to hear it.
> I am actually quite ready to move to another database like PostGIS but
> there is so little work in that space
> in Australia. SQL Server Spatial is my other option mainly because of
> the amount of installs in Oz. Working
> with Oracle is awful.
>
>> 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.
> Marta Gonzales who has worked with me in the jaspa project is
> working now about porting Jaspa to Oracle 11g in her Master
> thesis. She has already done a good job about that using the
> spatial indexes and migrating most of the jaspa functionality. I
> dont know exactly the current status of her work but the idea is
> to add it to the jaspa release.
>
> Marta is you read this email maybe you can give some details
> about your work to Simon.
>
>
> OK, look I have been working on exposing JTS in Oracle's JVM now for
> quite a while. I am doing it more directly looking a functionality
> that complements or fills gaps in the Oracle stack rather than any
> theoretically complete OGC/SFS compliant API. The results of my work
> are documented on my website under what is called the GEOPROCESS
> PL/SQL package. I have actually renamed this to JTS and added
> in a lot more functionality. It is ready to go up on my site to
> replace GEOPROCESS but it may not happen till next week. Still, GEOPROCESS
> gives you a feel for what I have done.
Thats good to know Simon, I think Marta already learned things from your
blog about oracle. Im gonna meet her maybe tomorrow or Friday to see her
work. She already told me though that at the beginning she started with
Oracle 10.2 and java 1.4 but she changed to oracle 11 because she had
problems with Jaspa, probably because java 1.5
The Jaspa idea about Oracle was to avoid some people to pay oracle
spatial license and use Jaspa instead of it.
>
>
>> *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?
> yes, you are right, jaspa has modified JTS but just a little bit
> like the one you found out or a few methods. I dont think the
> changes are useful for every jts users thats why I didnt even ask
> Martin Davis about that.
>
>
> It is very important that you do merge this back into JTS. One major
> issue I have with GeoTools/JTS is the handling of 3 and 4D geometies,
> never mind the bigger issues of circular curve and geodetic support.
>
> As part of my GeoRaptor work exporting Oracle data to shapefiles, I
> looked at the conversion from GeoTools to JTS and back again for
> Oracle because it does not handle measures.
> To be honest, even though I am not a vastly experienced profesional
> and full-time Java programmer I wasn't impressed with the code. It
> didn't just need a fix for the measures it needed a complete
> re-write. I started work on the "fix" with Jody Garnett but I lost
> interest for a bunch of reasons.
>
> Perhaps JASPA is the better framework in which to get Oracle/JTS
> integration working.
>
> What are your plans for circular arc and geodetic support given that
> JTS doesn't support either?
>
Geodetic support is very attractive research for me, specially because
my mayor is Engineering in Geodesy and Cartography but before trying to
implement Geodetic support in a serious way Jaspa must implement a
tolerance system, as cluster in ArcGIS. Unfortunately PostGIS does not
implement a tolerance system either and its incredible!!
I think Martin Davis is working in geodetic support in JTS but JTS does
not support tolerance system either.
> (Aside: How is it that PostGIS etc all seem to use JTS/GEOS but from
> that basis extend to support circular arcs etc but don't work to help
> JTS/GEOS get that support?)
The support of PostGIS with curve geometries is very limited. In fact,
if you wanna use the main spatial functionality you have to convert from
and to curve geometries. It does not make sense for me.
In my opinion PostGIS project should have funded a lot the JTS project
because the JTS project is the PostGIS Core.
>
> *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.
> I think you are right about formal casting/conversion, it was just
> for writing less code. You are talking just about the returning
> values or you found any other problem with java 1.4 and Oracle?
> Anyways this project is mainly maintained by me and I dont think i
> can change the source code a lot right now because lack of time.
> For the next release I can change the casting as you suggested if
> you think this is really worth it.
>
>
> It is not a difficult thing to do. Mainly it is because of JASPA's use
> of class data types like Integer whereas JTS uses the primitive types
> like int. So, yes, I suggest you make the change.
>
> The only other changes I needed to make (for 1.4 compliance as JTS is
> 1.4 compliant) were to change things like List<Geometry> ... to List
> and add in casts when needed. This was actually very simple to do as JASPA
> doesn't seem to use LinkedHashMaps etc with key/value typing. The only
> pain is:
>
> public static <U> U[] removeNulls(U array[]) {
>
I would prefer to keep going with Oracle 11 and not change the Jaspa
code about using java 1.4. I remember that I changed many methods with
parametric types as List. e. g.: List <Geometry> list = ...
> I would be happy to change the code for you in agreed areas but only
> once the Oracle integration has occurred. Also, I am happy to offer to
> test Marta's work if you are interested.
> Perhaps once Marta is finished I could be involved as the maintainer
> of this branch of the code? But isn't one thing about JASPA to offer
> an alternate type system to Oracle (BTW
> aggregates with Java in Oracle are awful!) My needs are for a solution
> that is about integration.
>
> Happy to keep talking or get involved in any way you are comfortable with.
We are happy too you can get involved in the Jaspa project. When Marta
finishes her work (I think soon), we will send it to you and we will
keep talking about that.
Marta is going to start working in a company so probably no one is
going to maintain the Oracle branch code, so you are very welcome.
I will talk to Marta about testing her project too.
Regards,
>
> 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
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
>
>
> _______________________________________________
> Jaspa-users mailing list
> Jas...@li...
> https://lists.sourceforge.net/lists/listinfo/jaspa-users
|
|
From: Simon G. <si...@sp...> - 2012-01-11 01:56:26
|
Jose,
> Hi Simon, I know you because of the mailing list and your great blog.
Most kind. I know this is hard to believe but I get little recognition for what I do so it is nice to hear it.
I am actually quite ready to move to another database like PostGIS but there is so little work in that space
in Australia. SQL Server Spatial is my other option mainly because of the amount of installs in Oz. Working
with Oracle is awful.
>
>> 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.
> Marta Gonzales who has worked with me in the jaspa project is working now about porting Jaspa to Oracle 11g in her Master thesis. She has already done a good job about that using the spatial indexes and migrating most of the jaspa functionality. I dont know exactly the current status >of her work but the idea is to add it to the jaspa release.
> Marta is you read this email maybe you can give some details about your work to Simon.
OK, look I have been working on exposing JTS in Oracle's JVM now for quite a while. I am doing it more directly looking a functionality
that complements or fills gaps in the Oracle stack rather than any theoretically complete OGC/SFS compliant API. The results of my work
are documented on my website under what is called the GEOPROCESS PL/SQL package. I have actually renamed this to JTS and added
in a lot more functionality. It is ready to go up on my site to replace GEOPROCESS but it may not happen till next week. Still, GEOPROCESS
gives you a feel for what I have done.
>
>> 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?
> yes, you are right, jaspa has modified JTS but just a little bit like the one you found out or a few methods. I dont think the changes are useful for every jts users thats why I didnt even ask Martin Davis about that.
It is very important that you do merge this back into JTS. One major issue I have with GeoTools/JTS is the handling of 3 and 4D geometies, never mind the bigger issues of circular curve and geodetic support.
As part of my GeoRaptor work exporting Oracle data to shapefiles, I looked at the conversion from GeoTools to JTS and back again for Oracle because it does not handle measures.
To be honest, even though I am not a vastly experienced profesional and full-time Java programmer I wasn't impressed with the code. It didn't just need a fix for the measures it needed a complete
re-write. I started work on the "fix" with Jody Garnett but I lost interest for a bunch of reasons.
Perhaps JASPA is the better framework in which to get Oracle/JTS integration working.
What are your plans for circular arc and geodetic support given that JTS doesn't support either?
(Aside: How is it that PostGIS etc all seem to use JTS/GEOS but from that basis extend to support circular arcs etc but don't work to help JTS/GEOS get that support?)
> 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 bebetter than compiler based conversion? But I have to admit I am not a vastly experienced Java programmer. When going from Oracle'sPL/SQL to the JVM I use primitive types.
> I think you are right about formal casting/conversion, it was just for writing less code. You are talking just about the returning values or you found any other problem with java 1.4 and Oracle?
> Anyways this project is mainly maintained by me and I dont think i can change the source code a lot right now because lack of time. For the next release I can change the casting as you suggested if you think this is really worth it.
It is not a difficult thing to do. Mainly it is because of JASPA's use of class data types like Integer whereas JTS uses the primitive types like int. So, yes, I suggest you make the change.
The only other changes I needed to make (for 1.4 compliance as JTS is 1.4 compliant) were to change things like List<Geometry> ... to List and add in casts when needed. This was actually very simple to do as JASPA
doesn't seem to use LinkedHashMaps etc with key/value typing. The only pain is:
public static <U> U[] removeNulls(U array[]) {
I would be happy to change the code for you in agreed areas but only once the Oracle integration has occurred. Also, I am happy to offer to test Marta's work if you are interested.
Perhaps once Marta is finished I could be involved as the maintainer of this branch of the code? But isn't one thing about JASPA to offer an alternate type system to Oracle (BTW
aggregates with Java in Oracle are awful!) My needs are for a solution that is about integration.
Happy to keep talking or get involved in any way you are comfortable with.
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 |
|
From: Jose C. M. <jom...@cg...> - 2012-01-10 10:44:37
|
Hi Simon, I know you because of the mailing list and your great blog.
On 10/01/2012 3:53, Simon Greener wrote:
> 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.
Marta Gonzales who has worked with me in the jaspa project is working
now about porting Jaspa to Oracle 11g in her Master thesis. She has
already done a good job about that using the spatial indexes and
migrating most of the jaspa functionality. I dont know exactly the
current status of her work but the idea is to add it to the jaspa release.
Marta is you read this email maybe you can give some details about your
work to Simon.
>
> *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?
yes, you are right, jaspa has modified JTS but just a little bit like
the one you found out or a few methods. I dont think the changes are
useful for every jts users thats why I didnt even ask Martin Davis about
that.
>
> *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.
I think you are right about formal casting/conversion, it was just for
writing less code. You are talking just about the returning values or
you found any other problem with java 1.4 and Oracle?
Anyways this project is mainly maintained by me and I dont think i can
change the source code a lot right now because lack of time. For the
next release I can change the casting as you suggested if you think this
is really worth it.
Regards,
Jose
>
> 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
>
>
> ------------------------------------------------------------------------------
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create
> new or port existing apps to sell to consumers worldwide. Explore the
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
>
>
> _______________________________________________
> Jaspa-users mailing list
> Jas...@li...
> https://lists.sourceforge.net/lists/listinfo/jaspa-users
|
|
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 |
|
From: Jose C. M. <jom...@cg...> - 2011-12-28 15:37:10
|
Testing the new list, sorry about the inconveniences. |
|
From: Jose M. <jcl...@gm...> - 2011-12-28 15:24:49
|
This testing email from gmail. cheers, |
