Our sample solution is based on lowercase names for columns.
The Oracle driver makes use of uppercase names for columns at the moment of writing.
Solution: change all column names in the source from lowercase to uppercase and the sample solution will work.
Hans Nieuwenhuis (Betagraphics) created below instructions to make the 'Control Center' sample work:
Search and replace in methods
"task_name" to "TASK_NAME"
"name" to "NAME"
"start_date" to "START_DATE"
"end_date" to "END_DATE"
"hierarchy_code" to "HIERARCHY_CODE"
"progress" to "PROGRESS"
"task_id" to "TASK_ID"
"group_id" to "GROUP_ID"
"workload" to "WORKLOAD"
"link_id" to "LINK_ID"
"predecessor_id" to "PREDECESSOR_ID"
"successor_id" to "SUCCESSOR_ID"
"link_type" to "LINK_TYPE"
"working_hours_id" to "WORKING_HOURS_ID"
"information" to "INFORMATION"
"count" to "COUNT"
"load" to "LOAD"
"duration" to "DURATION"
"resource" to "RESOURCE"
"start_not_earlier_date" to "START_NOT_EARLIER_DATE"
Rename table Columns
alter table it2be_task rename column "load" to "LOAD";
alter table it2be_task rename column "resource" to "RESOURCE";
alter table it2be_group rename column "count" to "COUNT";
alter table it2be_group rename column "resource" to "RESOURCE";