Return-Path: 
 <ibatis-user-java-return-2039-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 94481 invoked from network); 28 Apr 2005 03:22:53 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 28 Apr 2005 03:22:53 -0000
Received: (qmail 93982 invoked by uid 500); 28 Apr 2005 03:23:53 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 93956 invoked by uid 500); 28 Apr 2005 03:23:53 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 93940 invoked by uid 99); 28 Apr 2005 03:23:52 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from extmail04.cingular.com (HELO cingular.com) (170.35.209.245)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 27 Apr 2005 20:23:52 -0700
Received: from ([135.214.26.238])
	by extmail04.cingular.com with ESMTP with TLS id KP-VXK07.34354766;
	Wed, 27 Apr 2005 23:20:20 -0400
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
Subject: RE: Is there a way to remove the quotation marks that ibatis inserts
 when using #[]# on the <iterate> tag?
Date: Wed, 27 Apr 2005 16:19:49 -0700
Message-ID: 
 <2FAA57A6845C664880384825E92D6AC901A82337@WA-MSG06-BTH.wireless.attws.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Is there a way to remove the quotation marks that ibatis inserts
 when using #[]# on the <iterate> tag?
Thread-Index: AcVEZusCpKQJ7SbkQW+tSFyAqh+X6AHGIRJw
To: "Brandon Goodin" <brandon.goodin@gmail.com>,
	<ibatis-user-java@incubator.apache.org>
X-OriginalArrivalTime: 27 Apr 2005 23:19:50.0150 (UTC)
 FILETIME=[9C155260:01C54B7F]
From: "Abeyratne, Sam" <sam.abeyratne@cingular.com>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hey Brandon,

Thanks for fixing this bug. I checked out a copy of ibatis from SVN and
tested with $[]$. It now takes literal values! Awesome!

Thanks again!
Sam

-----Original Message-----
From: Brandon Goodin [mailto:brandon.goodin@gmail.com]=20
Sent: Monday, April 18, 2005 3:35 PM
To: ibatis-user-java@incubator.apache.org; Abeyratne, Sam
Subject: Re: Is there a way to remove the quotation marks that ibatis
inserts when using #[]# on the <iterate> tag?

sorry, this appears to be a bug. Please file a JIRA report for this.

Brandon

