> > I see that the MySQLDataStore.createSchema(featureType) method hasn't been
> > implemented yet, so i will need to create appropriate tables in the db
> > manually. I'm assuming this requires tables with the same names as the type
> > names of the different features, and that each table must contain columns
> > with the same names as the attributes of that feature type. However, i can't
> > find any info on what sort of structure i need to create in the database to
> > store the geometry info in. At the moment i get the message "SQL Exception
> > writing geometry column", which isn't surprising as i haven't created a
> > geometry column (i did try making a column in the table called 'geometry'
> > but this didn't work). Any help much appreciated...
> I have not yet tried out the mysql datasource, and I don't have time to
> really answer your question. But one thing to note is that the mysql
> datastore only works with MySQL 4.1 as far as I know. 4.1 added OGC style
> geometry types, from the Simple Features for SQL spec. Part of this spec
> is the geometry_columns - they should be there automatically. If you're
> not using 4.1 then you will probably get a lot of weird errors. Gary
> wrote the mysql module, so he should be able to answer your questions
> better than I.
I am able to use MySQLDataStore with both MySQL 3.23 and MySQL 4.1. Geometric
datatypes are new to MySQL 4.1, and if you have MySQL 4.1, please see the
following pages on MySQL's website for more information on creating geometric
columns and values:
Even if you're not using MySQL 4.1, MySQLDataStore should still work for tables
that have a primary key (tables that can be interpreted as features). I'll be
happy to send along some sample code if anyone would like it.