Re: [Jaspa-users] Questions

[Simon G. <si...@sp...>]

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