what version are you using? We haven't seent his behavior anywhere
else in our unit tests or from users.
Brandon
On 6/17/05, Narasimha Prasad <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi
>
>
>
> I observed that when queries are constructed by ibatis, it prepends a
> character 'N' to the param
why are we cc'ing the old alias?On Jun 16, 2005, at 2:05 PM, Clinton Begin wrote: Bing, Don't you should call start/commit/end transaction in iBATIS regardless of the outer transaction. iBATIS will not commit the transaction prematurely, but it will manage the resources (like connections properl
Hi
I observed that when queries are constructed by ibatis, it
prepends a character ‘N’ to the parameters. Is there a
way to turn this off ?
Eg: (Say regionCodeList contains two regions, East and West)
prepend="AND" property="regionCodeList">
Project.regionCode
Clinton Begin wrote:
Hey Vic,
>>When doing large inserts in loops; for performance it's best to have the
>>commint/rollback and start batch outside of the loop?
Yes, absolutely. Not only for performance, but otherwise it wouldn't be
"a" transaction would it? :-)
THX!
.V
Hey Vic,
>>When doing large inserts in loops; for performance it's best to have the
>>commint/rollback and start batch outside of the loop?
Yes, absolutely. Not only for performance, but otherwise it wouldn't be "a" transaction would it? :-)
>>Do we have to have transactions of can we just us
So for us SQL newbies, if we can put up w/ a bit more:
When doing large inserts in loops; for performance it's best to have the
commint/rollback and start batch outside of the loop?
Do we have to have transactions of can we just use start/execute batch?
(and what if I want the insert to comm
fromDate is numeric?
On 6/17/05, Esa Kylli <[EMAIL PROTECTED]> wrote:
> I tried with the inline syntax, but unfortunately it didn't work.
>
> I changed the SQL to:
> SELECT callsign, vessel, estBerthDate, estBerthTime, taDate, taTime,
> berthDate, berthTime, berth, agent FROM tbl_ArrDep WHERE ty
thanks kris.
On 6/16/05, Kris Jenkins <[EMAIL PROTECTED]> wrote:
> Hi Andy,
>
> 'InlineParameterMap' is the name for the map that's auto-generated when
> you just supply a parameterClass.
>
> I think your problem is in the dynamic WHERE. Imagine this scenario:
>
> SELECT *
> FROM table_x
>
Congrats guys!
The new site looks nice! (esp for an apache site ;) )
Clinton Begin wrote:
Sorry, used a tankard. ;-)
On 6/6/05, *netsql* <[EMAIL PROTECTED] > wrote:
.V
Ted Husted wrote:
> Recently, the Apache Software Foundation Board of Directors approved
>
I tried with the inline syntax, but unfortunately it didn't work.
I changed the SQL to:
SELECT callsign, vessel, estBerthDate, estBerthTime, taDate, taTime, berthDate,
berthTime, berth, agent FROM tbl_ArrDep WHERE type = #type:NUMERIC# AND
callsign like #callsign:VARCHAR# AND estBerthDate >= #fr
Are you saying that it fails if searchValue is a list?
On 6/14/05, Justiniano, Miguel <[EMAIL PROTECTED]> wrote:
> I am currently trying to implement a sql map that will execute a query with
> a variable list of search filters like so:
>
> resultClass="java.lang.String">
> select name
>
I'm not completely sure from your example where a "list value" would
fit into that and how you are expecting it to be rendered. Please
provide more detail.
Brandon
On 6/14/05, Justiniano, Miguel <[EMAIL PROTECTED]> wrote:
> I am currently trying to implement a sql map that will execute a query wi
I am currently trying to implement a sql map that will execute a query with
a variable list of search filters like so:
select name
from itemTable
where id = #id#
$filterList[].columnName$ $filterList[].comparator$
#filterList[].searchValue#
13 matches
Mail list logo
