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
