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