Re: Stored Procedures, Callable Statements are not supported ...

[Jeff Butler]

This is an error from the PostgreSQL driver - not iBATIS.  Maybe someone on
the PostgreSQL forums could help?

Jeff Butler



On 6/27/07, Warren <[EMAIL PROTECTED]> wrote:

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