ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Warren <war...@clarksnutrition.com>
Subject Stored Procedures, Callable Statements are not supported ...
Date Wed, 27 Jun 2007 16:55:46 GMT
I am using Ibatis version with PostgreSQL 8.1 with 8.1-405 
JDBC driver and Ibatis DAO 2.2.0. I am getting the following exception:

com.ibatis.dao.client.DaoException: Error executing update.  Cause: 
--- The error occurred in 
--- The error occurred while executing update procedure.
--- Check the {call import_text_file(?, ?, ?)}.
--- Check the SQL Statement (preparation failed).
--- Cause: Callable Statements are not supported at this time.

My SQL map:

   <parameterMap class="map" id="importParameters">
     <parameter javaType="java.lang.String" jdbcType="VARCHAR" 
     <parameter javaType="java.lang.String" jdbcType="VARCHAR" 
     <parameter javaType="java.lang.String" jdbcType="VARCHAR" 

   <procedure id="importTextFile" parameterMap="importParameters">
       {call import_text_file[(?, ?, ?)]}

I have also tried:

       {call import_text_file(?, ?, ?)}

I am calling it in a DAO context like this:

protected int executeUpdate(String statementName, Object parameterObject) {
     SqlMapExecutor sqlMap = getSqlMapExecutor();
     try {
       return sqlMap.update(statementName, parameterObject);
     } catch (SQLException e) {
       throw new DaoException("Error executing update.  Cause: " + e, e);

What am I doing wrong?


Warren Bell

View raw message