Update Postgres Array with IBatis

[beppes]

Hi to everybody. I'm new to this forum.

I need to update an array of integers in Postgres with Ibatis 2.3.4 (and
Spring). I want to execute the following query:
UPDATE data SET='{1,2}' WHERE dataid=10

The query is

    <update id="updateQuery" parameterClass="java.util.Map">
        UPDATE data
          <dynamic prepend="SET arrayData =" >
                <iterate property="arrayData" open="'{" close="}'" 
conjunction=",">
                     #arrayData[]#
                </iterate>
          </dynamic>        
        WHERE dataid=#dataId#
    </update>

The method realized

    public void updateData(int dataId, MyData mydata) {
        Map<String, Object> params = new HashMap<String, Object>();
        List<Integer> arrayData = mydata.getIntegerArray();
        params.put("dataId", dataId);
        params.put("arrayData", arrayData);
        this.getSqlMapClientTemplate().update("updateQuery", params);
    }

Executing the query I get the following response (arrayData contains 2
values):

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred while applying a parameter map.  
--- Check the updateData-InlineParameterMap.  
--- Check the parameter mapping for the 'arrayData[1]' property.  
--- Cause: org.postgresql.util.PSQLException: The column index is out of
range: 2, number of columns: 1 at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.jav2009-04-07
10:27:26,727 DEBUG [java.sql.Connection] - {conn-100043} Connection
2009-04-07 10:27:26,729 DEBUG [java.sql.Connection] - {conn-100043}
Preparing Statement:          UPDATE data         SET arrayData =         
'{               ?          ,               ?          }'    WHERE dataId=?
a:107)
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
        at
org.springframework.orm.ibatis.SqlMapClientTemplate$10.doInSqlMapClient(SqlMapClientTemplate.java:413)
        at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
        ... 43 more
Caused by: org.postgresql.util.PSQLException: Indice di colonna, 2, è
maggiore del numero di colonne 1.
        at
org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:52)
        at
org.postgresql.core.v3.SimpleParameterList.setLiteralParameter(SimpleParameterList.java:113)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.bindLiteral(AbstractJdbc2Statement.java:2108)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.setInt(AbstractJdbc2Statement.java:1151)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:117)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:70)
        at $Proxy9.setInt(Unknown Source)
        at
com.ibatis.sqlmap.engine.type.IntegerTypeHandler.setParameter(IntegerTypeHandler.java:30)
        at
com.ibatis.sqlmap.engine.type.UnknownTypeHandler.setParameter(UnknownTypeHandler.java:69)
        at
com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameter(ParameterMap.java:166)
        at
com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameters(ParameterMap.java:126)
        at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:78)
        at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
        at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
        ... 47 more

I've also tried the same query with this variant

public void updateData(int dataId, MyData mydata) {
        Map<String, Object> params = new HashMap<String, Object>();
        int[] arrayData = mydata.getIntArray();
        params.put("dataId", dataId);
        params.put("arrayData", arrayData);
        this.getSqlMapClientTemplate().update("updateQuery", params);
    }

With the same result. Could someone suggest me a solution?

-- 
View this message in context: 
http://www.nabble.com/Update-Postgres-Array-with-IBatis-tp22924852p22924852.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.