Thanks Ted, I switched it over to select ... from dual, and it worked quite
nicely. I shall have to remember this for the future.
Mike
-Original Message-
From: Ted Schrader [mailto:[EMAIL PROTECTED]
Sent: January 27, 2006 4:11 PM
To: user-java@ibatis.apache.org
Subject: Re: Select coun
tion.
Ted
On 27/01/06, Michael Laccetti <[EMAIL PROTECTED]> wrote:
>
>
>
> Is it possible to do a 'select count(*) from table' and then reference
that
> value in a result map? I've been searching around and trying to get it to
> work to no avail.
>
>
>
> Mike
Is it possible to do a ‘select count(*) from table’
and then reference that value in a result map? I’ve been searching around
and trying to get it to work to no avail.
Mike
-java@ibatis.apache.org
Subject: Re: iBATIS and Geronimo
It commits when it detects an actual change, but it's not compatible with all
drivers/transaction managers
Cheers,
Clinton
On 1/25/06, Michael
Laccetti <[EMAIL PROTECTED]>
wrote:
That seems to work. Does tha
, Michael
Laccetti <[EMAIL PROTECTED]
> wrote:
Has
anybody successfully used iBATIS and Geronimo, using the JTA transaction
manager? My code does not fail, and yet nothing is committed to the
database. I've asked the Geronimo guys, but they don't seem to know what
is going on.
Thanks,
Michael
Has anybody successfully used iBATIS and Geronimo, using the
JTA transaction manager? My code does not fail, and yet nothing is committed
to the database. I’ve asked the Geronimo guys, but they don’t seem
to know what is going on.
Thanks,
Michael
arry means iterating your list, that would still result in one query, but
one that works and still protects against SQL injection.
Niels
-Original Message-----
From: Michael Laccetti [c] [mailto:[EMAIL PROTECTED]
Sent: donderdag 8 december 2005 23:12
To: user-java@ibatis.apache.org
Subject: RE: Multip
t will work.
A better route would be to use iteration to do it.
Larry
On 12/8/05, Michael Laccetti [c] <[EMAIL PROTECTED]> wrote:
> I have the following statement defined in iBATIS:
>
>
> DELETE FROM ALERTS WHERE ID IN (#value#)
>
> I pass it a String in the form of
I have the following statement defined in iBATIS:
DELETE FROM ALERTS WHERE ID IN (#value#)
I pass it a String in the form of 322,321,320,319,318,317,316,315,314,313.
Now, when I call it, I get the following:
DEBUG [08 Dec 05 11:19:26] [http-8080-Processor23]
java.sql.PreparedStatement - {pst
f
trying the JNDI lookup in a plain old servlet without using iBATIS just to make
sure.
Jeff Butler
On 11/28/05, Michael
Laccetti [c] <[EMAIL PROTECTED]>
wrote:
I
followed that page to the letter. I know that it picks up the data
source, because originally there was a prob
/05, Michael
Laccetti [c] <[EMAIL PROTECTED]>
wrote:
Yeah, I
have also tried that. I've done a whole bunch of things, including
hacking apart the iBATIS source to see how it's going about getting a
context. Nothing strange, does the regular new InitialContext(), and
Jeff Butler
On 11/27/05, Michael
Laccetti [c] <[EMAIL PROTECTED]>
wrote:
Has
anybody used iBATIS with Geronimo? I've managed to get
Geronimoconfigured (with much help from them on IRC), but now I have a
problem with loading the SqlMap. For some reason it cannot
re
Has anybody used iBATIS with Geronimo? I've managed to get Geronimo
configured (with much help from them on IRC), but now I have a problem with
loading the SqlMap. For some reason it cannot resolve the JNDI name for the
data source. I keep getting:
com.ibatis.common.exception.NestedRuntimeExcep
jump in and show us how to pass in multiple
values into a select query from a result map.
You also might want to have a look at the "Avoiding N+1 Selects" part in the
documentation but that's after you get this working.
Zarar
----- Original Message -
From: "Michael Laccett
iding N+1 Selects" part in the
documentation but that's after you get this working.
Zarar
- Original Message -
From: "Michael Laccetti" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 17, 2005 4:37 PM
Subject: RE: Nested Lists [signed]
> So nobody has any id
So nobody has any ideas?
Mike
-Original Message-
From: Michael Laccetti [mailto:[EMAIL PROTECTED]
Sent: November 16, 2005 10:56 PM
To: user-java@ibatis.apache.org
Subject: Nested Lists [signed]
I've got a bit of a tricky question. I'm trying to retrieve a list of
object
I've got a bit of a tricky question. I'm trying to retrieve a list of
objects from the database. That's the easy part. The hard part is that two
properties in the object are also lists. So, when I call the list query, it
in turn will call two sub-queries to populate the properties. I've read
a
17 matches
Mail list logo