MySQL Forums
Forum List  »  GIS

Re: java access of gis data via mysql-connector
Posted by: Mark Matthews
Date: September 12, 2005 12:30PM

Mark Johnson wrote:
> To all:
>
> Just wading into the GIS arena within MySql. We
> use java with mysql and the mysql-connector and
> openMap.
>
> OpenMap provides a layer.mysql that has a number
> of MySql GIS datatypes.
>
> It would seem that mysql-connector would have
> correspnding datatypes, such as LineString.
>
> How does one obtain a linestring from the database
> ? Is it necessary to convert it to a WKT string
> and then back into a binary datatype?

Mark,

JDBC doesn't specify any mapping for GIS types, so the JDBC driver doesn't support them "natively". Until such time as JDBC and or the JDK actually ship with support for GIS, you'll have to rely on third-party support (such as OpenMAP), as it would create too many dependencies in the JDBC driver to ship with GIS support out-of-the-box.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: java access of gis data via mysql-connector
2785
September 12, 2005 12:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.