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 already added to path, of course
3. create simple query and property for data source.
- property: tn
- query: select col from table
4. Run data source step:
Data source "Got 13 rows" as expected, but results are all null. I can run the same query from squirrel, and get 13 non-null values.
Attached screen shot to show the result set with all null.
[Note: I deleted the query before taking the screen shot]
1. create jdbc data source, prop transfer, test request, datasource loop steps
2. configure, test jdbc datasource
- datasource is mysql
- mysql drivers already added to path, of course
3. create simple query and property for data source.
- property: tn
- query: select col from table
4. Run data source step:
Data source "Got 13 rows" as expected, but results are all null. I can run the same query from squirrel, and get 13 non-null values.
Attached screen shot to show the result set with all null.
[Note: I deleted the query before taking the screen shot]
