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
.
--- Cause: java.sql.SQLException: Invalid parameter index 1.
Alin
-Original Message-
From: Jeff Butler [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 3:30 PM
To: user-java@ibatis.apache.org
Subject: Re: linked server with list parameter
Have you enabled logging to see what statement
, October 06, 2008 3:33 PM
To: user-java@ibatis.apache.org
Subject: Re: linked server with list parameter
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
, October 06, 2008 4:47 PM
To: user-java@ibatis.apache.org
Subject: RE: linked server with list parameter
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
only numbers).
Niels
-Original Message-
From: Tomoiaga, Alin [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 11:55 PM
To: user-java@ibatis.apache.org
Subject: RE: linked server with list parameter
Do you mean the openquery syntax?
select * from openquery(LINKED_SERVER, 'remote
Hi,
I am trying to join two tables across a linked server while
iterating through a list parameter .
I haven't been able to find the right syntax for this to work.
The below statement is not working:
statement id=linkedServerWithListParameter