wallace_tobin wrote:
> I am using a free download of MYSQL 5.0.18 which is supposed to
> support Geometric data types. I'm able to create the geometry column
> within the MySQL table as well as a spatial index for it however when
> I attempt to populate the table using FME I keep getting an error on
> the following:
>
> Error executing SQL query ('CREATE TABLE `root.ATSQTRS` (`ATSQTRID`
> int PRIMARY KEY,`MER` int,`QTR` char(2),`QTRID` int,`RGE` int,`SEC`
> int,`TWP` int,`TWPID` int,`QTRSHAPE` GEOMETRY)
> ENGINE=MYISAM'): 'Incorrect table name 'root.ATSQTRS''.
> Successfully closed MYSQL database writer.
> Writer failed in open() call.
> Writer failed in open() call.
>
> Is this due to a licensing problem? Do I require a specfic MySQL FME
> extension to get this to work? All that I am doing is mapping the
> contents of a shape file into FME and storing a polygon shape into
> the geometry column of the MySQL table. Can someone point me in the
> right direction for help on using this feature.
I never had any trouble using the MySQL reader/writer. If it shows up in
your formats list, you have the correct FME version for it.
Check the properties of the MySQL output feature, there should be an
option there that says "Table Exists". Based on what you're writing, it
sounds as if you have already created the table and then FME tries to do
that as well.
Hope this helps...
--
Hans van der Maarel
Red Geographics
www.redgeographics.com / [EMAIL PROTECTED]
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
