Ok! Finally i found solution! The problem lies here:
java.sql.SQLException: Invalid value for getFloat() - ' ' in column 2
Somewhere in database stored an empty string. MySQL JDBC driver tries to get that value as float and fails in com.mysql.jdbc.ResultSetImpl.java getFloatFromString method
I've got that drivers sources and modified, the code listed below works:
private final float parseFloatSkipErrors(String val)
{
try
{
return Float.parseFloat(val);
}
catch (NumberFormatException ex)
{
return 0.0f;
}
}
private final double parseDoubleSkipErrors(String val)
{
try
{
return Double.parseDouble(val);
}
catch (NumberFormatException ex)
{
return 0.0f;
}
}
private final float getFloatFromString(String val, int columnIndex)
throws SQLException {
try {
if ((val != null)) {
if (val.length() == 0) {
return convertToZeroWithEmptyCheck();
}
float f = parseFloatSkipErrors(val);
if (this.jdbcCompliantTruncationForReads) {
if (f == Float.MIN_VALUE || f == Float.MAX_VALUE) {
double valAsDouble = parseDoubleSkipErrors(val);
// Straight comparison is not reliable when at
// absolute endpoints of Float.MIN_VALUE or
// Float.MAX_VALUE, so use epsillons with DOUBLEs
if ((valAsDouble < Float.MIN_VALUE - MIN_DIFF_PREC)
|| (valAsDouble > Float.MAX_VALUE - MAX_DIFF_PREC)) {
throwRangeException(String.valueOf(valAsDouble), columnIndex,
Types.FLOAT);
}
}
}
return f;
}
return 0; // for NULL
} catch (NumberFormatException nfe) {
try {
Double valueAsDouble = parseDoubleSkipErrors(val);
float valueAsFloat = valueAsDouble.floatValue();
if (this.jdbcCompliantTruncationForReads) {
if (this.jdbcCompliantTruncationForReads &&
valueAsFloat == Float.NEGATIVE_INFINITY ||
valueAsFloat == Float.POSITIVE_INFINITY) {
throwRangeException(valueAsDouble.toString(),
columnIndex, Types.FLOAT);
}
}
return valueAsFloat;
} catch (NumberFormatException newNfe) {
; // ignore, it's not a number
}
throw SQLError.createSQLException(
Messages
.getString("ResultSet.Invalid_value_for_getFloat()_-____200")
+ val //$NON-NLS-1$
+ Messages.getString("ResultSet.___in_column__201")
+ columnIndex, SQLError.SQL_STATE_ILLEGAL_ARGUMENT, getExceptionInterceptor()); //$NON-NLS-1$
}
}
All issues will be imported, but importer plugin is very raw. It doesn't maps custom things
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.