Subscribe to Mailing list

List Icon
Mailing list

2019 up to now | 2018 | 2017  |  2016  | 2015 | 2014 | 2013

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

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

  • Subject: Re: [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 17:07:25 +0000 (GMT)
  • Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=K7dlFMhdcHiH8sxRM5mfq20/hpEg2xkNA0RsWjv50wvr6gOofsDzeHUcG/qSjMQp0Ik+FftfY8jalR5xIPs3Y8BmrVpn2LMh77xzo8BALp52EIAjie/tdst4bu58Ko1YnnWcrMw68qpEznSAxvC0/sQjO9fRLtOCgzQNgWEzw8s=;
I think I've figured it out.
It might be a casting issue

select cast( COUNTRY_NAME as varchar(64)) from MySchema.country

works fine



Le Vendredi 28 février 2014 17h03, Gwenael Plantefeve <gwen0504@?.com> a écrit :

Hi,

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 MySchema.country
resultGroupName   
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:
cursor.execute(rc.lookup("statement"))


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

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

Thanks in advance for your help on this issue

Gwen


We use "Matomo" cookies to anonymously evaluate your visit to our website. For this we need your consent, which is valid for twelve months. A revocation, so-called opt-out, is possible at any time on our privacy page.

accept
configuration
Cookie configuration

1. Functional cookies

We use functional cookies to ensure the basic functionality of the website.

2. Performance and statistic cookies

We use Matomo for analyzing and optimizing our website. Cookies permit an anonymous collection of information that help us offering you a clear and user-friendly visit of our web pages.

Confirm selection

Cookie details