On 4/18/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> Hi Brandon!
>=20
> My bad! Sorry about that. I did try the $[]$
>=20
> I am getting a different error I used to see sometime ago due to the
> syntax I was using.
>=20
> Basically, I get the error: There is no READABLE property named '' in
> class 'java.util.ArrayList'
>=20
> But like #[]#, I would have expected $[]$ to read the list I am
passing.
> Does this mean I can't use a List Array when using $[]$? What kind of
> test did you do to get it to work? Did you pass a list array as well?
>=20
> At least in my work, this will be an issue.
>=20
> 2005-04-18 13:34:24,638 [HttpRequestHandler-821] DEBUG
> pmt.InterfaceService.class - < viewTimeline
>=20
> 2005-04-18 13:34:24,638 [HttpRequestHandler-821] DEBUG
> pmt.InterfaceService.class - > viewInterfaceBacklogs
>=20
> 2005-04-18 13:34:24,638 [HttpRequestHandler-821] DEBUG
pmt.BaseDAO.class
> - Both connections active - attemption dual query
>=20
> 2005-04-18 13:34:24,698 [HttpRequestHandler-821] ERROR
> pmt.actions.PMTDispatchAction.class - Entered catch block -
verifyLogin:
> There is no READABLE property named '' in class 'java.util.ArrayList'
>=20
> THANK YOU AGAIN FOR ALL YOUR HELP!!
> Sam
>=20
> -----Original Message-----
> From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
> Sent: Monday, April 18, 2005 1:01 PM
> To: Abeyratne, Sam
> Subject: Re: Is there a way to remove the quotation marks that ibatis
> inserts when using #[]# on the <iterate> tag?
>=20
> why are you using a question mark? You should be using the dollar sign
> ($...$) syntax if you want the literals value without quotes.
>=20
> BAD: ?[]?
> GOOD: $[]$
>=20
> Brandon
>=20
> On 4/18/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> > Hey Brandon,
> >
> > I downloaded your latest build and tried using ?[]? While passing a
> > ListArray, but I am getting the following error:
> >
> > Cause: java.sql.SQLException: ORA-01729: database link name expected
> >
> > Any ideas?
> > Thanks!
> > Sam
> >
> > <select id=3D"queryInterfaceBacklogs_DUAL"
> parameterClass=3D"java.util.List"
> > resultMap=3D"interface_backlog_result"
> > cacheModel=3D"interface_backlog_cache">
> >       select
> >       interface_name as SYSTEM_NAME,
> >       sum(backlog_val) as BACKLOG_VAL,
> >       sum(backlog_last1) as BACKLOG_LAST1,
> >       sum(backlog_last2) as BACKLOG_LAST2,
> >       sum(backlog_last3) as BACKLOG_LAST3
> >       from
> >       (
> >       <iterate open=3D"(" close=3D")" conjunction=3D"UNION ALL">
> >         select
> >         a.interface_name,
> >         sum(decode(i.BACKLOG_VAL,'',0,i.BACKLOG_VAL)) as
BACKLOG_VAL,
> >         sum(decode(i.BACKLOG_LAST1,'',0,i.BACKLOG_LAST1)) as
> > BACKLOG_LAST1,
> >         sum(decode(i.BACKLOG_LAST2,'',0,i.BACKLOG_LAST2)) as
> > BACKLOG_LAST2,
> >         sum(decode(i.BACKLOG_LAST3,'',0,i.BACKLOG_LAST3)) as
> > BACKLOG_LAST3
> >         from INTERFACE_STATUS i,
> >           ( select distinct interface_name
> >           from interface@?[]?
> >           where category=3D'Provisioning'
> >           )a
> >         where SYSTEM_NAME is not null
> >         and a.interface_name =3D i.system_name
> >         group by a.interface_name
> >         </iterate>
> >       )
> >       group by interface_name
> >   </select>
> >
> > from INTERFACE_STATUS i,           ( select distinct interface_name
> > from interface@?[1]?           where category=3D'Provisioning'
> > )a         where SYSTEM_NAME is not null         and
a.interface_name
> =3D
> > i.system_name         group by a.interface_name         )       )
> > group by interface_name
> >
> > 2005-04-18 11:23:26,118 [HttpRequestHandler-74] DEBUG
> > java.sql.PreparedStatement - {pstm-100007} Parameters: []
> >
> > 2005-04-18 11:23:26,118 [HttpRequestHandler-74] DEBUG
> > java.sql.PreparedStatement - {pstm-100007} Types: []
> >
> > 2005-04-18 11:23:26,769 [HttpRequestHandler-74] DEBUG
> > com.ibatis.common.jdbc.SimpleDataSource - Returned connection 169 to
> > pool.
> >
> > 2005-04-18 11:23:26,779 [HttpRequestHandler-74] ERROR
> pmt.BaseDAO.class
> > - Exception caught in performDualQuery
> >
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred while applying a parameter map.
> > --- Check the queryInterfaceBacklogs_DUAL-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: ORA-01729: database link name
> expected
> >
> > Caused by: java.sql.SQLException: ORA-01729: database link name
> expected
> > at
> >
>
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
> > WithCallback(GeneralStatement.java:180)
> >
> >
> > -----Original Message-----
> > From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
> > Sent: Monday, April 18, 2005 10:16 AM
> > To: ibatis-user-java@incubator.apache.org
> > Subject: Re: Is there a way to remove the quotation marks that
ibatis
> > inserts when using #[]# on the <iterate> tag?
> >
> > Sam,
> >
> > $[]$ should work. I tested it this weekend and it worked fine.
> >
> > Brandon
> >
> > On 4/18/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> > > Hi Brice,
> > >
> > > That does not work. Simply because I am passing a list array. And
> for
> > a
> > > List the ibatis syntax is #[]#. I tried doing something like
#?[]?#
> > but
> > > that does not work.
> > >
> > > Thanks!
> > > Sam
> > >
> > > -----Original Message-----
> > > From: Brice Ruth [mailto:bdruth@gmail.com]
> > > Sent: Friday, April 15, 2005 6:32 PM
> > > To: ibatis-user-java@incubator.apache.org
> > > Subject: Re: Is there a way to remove the quotation marks that
> ibatis
> > > inserts when using #[]# on the <iterate> tag?
> > >
> > > use $ in place of the #, that way it won't be quoted.
> > >
> > > On 4/15/05, Abeyratne, Sam <sam.abeyratne@cingular.com> wrote:
> > > >
> > > >
> > > >
> > > > I want to use the <iterate> tag to create an sql statement.
> > > >
> > > >
> > > >
> > > > If I have something like table_name@#[]# and the first value in
> the
> > > list for
> > > > example is database1, it really translates to
> > table_name@'database1'.
> > > This
> > > > fails because of the single quotes. Is there a way to remove
these
> > > single
> > > > quotes? Meaning, translate table_name@#[]# to
table_name@mmsdev1?
> > > >
> > > >
> > > >
> > > > Any assiatnce would be much appreciated!
> > > >
> > > > Thanks!
> > > >
> > > > Sam
> > >
> > > --
> > > Brice Ruth
> > > Software Engineer, Madison WI
> > >
> > >
> >
> >
>=20
>