Re: MySQL Spatial Data types

From: Aristedes Maniatis (ar..sh.com.au)
Date: Sun Aug 10 2008 - 22:54:41 EDT

  • Next message: Tore Halset: "Re: MySQL Spatial Data types"

    On 11/08/2008, at 12:23 PM, Rick Blair wrote:

    > I have an existing mysql (5.1) database that has a column named
    > location
    > that is a POINT datatype. I used the DataModeler and attached to my
    > database. I was able to use my existing schema, however the data
    > type in
    > the Modeler for that column show as OTHER. The class that was
    > generated was
    > had the following methods:

    I haven't used them myself, but you may need to use something like JTS
    (http://www.vividsolutions.com/JTS) to get these data types across
    JDBC into Cayenne. And then some customisation of the mysql database
    adapter [1] might be needed.

    Ari

    [1] http://fisheye6.atlassian.com/browse/cayenne/trunk/framework/cayenne-jdk1.5-unpublished/src/main/java/org/apache/cayenne/dba/mysql

    -------------------------->
    ish
    http://www.ish.com.au
    Level 1, 30 Wilson Street Newtown 2042 Australia
    phone +61 2 9550 5001 fax +61 2 9550 4001
    GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

    This archive was generated by hypermail 2.0.0 : Sun Aug 10 2008 - 22:58:37 EDT