If I remember right, this stopped working with DB2 with the version DB2
version 8 JDBC drivers. We had some similar issues and had to remove all
our semicolons (we weren't trying to do multiple statements - just had some
random semicolons at the end of statements).
I'll say also that I generally
I'm attempting to perform two statements within a single insert. We are
using DB2 and I thought ; was the separator, but I get SQLSTATE: 42601. I
have tried several possible solutions with no luck. Has anyone seen this or
able to offer an idea? Is this even possible?
Thanks
Mike
On 3/10/08 8:25 PM, "" <> wrote:
> Thank you all again for your suggestions.
>
> One of the use cases of mine is to create an XML in the end. I don't have an
> object serve as a middle stage to use with Rowhandler (in RowHandler's term, I
> need to map the valueObject to something, right?).
No -
Ok thanks to everyone for the info. I've switched over to using the
update method since it is the correct usage. I thought it might be
something like that but wasn't sure since I was able to use queryForList
when passing in the HashMap. I did notice as Sundar mentioned that with
the HashMap you are
