I am using Ibatis version 2.3.0.677 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: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/clarks/persistence/sqlmapdao/sql/postgres/invoice-postgres.xml.
--- 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" property="table"/> <parameter javaType="java.lang.String" jdbcType="VARCHAR" property="filename"/> <parameter javaType="java.lang.String" jdbcType="VARCHAR" property="delimiter"/>
  </parameterMap>


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

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?

--
Thanks,

Warren Bell

Reply via email to