org.springframework.jdbc.UncategorizedSQLException

今天在Struts+ibatis中遇到这样一个问题，老是抛出下面异常：

[2011/05/03 14:30:45][ERROR][DefaultExceptionHandler] 例外ハンドラが例外を検知しました

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   

--- The error occurred in sqlMap.xml. 

--- The error occurred while applying a parameter map. 

--- Check the insertTDeviationRequestInfo-InlineParameterMap. 

--- Check the parameter mapping for the 'processUserId' property. 

--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  

--- The error occurred in sqlMap.xml. 

--- The error occurred while applying a parameter map. 

--- Check the insertTDeviationRequestInfo-InlineParameterMap. 

--- Check the parameter mapping for the 'processUserId' property. 

--- Cause: java.lang.NullPointerException

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

    at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)

    at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:411)

    at jp.terasoluna.fw.dao.ibatis.UpdateDAOiBatisImpl.execute(UpdateDAOiBatisImpl.java:189)

    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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

    at $Proxy1.execute(Unknown Source)

    at jp.anserkcom.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)

    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)

    at org.springframework.orm.ibatis.SqlMapClientTemplate$10.doInSqlMapClient(SqlMapClientTemplate.java:413)

    at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)

    ... 75 more

Caused by: java.lang.NullPointerException

    at com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(Unknown Source)

    at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)

    at com.microsoft.sqlserver.jdbc.AppDTVImpl.setValue(Unknown Source)

    at com.microsoft.sqlserver.jdbc.DTV.setValue(Unknown Source)

    at com.microsoft.sqlserver.jdbc.Parameter.setValue(Unknown Source)

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(Unknown Source)

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setNull(Unknown Source)

    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:105)

    at com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameter(ParameterMap.java:172)

    at com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameters(ParameterMap.java:126)

    at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:78)

    at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)

    at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)

    ... 79 more

 

请教了百度老师好久，众人说法不一。经过一番波折之后，终于找到了答案，原来是因为没有把sqljdbc.jar加到JDK当中去http://hi.baidu.com/xiaobobo_/blog/item/88178018c009914d42a9ad7d.html