problem retrieving columns with type of decimal
Posted by: Tomislav Dedus
Date: April 07, 2005 05:44AM


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

Options: ReplyQuote

Written By
problem retrieving columns with type of decimal
April 07, 2005 05:44AM

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.