> 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
> 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
> "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, it looks like we need to add that type mapping to the driver. Before, spatial data was just returned as bytes, I guess that changed in the server and we missed it.
The fix will go into Connector/J 3.1.9.
Consulting Member Technical Staff - MySQL Enterprise Tools