Question
Self
IN
Last activity: 13 Mar 2024 12:37 EDT
There was a database problem when performing an RDBExecute: code: 0 SQLState: Message: Invalid column count. Cannot be less or equal to zero
Hi All, I get this error
There was a database problem when performing an RDBExecute: code: 0 SQLState: Message: Invalid column count. Cannot be less or equal to zero
My table is a basic one where im querying a country
SELECT "Country"
FROM data."country"
when i run the query in the database i get the value but when i try to use this in SQL connector and run my activity i face this issue.
Accepted Solution
Updated: 13 Mar 2024 12:37 EDT
Systems Limited
AE
Updated: 13 Mar 2024 12:37 EDT
LTIMindtree
IN
@SyedaZehraZ16928215 please update the query
SELECT Country FROM data.country;
there should not be quotes in table name post schema as you are not using alias the column you are fetching should also be exact.
Try using the above if not try with this and see if country is at all there or not.
Select * from data.country;
@SyedaZehraZ16928215 Please check if the property .Country is present in the class of that table.
If not create it.
If its present and still you are getting the same error then please define it in the external mapping of that class.
Regards,
Sushovan