Return-Path: 
 <user-java-return-4526-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 41766 invoked from network); 12 Oct 2005 16:04:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 12 Oct 2005 16:04:38 -0000
Received: (qmail 16044 invoked by uid 500); 12 Oct 2005 16:04:37 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 16019 invoked by uid 500); 12 Oct 2005 16:04:36 -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 16007 invoked by uid 99); 12 Oct 2005 16:04:36 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Oct 2005 09:04:36 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.201 as permitted sender)
Received: from [64.233.162.201] (HELO zproxy.gmail.com) (64.233.162.201)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Oct 2005 09:04:38 -0700
Received: by zproxy.gmail.com with SMTP id z6so144216nzd
        for <user-java@ibatis.apache.org>;
 Wed, 12 Oct 2005 09:04:15 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=JWt8infUsDFESCYT/MbqTh3WwLNJOq++BfHMbUluBcYQsogdacZnYDjEOI41x+A7jiqnCU3Ul9GwrslChoCJJ+XKPsqVEF1fNbi5/RSBQkFarhtNw8pvJrsNuKEbPU85ZXQFgEBOqpmfE7yWLxQlWEYBVtBHUmIpWSzipQSmguk=
Received: by 10.36.48.12 with SMTP id v12mr876337nzv;
        Wed, 12 Oct 2005 09:04:14 -0700 (PDT)
Received: by 10.36.118.10 with HTTP; Wed, 12 Oct 2005 09:04:14 -0700 (PDT)
Message-ID: <a10a823c0510120904w50573637xf423f1df67f6fb57@mail.gmail.com>
Date: Wed, 12 Oct 2005 10:04:14 -0600
From: Larry Meadors <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: cannot using a dollar sign in my maps
In-Reply-To: 
 <10361639FF4CA04ABB30F54683E4FB85056672FE@exchange2.home.zooplus.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <10361639FF4CA04ABB30F54683E4FB85056672FE@exchange2.home.zooplus.de>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This was on the wiki, but not sure if it still is - use $$ to get a $
in your query.

Larry

On 10/12/05, Steven Pannell <steven.pannell@zooplus.com> wrote:
> Hi,
>
> I have the following oracle (intermedia indexed) statement map sqlMap fil=
e:
>
>     <select id=3D"get" resultClass=3D"long" >
>       <![CDATA[
>               select id from myTable
>                 where contains(title,'${Milben}',0 ) > 0
>         ]]>
>     </select>
>
> When I run this statement I get the following error:
>
> java.util.NoSuchElementException
>         at java.util.StringTokenizer.nextToken(StringTokenizer.java:332)
>         at
> com.ibatis.sqlmap.engine.mapping.sql.simple.SimpleDynamicSql.processDynam=
icE
> lements(Unknown Source)
>         at
> com.ibatis.sqlmap.engine.mapping.sql.simple.SimpleDynamicSql.getSql(Unkno=
wn
> Source)
>         at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW=
ith
> Callback(Unknown Source)
>         at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF=
orO
> bject(Unknown Source)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(Unkno=
wn
> Source)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(Unkno=
wn
> Source)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(Unknown
> Source)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(Unknown
> Source)
>
> Seems that the dollar ($) sign is not accepted in the sqlMap. If I remove
> the $ then the statement executes correctly.
>
> Is there a way to resolve this issue??
>
> thanks,
> Steve.
>
>