The mailing list has been closed since July 2022, but continues to serve as an archive of information about QF-Test.
If you want to stay informed about news about QF-Test, you can simply subscribe to our newsletter:
Subscribe to Newsletter
[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]
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
|
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.
This cookie contains a unique, pseudonymized visitor ID internal to Matomo for recognizing returning visitors.
This cookie is used to track from which website the anonymized user proceeded to our website.
The Matomo session cookie is used to track the visitor's page requests during the session.
is created and should be then directly deleted (used to check whether the visitor’s browser supports cookies).
short lived cookies used to temporarily store data for the visit.
short lived cookies used to temporarily store data for the visit.