There was a database problem when performing an RDBExecute: code: 0 SQLState: Message: Invalid column count. Cannot be less or equal to zero

General
, ,
1

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.

2

@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

3

@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;