Return-Path: 
 <user-java-return-4763-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 96264 invoked from network); 2 Nov 2005 07:24:07 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 Nov 2005 07:24:07 -0000
Received: (qmail 50231 invoked by uid 500); 2 Nov 2005 07:24:05 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 50208 invoked by uid 500); 2 Nov 2005 07:24:04 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 50197 invoked by uid 99); 2 Nov 2005 07:24:04 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Nov 2005 23:24:04 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [83.247.21.91] (HELO wis.nl) (83.247.21.91)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Nov 2005 23:23:59 -0800
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Problems applying parameter map property
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Date: Wed, 2 Nov 2005 08:22:55 +0100
Message-ID: <50CA25BD6EEA954FA592C097399942E303F35FF0@CM1.wis.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Problems applying parameter map property
thread-index: AcXfSM8SD9dLDYGWTBakwY48+HrOMAANV4/A
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Just a guess, can you try to remove the CDATA-tags? There have been a
number of people that reported similar issues.

Niels

-----Original Message-----
From: Daniel Henrique Ferreira e Silva [mailto:dhsilva@gmail.com]=20
Sent: woensdag 2 november 2005 2:01
To: user-java@ibatis.apache.org
Subject: Problems applying parameter map property

Hey all,

I'm getting an annoying error that is giving me such a great headache
as i can't figure it out.

Database: Oracle 9iR2
Container: Resin 3.0.14
OS: Windows XP SP2
iBATIS version: 2.1.5.582

Here is my problem:

I have this statement with its parameter map:

    <parameterMap id=3D"projetosDoUsuarioMap" =
class=3D"java.util.HashMap">
        <parameter property=3D"l_superusuario" javaType=3D"string"
jdbcType=3D"VARCHAR" />
        <parameter property=3D"l_superconsulta" javaType=3D"string"
jdbcType=3D"VARCHAR" />
        <parameter property=3D"l_prestacaocontas" javaType=3D"string"
jdbcType=3D"VARCHAR" />
        <parameter property=3D"l_consultatodosmenosfitoca"
javaType=3D"string" jdbcType=3D"VARCHAR" />
        <parameter property=3D"l_usuario" javaType=3D"int" =
jdbcType=3D"NUMBER"
/>
        <parameter property=3D"l_documento" javaType=3D"int"
jdbcType=3D"NUMBER" />
        <parameter property=3D"l_acesso" javaType=3D"int" =
jdbcType=3D"NUMBER"
/>
    </parameterMap>

    <select id=3D"projetosDoUsuario" =
parameterMap=3D"projetosDoUsuarioMap"
 resultClass=3D"java.util.HashMap">
        <![CDATA[
             select distinct codigoUnesco from (
                 select distinct a.CodigoUnesco
                 from corporativo.CT_CC a
                 where a.ultimonivel =3D 'S'
                   and (   #l_superusuario# =3D 'S'
                        or (#l_superconsulta#=3D'S' and (#l_acesso# is
null or #l_acesso# =3D 14))
                        or (#l_prestacaocontas#=3D'S' and (#l_acesso# is
null or #l_acesso# =3D 16))
                        or (#l_consultatodosmenosfitoca# =3D 'S' and
(#l_acesso# is null or #l_acesso# =3D 14) and a.un_tipoprograma not in
('FITOCA', 'RUNNING COSTS'))
                       )
                 union all
                 select distinct a.CodigoUnesco
                   from corporativo.Ct_CC a
                  where a.ultimonivel =3D 'S'
                   and (#l_superusuario# =3D 'N' or (#l_superconsulta# =
=3D
'N' and #l_acesso# =3D 14) or (#l_consultatodosmenosfitoca# =3D 'N' and
#l_acesso# =3D 14))
                   and a.handle in (         select distinct x.projeto
                                               from
corporativo.vw_solicitacao_permissao x
                                              where
x.sq_pessoa_beneficiada =3D #l_usuario#
                                                and x.sn_matriz =3D 'S'
                                                and (#l_documento# is
null or x.paginaweb =3D #l_documento#)
                                                and (#l_acesso# is
null or x.tramite =3D #l_acesso#)
                                             union all
                                             select distinct w.handle
                                               from
corporativo.vw_permissoes_especiais y
                                                     inner join
corporativo.z_grupousuarios z on (z.handle =3D y.usuario),
                                                    corporativo.ct_cc w
                                              where z.pessoa =3D
#l_usuario#
                                                and (#l_documento# is
null or y.permissao =3D #l_documento#)
                                                and (#l_acesso# is
null or y.tramite =3D #l_acesso#)
                                                and (y.projeto =3D 'S'
or (y.projeto =3D 'N' and w.un_tipoprograma in ('FITOCA', 'RUNNING
COSTS')))
                                                and w.ultimonivel =3D =
'S'
                                                and w.handle not in
(select v.projeto
                                                                     =20
from corporativo.vw_projetoemexcecao v
                                                                    =20
where v.codigo =3D 'SG-001')
                                    )
             )
             order by Codigounesco

        ]]>
    </select>

When i run it i get this error in my log file:

2005-11-01 22:33:24,385 ERROR [resin-tcp-connection-*:8080-1]
org.unesco.sicof.db.dao.impl.GeralDaoImpl - getProjetosDoUsuario
failed!
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in org/unesco/sicof/config/geral.xml.
--- The error occurred while applying a parameter map.
--- Check the Geral.projetosDoUsuarioMap.
--- Check the parameter mapping for the 'l_superusuario' property.
--- Cause: java.sql.SQLException: Invalid column index

In a first glance, everything seems to be fine.
Any clue?

Cheers,
Daniel Silva.