mybitas 存储过程 无返回值 报错 求大神

[qq343913906]

mybitas 调用 mysql 的存储过程报错


<select id="addPdaCount" statementType="CALLABLE" >

<!-- int addPdaCount(int year,int month,int day,int flowStatus,
// String userCode,
int successNum,int errorNum,String update_time);
-->
<![CDATA[


{ CALL bcms.addPdaCount(
#{year,mode=IN,jdbcType=INTEGER},
#{month,mode=IN,jdbcType=INTEGER},
#{day,mode=IN,jdbcType=INTEGER},
#{flowStatus,mode=IN,jdbcType=INTEGER},
#{userCode,mode=IN,jdbcType=VARCHAR},
#{successNum,mode=IN,jdbcType=INTEGER},
#{errorNum,mode=IN,jdbcType=INTEGER},
#{updateTime,mode=IN,jdbcType=VARCHAR})
}

]]>

</select>


### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in com/eiot/bot/sqlmap/PdaCountMapper.xml
### The error may involve com.eiot.bot.dao.PdaCountMapper.addPdaCount
### The error occurred while handling results
### SQL: { CALL bcms.addPdaCount( ?, ?, ?, ?, ?, ?, ?, ?, ?) }
### Cause: java.lang.NullPointerException
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 org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
... 59 more
Caused by: java.lang.NullPointerException
at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.<init>(AbstractResultSetProxyHandler.java:50)

at org.hibernate.engine.jdbc.internal.proxy.ResultSetProxyHandler.<init>(ResultSetProxyHandler.java:44)
at org.hibernate.engine.jdbc.internal.proxy.ProxyBuilder.buildResultSet(ProxyBuilder.java:286)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.wrapIfNecessary(AbstractStatementProxyHandler.java:148)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:123)
at org.hibernate.engine.jdbc.internal.proxy.CallableStatementProxyHandler.continueInvocation(CallableStatementProxyHandler.java:49)

at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at $Proxy55.getResultSet(Unknown Source)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getFirstResultSet(DefaultResultSetHandler.java:185)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:153)
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
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 org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
... 66 more

数据库是已经执行了 存储过程没问题 但是后台报错呀。。。

[qq343913906]

好吧 自己找到了 改成这个就可以了 @Transactional(propagation=Propagation.SUPPORTS)

[心随自在飞]

仔细一点，总能找到bug的、结贴吧