关于SqlRowSet的Invalid scale size. Cannot be less than zero异常

男娘i 2022-08-27 06:52 190阅读 0赞

转载于：[http://blog.csdn.net/horsefaced/archive/2007/08/16/1746888.aspx][http_blog.csdn.net_horsefaced_archive_2007_08_16_1746888.aspx]

首先，非常鄙视ResultSet这个东东的列索引居然是从1开始的这个事情。 这个异常源自于oracle驱动面对一个数值型的返回字段时，在得到指定的字段小数点右边的数值数量时（Gets the designated column's number of digits to right of the decimal point.这个是原文），居然会返回-127，而oracle本身的cacheRowSet实现不允许这种情况出现，于是就会报标题所说的异常。 在GOOGLE之后，唉，使用了 http://forum.java.sun.com/thread.jspa?threadID=569712 中[Pedrinho][]的解决方法建立了两个对ResultSet与ResultSetMetaData接口的decorate类，这两个类内容无它，极其无聊，建议所有人都不要看。 这个是ResultSet的decorate类： import java.io.InputStream; import java.io.Reader; import java.math.BigDecimal; import java.net.URL; import java.sql.Array; import java.sql.Blob; import java.sql.Clob; import java.sql.Date; import java.sql.Ref; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.SQLWarning; import java.sql.Statement; import java.sql.Time; import java.sql.Timestamp; import java.util.Calendar; import java.util.Map; public class ResultSetWrapper implements ResultSet \{   private ResultSet wrapped;   public ResultSetWrapper(ResultSet wrapped) \{     this.wrapped = wrapped;   \}   public boolean absolute(int row) throws SQLException \{     return wrapped.absolute(row);   \}   public void afterLast() throws SQLException \{     wrapped.afterLast();   \}   public void beforeFirst() throws SQLException \{     wrapped.beforeFirst();   \}   public void cancelRowUpdates() throws SQLException \{     wrapped.cancelRowUpdates();   \}   public void clearWarnings() throws SQLException \{     wrapped.clearWarnings();   \}   public void close() throws SQLException \{     wrapped.close();   \}   public void deleteRow() throws SQLException \{     wrapped.deleteRow();   \}   public int findColumn(String columnName) throws SQLException \{     return wrapped.findColumn(columnName);   \}   public boolean first() throws SQLException \{     return wrapped.first();   \}   public Array getArray(int i) throws SQLException \{     return wrapped.getArray(i);   \}   public Array getArray(String colName) throws SQLException \{     return wrapped.getArray(colName);   \}   public InputStream getAsciiStream(int columnIndex) throws SQLException \{     return wrapped.getAsciiStream(columnIndex);   \}   public InputStream getAsciiStream(String columnName) throws SQLException \{     return wrapped.getAsciiStream(columnName);   \}   public BigDecimal getBigDecimal(int columnIndex) throws SQLException \{     return wrapped.getBigDecimal(columnIndex);   \}   public BigDecimal getBigDecimal(String columnName) throws SQLException \{     return wrapped.getBigDecimal(columnName);   \}   public BigDecimal getBigDecimal(int columnIndex, int scale)       throws SQLException \{     return wrapped.getBigDecimal(columnIndex, scale);   \}   public BigDecimal getBigDecimal(String columnName, int scale)       throws SQLException \{     return wrapped.getBigDecimal(columnName, scale);   \}   public InputStream getBinaryStream(int columnIndex) throws SQLException \{     return wrapped.getBinaryStream(columnIndex);   \}   public InputStream getBinaryStream(String columnName) throws SQLException \{     return wrapped.getBinaryStream(columnName);   \}   public Blob getBlob(int i) throws SQLException \{     return wrapped.getBlob(i);   \}   public Blob getBlob(String colName) throws SQLException \{     return wrapped.getBlob(colName);   \}   public boolean getBoolean(int columnIndex) throws SQLException \{     return wrapped.getBoolean(columnIndex);   \}   public boolean getBoolean(String columnName) throws SQLException \{     return wrapped.getBoolean(columnName);   \}   public byte getByte(int columnIndex) throws SQLException \{     return wrapped.getByte(columnIndex);   \}   public byte getByte(String columnName) throws SQLException \{     return wrapped.getByte(columnName);   \}   public byte\[\] getBytes(int columnIndex) throws SQLException \{     return wrapped.getBytes(columnIndex);   \}   public byte\[\] getBytes(String columnName) throws SQLException \{     return wrapped.getBytes(columnName);   \}   public Reader getCharacterStream(int columnIndex) throws SQLException \{     return wrapped.getCharacterStream(columnIndex);   \}   public Reader getCharacterStream(String columnName) throws SQLException \{     return wrapped.getCharacterStream(columnName);   \}   public Clob getClob(int i) throws SQLException \{     return wrapped.getClob(i);   \}   public Clob getClob(String colName) throws SQLException \{     return wrapped.getClob(colName);   \}   public int getConcurrency() throws SQLException \{     return wrapped.getConcurrency();   \}   public String getCursorName() throws SQLException \{     return wrapped.getCursorName();   \}   public Date getDate(int columnIndex) throws SQLException \{     return wrapped.getDate(columnIndex);   \}   public Date getDate(String columnName) throws SQLException \{     return wrapped.getDate(columnName);   \}   public Date getDate(int columnIndex, Calendar cal) throws SQLException \{     return wrapped.getDate(columnIndex, cal);   \}   public Date getDate(String columnName, Calendar cal) throws SQLException \{     return wrapped.getDate(columnName, cal);   \}   public double getDouble(int columnIndex) throws SQLException \{     return wrapped.getDouble(columnIndex);   \}   public double getDouble(String columnName) throws SQLException \{     return wrapped.getDouble(columnName);   \}   public int getFetchDirection() throws SQLException \{     return wrapped.getFetchDirection();   \}   public int getFetchSize() throws SQLException \{     return wrapped.getFetchSize();   \}   public float getFloat(int columnIndex) throws SQLException \{     return wrapped.getFloat(columnIndex);   \}   public float getFloat(String columnName) throws SQLException \{     return wrapped.getFloat(columnName);   \}   public int getInt(int columnIndex) throws SQLException \{     return wrapped.getInt(columnIndex);   \}   public int getInt(String columnName) throws SQLException \{     return wrapped.getInt(columnName);   \}   public long getLong(int columnIndex) throws SQLException \{     return wrapped.getLong(columnIndex);   \}   public long getLong(String columnName) throws SQLException \{     return wrapped.getLong(columnName);   \}   public ResultSetMetaData getMetaData() throws SQLException \{     return new ResultSetMetaDataWrapper(this.wrapped.getMetaData());   \}   public Object getObject(int columnIndex) throws SQLException \{     return this.wrapped.getObject(columnIndex);   \}   public Object getObject(String columnName) throws SQLException \{     return this.wrapped.getObject(columnName);   \}   public Object getObject(int arg0, Map arg1) throws SQLException \{     return this.wrapped.getObject(arg0, arg1);   \}   public Object getObject(String arg0, Map arg1) throws SQLException \{     return this.wrapped.getObject(arg0, arg1);   \}   public Ref getRef(int i) throws SQLException \{     return this.wrapped.getRef(i);   \}   public Ref getRef(String colName) throws SQLException \{     return this.wrapped.getRef(colName);   \}   public int getRow() throws SQLException \{     return this.wrapped.getRow();   \}   public short getShort(int columnIndex) throws SQLException \{     return this.wrapped.getShort(columnIndex);   \}   public short getShort(String columnName) throws SQLException \{     return wrapped.getShort(columnName);   \}   public Statement getStatement() throws SQLException \{     return wrapped.getStatement();   \}   public String getString(int columnIndex) throws SQLException \{     return wrapped.getString(columnIndex);   \}   public String getString(String columnName) throws SQLException \{     return wrapped.getString(columnName);   \}   public Time getTime(int columnIndex) throws SQLException \{     return wrapped.getTime(columnIndex);   \}   public Time getTime(String columnName) throws SQLException \{     return wrapped.getTime(columnName);   \}   public Time getTime(int columnIndex, Calendar cal) throws SQLException \{     return wrapped.getTime(columnIndex, cal);   \}   public Time getTime(String columnName, Calendar cal) throws SQLException \{     return wrapped.getTime(columnName, cal);   \}   public Timestamp getTimestamp(int columnIndex) throws SQLException \{     return wrapped.getTimestamp(columnIndex);   \}   public Timestamp getTimestamp(String columnName) throws SQLException \{     return wrapped.getTimestamp(columnName);   \}   public Timestamp getTimestamp(int columnIndex, Calendar cal)       throws SQLException \{     return wrapped.getTimestamp(columnIndex, cal);   \}   public Timestamp getTimestamp(String columnName, Calendar cal)       throws SQLException \{     return wrapped.getTimestamp(columnName, cal);   \}   public int getType() throws SQLException \{     return wrapped.getType();   \}   public URL getURL(int columnIndex) throws SQLException \{     return wrapped.getURL(columnIndex);   \}   public URL getURL(String columnName) throws SQLException \{     return wrapped.getURL(columnName);   \}   public InputStream getUnicodeStream(int columnIndex) throws SQLException \{     return wrapped.getUnicodeStream(columnIndex);   \}   public InputStream getUnicodeStream(String columnName) throws SQLException \{     return wrapped.getUnicodeStream(columnName);   \}   public SQLWarning getWarnings() throws SQLException \{     return wrapped.getWarnings();   \}   public void insertRow() throws SQLException \{     wrapped.insertRow();   \}   public boolean isAfterLast() throws SQLException \{     return wrapped.isAfterLast();   \}   public boolean isBeforeFirst() throws SQLException \{     return wrapped.isBeforeFirst();   \}   public boolean isFirst() throws SQLException \{     return wrapped.isFirst();   \}   public boolean isLast() throws SQLException \{     return wrapped.isLast();   \}   public boolean last() throws SQLException \{     return wrapped.last();   \}   public void moveToCurrentRow() throws SQLException \{     wrapped.moveToCurrentRow();   \}   public void moveToInsertRow() throws SQLException \{     wrapped.moveToInsertRow();   \}   public boolean next() throws SQLException \{     return wrapped.next();   \}   public boolean previous() throws SQLException \{     return wrapped.previous();   \}   public void refreshRow() throws SQLException \{     wrapped.refreshRow();   \}   public boolean relative(int rows) throws SQLException \{     return this.wrapped.relative(rows);   \}   public boolean rowDeleted() throws SQLException \{     return this.wrapped.rowDeleted();   \}   public boolean rowInserted() throws SQLException \{     return this.wrapped.rowInserted();   \}   public boolean rowUpdated() throws SQLException \{     return this.wrapped.rowUpdated();   \}   public void setFetchDirection(int direction) throws SQLException \{     this.wrapped.setFetchDirection(direction);   \}   public void setFetchSize(int rows) throws SQLException \{     this.wrapped.setFetchSize(rows);   \}   public void updateArray(int columnIndex, Array x) throws SQLException \{     this.wrapped.updateArray(columnIndex, x);   \}   public void updateArray(String columnName, Array x) throws SQLException \{     this.wrapped.updateArray(columnName, x);   \}   public void updateAsciiStream(int columnIndex, InputStream x, int length)       throws SQLException \{     this.wrapped.updateAsciiStream(columnIndex, x, length);   \}   public void updateAsciiStream(String columnName, InputStream x, int length)       throws SQLException \{     this.wrapped.updateAsciiStream(columnName, x, length);   \}   public void updateBigDecimal(int columnIndex, BigDecimal x)       throws SQLException \{     this.wrapped.updateBigDecimal(columnIndex, x);   \}   public void updateBigDecimal(String columnName, BigDecimal x)       throws SQLException \{     this.wrapped.updateBigDecimal(columnName, x);   \}   public void updateBinaryStream(int columnIndex, InputStream x, int length)       throws SQLException \{     this.wrapped.updateBinaryStream(columnIndex, x, length);   \}   public void updateBinaryStream(String columnName, InputStream x, int length)       throws SQLException \{     this.wrapped.updateBinaryStream(columnName, x, length);   \}   public void updateBlob(int columnIndex, Blob x) throws SQLException \{     this.wrapped.updateBlob(columnIndex, x);   \}   public void updateBlob(String columnName, Blob x) throws SQLException \{     this.wrapped.updateBlob(columnName, x);   \}   public void updateBoolean(int columnIndex, boolean x) throws SQLException \{     this.wrapped.updateBoolean(columnIndex, x);   \}   public void updateBoolean(String columnName, boolean x) throws SQLException \{     this.wrapped.updateBoolean(columnName, x);   \}   public void updateByte(int columnIndex, byte x) throws SQLException \{     this.wrapped.updateByte(columnIndex, x);   \}   public void updateByte(String columnName, byte x) throws SQLException \{     this.wrapped.updateByte(columnName, x);   \}   public void updateBytes(int columnIndex, byte\[\] x) throws SQLException \{     this.wrapped.updateBytes(columnIndex, x);   \}   public void updateBytes(String columnName, byte\[\] x) throws SQLException \{     this.wrapped.updateBytes(columnName, x);   \}   public void updateCharacterStream(int columnIndex, Reader x, int length)       throws SQLException \{     this.wrapped.updateCharacterStream(columnIndex, x, length);   \}   public void updateCharacterStream(String columnName, Reader reader, int length)       throws SQLException \{     this.wrapped.updateCharacterStream(columnName, reader, length);   \}   public void updateClob(int columnIndex, Clob x) throws SQLException \{     this.wrapped.updateClob(columnIndex, x);   \}   public void updateClob(String columnName, Clob x) throws SQLException \{     this.wrapped.updateClob(columnName, x);   \}   public void updateDate(int columnIndex, Date x) throws SQLException \{     this.wrapped.updateDate(columnIndex, x);   \}   public void updateDate(String columnName, Date x) throws SQLException \{     this.wrapped.updateDate(columnName, x);   \}   public void updateDouble(int columnIndex, double x) throws SQLException \{     this.wrapped.updateDouble(columnIndex, x);   \}   public void updateDouble(String columnName, double x) throws SQLException \{     this.wrapped.updateDouble(columnName, x);   \}   public void updateFloat(int columnIndex, float x) throws SQLException \{     this.wrapped.updateFloat(columnIndex, x);   \}   public void updateFloat(String columnName, float x) throws SQLException \{     this.wrapped.updateFloat(columnName, x);   \}   public void updateInt(int columnIndex, int x) throws SQLException \{     this.wrapped.updateInt(columnIndex, x);   \}   public void updateInt(String columnName, int x) throws SQLException \{     this.wrapped.updateInt(columnName, x);   \}   public void updateLong(int columnIndex, long x) throws SQLException \{     this.wrapped.updateLong(columnIndex, x);   \}   public void updateLong(String columnName, long x) throws SQLException \{     this.wrapped.updateLong(columnName, x);   \}   public void updateNull(int columnIndex) throws SQLException \{     this.wrapped.updateNull(columnIndex);   \}   public void updateNull(String columnName) throws SQLException \{     this.wrapped.updateNull(columnName);   \}   public void updateObject(int columnIndex, Object x) throws SQLException \{     this.wrapped.updateObject(columnIndex, x);   \}   public void updateObject(String columnName, Object x) throws SQLException \{     this.wrapped.updateObject(columnName, x);   \}   public void updateObject(int columnIndex, Object x, int scale)       throws SQLException \{     this.wrapped.updateObject(columnIndex, x, scale);   \}   public void updateObject(String columnName, Object x, int scale)       throws SQLException \{     this.wrapped.updateObject(columnName, x, scale);   \}   public void updateRef(int columnIndex, Ref x) throws SQLException \{     this.wrapped.updateRef(columnIndex, x);   \}   public void updateRef(String columnName, Ref x) throws SQLException \{     this.wrapped.updateRef(columnName, x);   \}   public void updateRow() throws SQLException \{     this.wrapped.updateRow();   \}   public void updateShort(int columnIndex, short x) throws SQLException \{     this.wrapped.updateShort(columnIndex, x);   \}   public void updateShort(String columnName, short x) throws SQLException \{     this.wrapped.updateShort(columnName, x);   \}   public void updateString(int columnIndex, String x) throws SQLException \{     this.wrapped.updateString(columnIndex, x);   \}   public void updateString(String columnName, String x) throws SQLException \{     this.wrapped.updateString(columnName, x);   \}   public void updateTime(int columnIndex, Time x) throws SQLException \{     this.wrapped.updateTime(columnIndex, x);   \}   public void updateTime(String columnName, Time x) throws SQLException \{     this.wrapped.updateTime(columnName, x);   \}   public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException \{     this.wrapped.updateTimestamp(columnIndex, x);   \}   public void updateTimestamp(String columnName, Timestamp x)       throws SQLException \{     this.wrapped.updateTimestamp(columnName, x);   \}   public boolean wasNull() throws SQLException \{     return this.wrapped.wasNull();   \} \} 这个是ResultSetMetaData的Decorate类： import java.sql.ResultSetMetaData; import java.sql.SQLException; public class ResultSetMetaDataWrapper implements ResultSetMetaData \{   private ResultSetMetaData wrapped;   public ResultSetMetaDataWrapper(ResultSetMetaData wrapped) \{     this.wrapped = wrapped;   \}   public String getCatalogName(int column) throws SQLException \{     return this.wrapped.getCatalogName(column);   \}   public String getColumnClassName(int column) throws SQLException \{     return this.wrapped.getColumnClassName(column);   \}   public int getColumnCount() throws SQLException \{     return this.wrapped.getColumnCount();   \}   public int getColumnDisplaySize(int column) throws SQLException \{     return this.wrapped.getColumnDisplaySize(column);   \}   public String getColumnLabel(int column) throws SQLException \{     return this.wrapped.getColumnLabel(column);   \}   public String getColumnName(int column) throws SQLException \{     return this.wrapped.getColumnName(column);   \}   public int getColumnType(int column) throws SQLException \{     return this.wrapped.getColumnType(column);   \}   public String getColumnTypeName(int column) throws SQLException \{     return this.wrapped.getColumnTypeName(column);   \}   public int getPrecision(int column) throws SQLException \{     return this.wrapped.getPrecision(column);   \}   public int getScale(int column) throws SQLException \{     int scale = this.wrapped.getScale(column);     return scale < 0 ? 0 : scale;   \}   public String getSchemaName(int column) throws SQLException \{     return this.wrapped.getSchemaName(column);   \}   public String getTableName(int column) throws SQLException \{     return this.wrapped.getTableName(column);   \}   public boolean isAutoIncrement(int column) throws SQLException \{     return this.wrapped.isAutoIncrement(column);   \}   public boolean isCaseSensitive(int column) throws SQLException \{     return wrapped.isCaseSensitive(column);   \}   public boolean isCurrency(int column) throws SQLException \{     return this.wrapped.isCurrency(column);   \}   public boolean isDefinitelyWritable(int column) throws SQLException \{     return this.wrapped.isDefinitelyWritable(column);   \}   public int isNullable(int column) throws SQLException \{     return this.wrapped.isNullable(column);   \}   public boolean isReadOnly(int column) throws SQLException \{     return this.wrapped.isReadOnly(column);   \}   public boolean isSearchable(int column) throws SQLException \{     return this.wrapped.isSearchable(column);   \}   public boolean isSigned(int column) throws SQLException \{     return this.wrapped.isSigned(column);   \}   public boolean isWritable(int column) throws SQLException \{     return wrapped.isWritable(column);   \} \} 下面就是用spring的同学们了，在JdbcTemplate的queryForRowSet就会有出标题那个异常，于是，只能用query然后自己写extractor，具体代码如下，当然是可以偷懒啦，反正spring有实现了一个，我们改改就能用： import java.sql.ResultSet; import java.sql.SQLException; import javax.sql.rowset.CachedRowSet; import org.springframework.jdbc.core.SqlRowSetResultSetExtractor; import org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet; import org.springframework.jdbc.support.rowset.SqlRowSet; public class CustomSqlRowSetResultSetExtractor     extends       SqlRowSetResultSetExtractor \{   protected SqlRowSet createSqlRowSet(ResultSet rs) throws SQLException \{     CachedRowSet rowSet = newCachedRowSet();     rowSet.populate(new ResultSetWrapper(rs));     return new ResultSetWrappingSqlRowSet(rowSet);   \} \}

[http_blog.csdn.net_horsefaced_archive_2007_08_16_1746888.aspx]: http://blog.csdn.net/horsefaced/archive/2007/08/16/1746888.aspx
[Pedrinho]: http://forum.java.sun.com/profile.jspa?userID=926139