(older archive entries before 2007 are not shown here, but included in the onsite-search)
Mailing List - Entries of 2014
|
[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]
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
|
