MySQL Forums
Forum List  »  GIS

Re: Problems with spatial data
Posted by: Mark Matthews
Date: April 26, 2005 09:38AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3630
April 26, 2005 01:00AM
Re: Problems with spatial data
2480
April 26, 2005 09:38AM
2625
July 16, 2005 02:11AM
2682
July 21, 2005 06:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.