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

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

Prev by Date: [QF-Test] How to scroll down the page of Web Browser client?
Next by Date: Re: [QF-Test] How to scroll down the page of Web Browser client?
Previous by thread: [QF-Test] Procedure "executeSelectStatement" with sample Select Query returning error getting index [1], type [-9] [SQLCode: 0]
Next by thread: [QF-Test] How to scroll down the page of Web Browser client?
Index(es):
- Date
- Thread