MySQL Forums
Forum List  »  GIS

Re: Problems with spatial data
Posted by: Mark Matthews
Date: July 21, 2005 06:06PM

roger wrote:
> Mark,
>
> I just re-tested the issue we had in April with
> geometry data and JDBC. This time with the
> following configuration:
>
> MySQL
> 4.1.12-standard
> MySQL-AB JDBC Driver
> mysql-connector-java-3.1.10 ( $Date: 2005/05/19
> 15:52:23 $, $Revision: 1.1.2.2 $ )
>
> Still the problem exist:
>
> --------------------
> An error occured while executing the database
> request.
>
> The command that caused the error was:
> select * from test_spatial
>
> Error Details:
> Type: java.sql.SQLException
> Error Code: 0
> SQL State: S1000
>
> Error Message:
> Unknown type '255 in column 1 of 2 in
> binary-encoded result set.
> --------------------
>
> What may be wrong and are there any workaround?
>
> Regards
>
> Roger


Roger,

There's a patch pending for this (requires adding some code the driver when it unpacks binary-encoded result sets from server-side prepared statements).

Until that is released (w/ Connector/J 3.1.11), you can always disable server-side prepared statements (add useServerPrepStmts=false to the connection properties), and you shouldn't run into this issue.

-Mark

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
2480
April 26, 2005 09:38AM
2625
July 16, 2005 02:11AM
Re: Problems with spatial data
2681
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.