Thanks 4 the reply ... I know the procedure isn't returning data ... my
question is, can you see anything wrong with the way i've set my sql maps
related config that is subsequently causing no data to be returned?
The cursor output parameter needs to be passed into the stored proc as an
input
I did it and works fine.
Thanks to everyone
Regards
2008/10/4 Clinton Begin [EMAIL PROTECTED]:
The differences between JDBC and EXTERNAL are simply that EXTERNAL does
NOTHING when commit and rollback are called (which works for 99% of managed
transaction containers).
Should not you use CDATA sections to get quotation marks intact in your SQL
? And like Jeff pointed out, look at the generated statements in your log
Why are you using quotes for the inner SELECT? You now have a query
without any parameters, hence the error.
Niels
-Original Message-
From: Tomoiaga, Alin [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 11:42 PM
To: user-java@ibatis.apache.org
Subject: RE: linked server with
Hi. Thank you for your answer.
I enabled debugging and the quotes seem to go through to the database ('select
ID ...'):
select * from openquery(LINKED_SERVER,
'select ID from REMOTE_TABLE
where NAME in( ?, ?)
') RT
left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
I am guessing there is
Do you mean the openquery syntax?
select * from openquery(LINKED_SERVER, 'remote query') ?
I was trying to mimic the openquery syntax in ibatis.
Is there another way to do this with ibatis?
Thank you,
Alin
-Original Message-
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Monday,
I'm not familiar with the openquery syntax, you should at least get it
working by using $'s instead of #'s, but that I don't know what that
does with your query plans. Also, be sure that you are checking input,
since this solution is vulnerable to SQL injection (no problem if the
list contains