Today at our firm was problem like as "Unknown type '246 in column 2 of 3 in binary-encoded result set" when selected table has column as decimal(10, 2) type. This errors cause because we use old version of mysql jdbc driver. Solution for this problem is:
- Download new version of driver
-
Convert double column to char on selection.
SELECT CAST(your_column AS char(15)) your_column FROM your_table;
So in this case on java side u can get it as Double again.
Cheap Wildcard SSL - Cheap SSL certificates (including wildcard and multi-domain (SAN) SSL certificates) from Comodo, GeoTrust, Thawte and Symantec (VeriSign)
ReplyDelete