java中的无效的列类型_Cause: java.sql.SQLException: 无效的列类型

Cause: java.sql.SQLException: 无效的列类型0

yzgtboyII2013.04.19浏览255次分享举报

{conn-100000} Preparing Call: {call f_saveuser(?)}

com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in org/gsf/ibatis/simple/bean/User.xml.

--- The error occurred while executing query procedure.

--- Check the {call f_saveuser(?)}.

--- Check the output parameters (register output parameters failed).

--- Cause: java.sql.SQLException: 无效的列类型

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)2008-08-18 11:31:14,918 DEBUG (com.ibatis.common.jdbc.SimpleDataSource:27) - Returned connection 13446707 to pool.

at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)

at org.gsf.ibatis.simple.DbTools.getUserByProc(DbTools.java:197)

at org.gsf.ibatis.simple.DbTools.main(DbTools.java:268)

Caused by: java.sql.SQLException: 无效的列类型

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)

at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:5465)

at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:246)

at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:371)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)

at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:88)

at $Proxy1.registerOutParameter(Unknown Source)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.registerOutputParameters(SqlExecutor.java:431)

at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:274)

at com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:39)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)

... 7 more