ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bitra, Venkateswararao \(Corporate, consultant\)" <venkateswararao.bi...@ge.com>
Subject RE: ANSI_PADDING
Date Fri, 29 Apr 2005 14:16:37 GMT
Need to use executeUpdate("SET ANSI_PADDING=OFF",null) method of SQLMAP class before executing
any sql statement and ofcourse after starting a transaciton.

-----Original Message-----
From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
Sent: Friday, April 29, 2005 9:14 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: ANSI_PADDING


Please tell us how you would accomplish this with straight JDBC. You
never really answered Clinton's question.

Brandon

On 4/29/05, Bitra, Venkateswararao (Corporate, consultant)
<venkateswararao.bitra@ge.com> wrote:
> You are right its not an IBATIS question. I just needed to use executeUpdate method to
execute "SET ANSI_PADDING=OFF/ON" statement.
> 
> -----Original Message-----
> From: Ron Grabowski [mailto:rongrabowski@yahoo.com]
> Sent: Tuesday, April 26, 2005 9:15 AM
> To: ibatis-user-java@incubator.apache.org
> Subject: RE: ANSI_PADDING
> 
> How is this an IBatis question? It sounds like you need to contact the
> database vendor and find out how to turn it off. If you were using
> straight JDBC, how would you turn padding off?
> 
> --- "Bitra, Venkateswararao (Corporate, consultant)"
> <venkateswararao.bitra@ge.com> wrote:
> > We never required to turn it off. Because in Pervasive 8.6 by default
> > it was turned off. But in Pervasive 9 its turned on and we need to
> > explicitly turn it off
> >
> > --Venkat
> >
> > -----Original Message-----
> > From: Clinton Begin [mailto:clinton.begin@gmail.com]
> > Sent: Sunday, April 24, 2005 3:38 PM
> > To: ibatis-user-java@incubator.apache.org
> > Subject: Re: ANSI_PADDING
> >
> >
> > How do you turn it off without iBATIS?
> >
> > Clinton
> >
> > On 4/24/05, Bitra, Venkateswararao (Corporate, consultant)
> > <venkateswararao.bitra@ge.com> wrote:
> > > Hi,
> > >         I user IBATIS layer for my Pervasive SQL database.
> > Pervasive SQL 9 came up with an option to deal with ANSI_PADDING
> > problem with datatype CHAR and VARCHAR. ANSI_PADDING is on by default
> > in Pervasive. I need to "set ANSI_PADDING off" for all my
> > transactions with Pervasive. Otherwise I have to trim all CHAR and
> > VARCHARS. And when I use this trimming in my where clauses I loose my
> > indexing advantage.
> > >         How can I set this ANSI_PADDING off for all my
> > transactions? Your help would be appreciated.
> > >
> > > thanks
> > >
> > > --Venkat
> > >
> > >
> >
>

Mime
View raw message