You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Yuan Tao (JIRA)" <ib...@incubator.apache.org> on 2009/08/05 10:08:14 UTC
[jira] Created: (IBATIS-620) "select count(*) from table" return
BigDecimal value in Oracle
"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.0
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 (javaType.isAssignableFrom(rm.getType()))
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
[jira] Commented: (IBATIS-620) "select count(*) from table" return
BigDecimal value in Oracle
Posted by "Yuan Tao (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739392#action_12739392 ]
Yuan Tao commented on IBATIS-620:
---------------------------------
The fix solution imported other bugs. so now, I have no idea to solve it.
Should I need convert the result SqlSession.selectOne to Integer manually.
> "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.0
> 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 (javaType.isAssignableFrom(rm.getType()))
> 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
[jira] Closed: (IBATIS-620) "select count(*) from table" return
BigDecimal value in Oracle
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ 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