[
https://issues.apache.org/jira/browse/IBATIS-620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Clinton Begin closed IBATIS-620.
--------------------------------
Resolution: Invalid
This is normal behavior for Oracle. If you specify the resultClass, it will
return an int or whatever you specify (assuming the driver allows the "casting".
> "select count(*) from table" return BigDecimal value in Oracle
> --------------------------------------------------------------
>
> Key: IBATIS-620
> URL: https://issues.apache.org/jira/browse/IBATIS-620
> Project: iBatis for Java
> Issue Type: Bug
> Affects Versions: 3.0 Beta 1
> Reporter: Yuan Tao
>
> User SqlSession.selectOne for the sql "select count(*) from table" defined in
> mapping file should return Integer, but return BigDecimal in Oracle.
> The bug seems happen int DefaultResultSetHandler.mapResults method. There are
> codes below:
> ...
> for (int i = 1, n = rsmd.getColumnCount(); i <= n; i++) {
> boolean useLabel =
> mappedStatement.getConfiguration().isUseColumnLabel();
> String columnLabel = (useLabel ? rsmd.getColumnLabel(i) :
> rsmd.getColumnName(i));
> columnLabel = columnLabel.toUpperCase();
> String propName = metaResultObject.findProperty(columnLabel);
> colSet.add(columnLabel);
> if (propName != null) {
> propSet.add(propName);
> Class javaType = metaResultObject.getSetterType(propName); // This
> line will return Object if the resultObject is PlatformTypeHolder
>
> TypeHandler typeHandler =
> typeHandlerRegistry.getTypeHandler(javaType);
> ResultMapping resultMapping = new
> ResultMapping.Builder(configuration, propName, columnLabel, typeHandler)
> .javaType(javaType).build();
> autoMappings.put(propName, resultMapping);
> }
> }
> ...
> Maybe this bug can fixed by adding the code below after "Class javaType =
> metaResultObject.getSetterType(propName);"
> // -------------------------------------------------------------
>
> if((!rm.getType().isAssignableFrom(resultObject.getClass())&&(!rm.getType().isAssignableFrom(javaType))))
> javaType = rm.getType();
> // -------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
