Forum Discussion

cbyndr's avatar
cbyndr
Contributor
16 years ago

results of mysql query in jdbc data source are all null

Has anyone run up against this? 1. create jdbc data source, prop transfer, test request, datasource loop steps 2. configure, test jdbc datasource - datasource is mysql - mysql drivers al...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
16 years ago
Hi,

I'm very sorry for such a delay in answering your question.
Property name must match the column name you are selecting, i.e. if you have "select col1 from table1" property name must be col1 (of course you can use something like 'select table1.some_col as col1 from table1' as well).
Please check if this might be the source of your problem and let us know if you need further help.

Regards,
Dragica
/eviware.com