ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Stored Procedures, Callable Statements are not supported ...
Date Wed, 27 Jun 2007 17:03:55 GMT
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 <warren@clarksnutrition.com> 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
>

Mime
View raw message