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: Trying to pass in [oracle] where clause with ' like #variable#' phrase with #variable# already formed
Date Wed, 13 Sep 2006 22:14:49 GMT
No problem.  Look in the Developer's Guide.  There's a section on logging.
This will enable you to see the statement and parameter values as they are
sent to the database.

Jeff Butler



On 9/13/06, Morone, Bill <Morone.Bill@pennmutual.com> wrote:
>
>  Jeff,
>
> Please forgive my newbie-ness When you say "turn on logging" what do you
> mean -- is there a way for me to determine the statement?
>  -----Original Message-----
> *From:* Jeff Butler [mailto:jeffgbutler@gmail.com]
> *Sent:* Wednesday, September 13, 2006 5:41 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: Trying to pass in [oracle] where clause with ' like
> #variable#' phrase with #variable# already formed
>
> On first glance it looks OK to me.  Probably it would help to turn on
> logging and see the actual statement that is sent to the DB.
>
> Jeff Butler
>
>
> On 9/13/06, Morone, Bill <Morone.Bill@pennmutual.com> wrote:
> >
> >  Hello,
> >
> > I tried searching the mailing list for "where...like" entries but
> > couldn't find any.
> >
> > I am using sqlMaps 2.1.7.
> >
> > I am trying to run this [snippet] statement:
> > ...
> > <isNotEmpty property="firstName">
> >     and upper(c.first_nm) like #firstName#
> > </isNotEmpty>
> > ...
> >
> > I have created the firstName variable ala' [simplified]:
> >
> > String firstName = new String("S%");
> >
> > and placed it into a Map under "firstName".
> >
> > There has yet to be a functional index created on Oracle for the
> > c.first_nm.
> >
> > I don't return any records -- is there anything obvious I am doing
> > wrong? Can someone give me some "like" examples?
> >
> > Thanks,
> > Bill Morone
> >
> >
> >
> > This message, including any attachments, is intended only for the recipient(s)
> > named above. It may contain confidential and privileged information. If you have
> > received this communication in error, please notify the sender immediately and
> > destroy or delete the original message. Also, please be aware that if you are not
> > the intended recipient, any review, disclosure, copying, distribution or any
> > action or reliance based on this message is prohibited by law.
> >
> >
> >
>  This message, including any attachments, is intended only for the recipient(s)
> named above. It may contain confidential and privileged information. If you have
> received this communication in error, please notify the sender immediately and
> destroy or delete the original message. Also, please be aware that if you are not
> the intended recipient, any review, disclosure, copying, distribution or any
> action or reliance based on this message is prohibited by law.
>
>
>

Mime
View raw message