roger wrote:
> Run the following script to create and populate a
> table in either 4.1.11 or 5.0.4 beta:
>
> use test;
> create table if not exists test_spatial (id int
> not null auto_increment primary key, geom Point
> null);
> insert into test_spatial (geom) values
> (PointFromText('Point (1.0 1.0)'));
>
> Using Connector/J 3.1.7 or 3.1.8 the following
> message is displayed when we do the following:
>
> PreparedStatement ps =
> connection.prepareStatement("select * from
> test_spatial");
> ps.execute();
>
> "Unknown type '255 in column 1 of 2 in
> binary-encoded result set."
>
> Connector/J 3.0.16 works fine, but it does not
> support the new DBMS features of 4.1 and 5.0
>
> What may be wrong?
>
> Roger
Roger, it looks like we need to add that type mapping to the driver. Before, spatial data was just returned as byte[]s, I guess that changed in the server and we missed it.
The fix will go into Connector/J 3.1.9.
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html