MySQL Forums
Forum List  »  GIS

Problems with spatial data
Posted by: roger
Date: April 26, 2005 01:00AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems with spatial data
3877
April 26, 2005 01:00AM
2614
April 26, 2005 09:38AM
2763
July 16, 2005 02:11AM
2902
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.