You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2009/08/15 06:04:15 UTC
[jira] Closed: (IBATIS-620) "select count(*) from table" return
BigDecimal value in Oracle
[ 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: dev-unsubscribe@ibatis.apache.org
For additional commands, e-mail: dev-help@ibatis.apache.org