Hi,
I'm having trouble mapping an oracle CHAR(1) column to a javabeans
property that is of type "char". I'm using SQL Maps 2.0.9 with Spring
1.1.3.
Here is my resultMap (defined in the mapping file ChargeType.xml):
<resultMap id="result"
class="nz.ac.otago.its.chargeadmin.domain.ChargeType">
<result property="code" column="CHARGE_TYPE_CODE"
columnIndex="1"/>
<result property="narration" column="NARRATION"
columnIndex="2"/>
<result property="status" column="STATUS" columnIndex="3"/>
<result property="versionNo" column="VERSION_NO"
columnIndex="4"/>
<result property="versionDateTime" column="VERSION_DATE_TIME"
columnIndex="5"/>
<result property="versionUser" column="VERSION_USER"
columnIndex="6"/>
</resultMap>
The offending column is the status column, which is a CHAR(1) in Oracle
and a char property in the ChargeType class. When I try to execute a
query that uses this result map, the following exception occurs:
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
operation): encountered SQLException [
--- The error occurred in
nz/ac/otago/its/chargeadmin/dao/ibatis/maps/ChargeType.xml.
--- The error occurred while applying a result map.
--- Check the ChargeType.result.
--- Check the result mapping for the 'status' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler
could be found to map the property 'status' to the column 'STATUS'. One
or both of the types, or the combination of types is not supported.];
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
nz/ac/otago/its/chargeadmin/dao/ibatis/maps/ChargeType.xml.
--- The error occurred while applying a result map.
--- Check the ChargeType.result.
--- Check the result mapping for the 'status' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler
could be found to map the property 'status' to the column 'STATUS'. One
or both of the types, or the combination of types is not supported.
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
nz/ac/otago/its/chargeadmin/dao/ibatis/maps/ChargeType.xml.
--- The error occurred while applying a result map.
--- Check the ChargeType.result.
--- Check the result mapping for the 'status' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler
could be found to map the property 'status' to the column 'STATUS'. One
or both of the types, or the combination of types is not
supported.Caused by: com.ibatis.sqlmap.client.SqlMapException: No type
handler could be found to map the property 'status' to the column
'STATUS'. One or both of the types, or the combination of types is not
supported.
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:183)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:118)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:610)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:584)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:105)
at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:202)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:142)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:164)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:200)
at
nz.ac.otago.its.chargeadmin.dao.ibatis.SqlMapChargeTypeDao.getChargeType
List(SqlMapChargeTypeDao.java:22)
[etc]
Explicity specifing the type of the status property in the <result>
element using the javaType and/or jdbcType attributes doesn't help. I
tried all of the following combinations:
<result property="status" column="STATUS" columnIndex="3"
javaType="char"/>
<result property="status" column="STATUS" columnIndex="3"
javaType="java.lang.Character"/>
<result property="status" column="STATUS" columnIndex="3"
jdbcType="CHAR"/>
<result property="status" column="STATUS" columnIndex="3"
javaType="char" jdbcType="CHAR"/>
<result property="status" column="STATUS" columnIndex="3"
javaType="java.lang.Character" jdbcType="CHAR"/>
None of these work, although the exception when specifying
javaType="char" is different, as shown below.
What am I doing wrong?
Thanks in advance
Steve
------------------------------------------------------------------------
----------------
Exception when specifying javaType="char":
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'sqlMapClient' defined in ServletContext resource
[/WEB-INF/dataAccessContext-local.xml]: Initialization of bean failed;
nested exception is java.lang.RuntimeException: Error occurred.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
java.lang.RuntimeException: Error occurred.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
Caused by: java.lang.RuntimeException: Error parsing XPath
'/sqlMap/resultMap/result'.
Cause: java.lang.RuntimeException: Error. Could not set TypeHandler.
Cause: java.lang.ClassNotFoundException: char
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConf
igParser.java:80)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapCli
entBuilder.java:62)
at
org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSe
t(SqlMapClientFactoryBean.java:210)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
tory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1037)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
tory.createBean(AbstractAutowireCapableBeanFactory.java:305)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
tory.createBean(AbstractAutowireCapableBeanFactory.java:223)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab
stractBeanFactory.java:236)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab
stractBeanFactory.java:159)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.pre
InstantiateSingletons(DefaultListableBeanFactory.java:255)
at
org.springframework.context.support.AbstractApplicationContext.refresh(A
bstractApplicationContext.java:317)
at
org.springframework.web.context.support.AbstractRefreshableWebApplicatio
nContext.refresh(AbstractRefreshableWebApplicationContext.java:131)
at
org.springframework.web.context.ContextLoader.createWebApplicationContex
t(ContextLoader.java:177)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(
ContextLoader.java:105)
at
org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderS
ervlet.java:81)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
[etc]
