Tomislav Dedus wrote:
> Hi!
>
> I have a problem getting the ResultSet when colums
> with type of decimal are touched.
>
> I'm using the 3.1.7 Version of the connector and
> the new mysql 5.0.3 beta release. With the mysql
> 4.1 version anything goes the right way but with
> the 5.0.3 a simple select statement fails with
> this message:
>
> java.sql.SQLException: Unknown type '246 in column
> 4 of 64 in binary-encoded result set
>
> The problem is that the same simple statement
> (select * from somTable;) runs fine under the
> mysql console or over odbc. But with the use of
> the jdbc connector retrieving the decimal columns
> will fail. If I select only the non decimal colums
> anything is ok.
>
> Does anybody know how to solve this problem?
>
> Kind regards,
>
> Tomislav Dedus
Tomislav,
You'll need to use a nightly snapshot of Connector/J 3.1.x from
http://downloads.mysql.com/snapshots.php to retrieve the decimal types from version 5.0.3 of the server. The data type was created after the last JDBC driver was released, so Connector/J 3.1.7 doesn't have support for it.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html