i want to keep the parameterType java.lang.Long and no Map

[Kelly Johana Castillo Macías]

Hi.

I have a problem. I have the following error from version 3.3.0 of mybatis :

org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='ID', mode=IN, javaType=class java.lang.Long, jdbcType=NUMERIC, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType NUMERIC . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long

### The error may exist in /com/casewaresa/iceberg_aa/dto/xml/AATMenu.xml

### The error may involve MenuMapper.AA_obtenerPathMenuPorDemanda-Inline

### The error occurred while setting parameters

### SQL: select      SYS_CONNECT_BY_PATH(u.sec_menu, '/') AS PATH    FROM aad_menu u     WHERE u.predecesor IS NULL    CONNECT BY PRIOR u.predecesor = u.sec_menu     START WITH u.sec_menu = ?

### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='ID', mode=IN, javaType=class java.lang.Long, jdbcType=NUMERIC, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType NUMERIC . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)

at com.casewaresa.framework.dao.ParametrizacionDao.obtenerListado(ParametrizacionDao.java:49)

at com.casewaresa.framework.manager.ParametrizacionMgr.obtenerListado(ParametrizacionMgr.java:15)

at com.casewaresa.framework.facade.ParametrizacionFac.obtenerListado(ParametrizacionFac.java:45)

at com.casewaresa.framework.macros.TreeIceberg.setItemTree(TreeIceberg.java:1722)

at com.casewaresa.framework.macros.TreeIceberg$4.onEvent(TreeIceberg.java:606)

at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2746)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2717)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2658)

at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)

at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:536)

at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:463)

Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='ID', mode=IN, javaType=class java.lang.Long, jdbcType=NUMERIC, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType NUMERIC . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long

at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:89)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:85)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:63)

at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:77)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:61)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)

at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)

at com.sun.proxy.$Proxy17.query(Unknown Source)

at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)

at com.casewaresa.framework.interceptor.PagingIcebergPlugin.intercept(PagingIcebergPlugin.java:39)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

at com.sun.proxy.$Proxy17.query(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

... 12 more

Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType NUMERIC . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long

at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:55)

at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:87)

... 33 more

Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Long

at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:26)

at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:53)

In version 3.2.0 working properly 

It works in version 3.3.0 , replacing the data type : parameterType="java.lang,Long" for parameterType="Map"

I wonder why. and also if somehow configured to allow the reconociemiento without replacing