Hello.
(cc to [EMAIL PROTECTED] so this show up in the archive)
The DB-side of your mapping should have geometry, varchar or clob as
datatype. The java-side should have
"com.vividsolutions.jts.geom.Geometry" or any of the subclasses like
"com.vividsolutions.jts.geom.Point". Is that how you did it?
If you use a cayenne-2 or cayenne-1, then you need to register the
type, not only to Geometry, but all subclasses you want to use.
ExtendedTypeMap extendedTypes = node.getAdapter().getExtendedTypes();
extendedTypes.registerType(new WKTGeometryType(Point.class));
I hope it helps.
Regards,
- Tore.
On Aug 16, 2008, at 00:26, Rick Blair wrote:
Hi Tor,
I must be missing something. I cannot get the WKT type handler to be
called. I followed the example from the URL, but the handler is never
called.
I tried setting the type of the property to geometry, binary, blob and
varchar in the map.xml file.
Suggestions?
Thanks in advance.
--
Tìoraidh!
Rick Blair
Associate Technical Fellow
Boeing Phantom Works
Network Systems Technology
Information Management Program
M/S: 42-50
Voice: (206) 544-1610
From: Tore Halset <[EMAIL PROTECTED]>
Reply-To: <[email protected]>
Date: Mon, 11 Aug 2008 07:02:57 +0200
To: <[email protected]>
Subject: Re: MySQL Spatial Data types
On 11. aug.. 2008, at 04.54, Aristedes Maniatis wrote:
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.
Here is an example how to convert between WKT in a database and JTS
geomertries on the java side. You may have to modify it to let MySQL
convert the POINT datatype from/to WKT.
http://cwiki.apache.org/CAY/mapping-jts-geometries.html
I am using this in production, but not with MySQL.
Regards,
- Tore.
