I have configured a new datasource [for an oracle database] in CPSC and it is listed in the designer for the data retrieval rule.
I got ther "SQLHelper can not connect to datasource: java:/TestDS" when I click the 'Next' button after entering the SQL Query
SELECT fn_test_Connectivity('abcdef') FROM dual.
I haven't faced this issue earlier with the other datasources we have in place. This is a new datasource I have created.
Appreciate your help on this!
Thanks,
Guna Subramanian