Re: [Jaspa-users] Questions

[Jose C. M. L. <jom...@cg...>]

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