List Icon
Archiv Mailingliste

2019 bis Juli 2022  2018  | 2017 2016 2015 | 2014 | 2013

Die Mailingliste ist seit Juli 2022 geschlossen, dient aber weiterhin als Informationsarchiv zu QF-Test.
Wenn Sie über Neuerungen zu QF-Test informiert bleiben wollen, können Sie einfach unseren Newsletter abonnieren:
Newsletter abonnieren

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[QF-Test] Procedure "executeSelectStatement" with sample Select Query returning error getting index [1], type [-9] [SQLCode: 0]

  • Subject: [QF-Test] Procedure "executeSelectStatement" with sample Select Query returning error getting index [1], type [-9] [SQLCode: 0]
  • From: Gwenael Plantefeve <gwen0504@?.com>
  • Date: Fri, 28 Feb 2014 16:03:26 +0000 (GMT)
  • Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024;; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=PzVgv0Xj5ADpfY5UhTwIPHfXqp9VtuKbcjRfXFdiMH8r+tz35G/FZxIgKcYVIJULE98QaEvGotbhkj/75PcGrl45qlAXsdGJenGYNvXpWtfQzZalhSiEWarPe/9xaG8YtxiVgw/SPyprtupz3znuhc9tAPVfr+F5ruzcyR20olo=;


I am trying to call the "qfs.database.executeSelectStatement" procedure to query an Oracle Database.

Here are the following input parameters:
driver    oracle.jdbc.driver.OracleDriver
connectionString    jdbc:oracle:thin:@MyServer:MyPortNum:MySID
dbUser    myUser
dbPass    ****
statement    select COUNTRY_NAME from
throwExceptionOnDuplicateColumns    false

Within "Plugin" folder I put the following Oracle Driver jar: ojdbc6_g.jar

I keep getting the following error message:
The following error was encountered:
Exception during executing statement : error getting index [1], type [-9] [SQLCode: 0]

When debuging Jython code of "qfs.database.executeSelectStatement", I can see the connection is fine and the error occurs at the following line:

Note if I modify the query to count(*) (eg select count(*) from
It works fine.

So I can't figure out why sample query such as "select COUNTRY_NAME from" is not working as well?

Thanks in advance for your help on this issue