public DataSetHandle createDataSet(String dataSetName, String dataSourceName, String queryText) {
    OdaDataSetHandle dataSetHandle = elementFactory.newOdaDataSet(dataSetName, "org.eclipse.birt.report.data.oda.xml.dataSet");
    try {
      dataSetHandle.setDataSource(dataSourceName);
      dataSetHandle.setName(dataSetName);
      dataSetHandle.setQueryText(queryText);
    } catch (SemanticException e) {
      logger.error("Data source name: " + dataSourceName + " could not be set!", e);
    }
    return dataSetHandle;
  }

    OdaDataSetHandle de = (OdaDataSetHandle) ds;
    CachedMetaDataHandle cachedMeta = de.getCachedMetaDataHandle();
    List<?> cols = (List<?>) cachedMeta.getResultSet().getValue();
    for (int i = 0; i < cols.size(); i++) {
      ResultSetColumn rsc = (ResultSetColumn) cols.get(i);
      String name = rsc.getColumnName();
      System.out.println(name);
    }

//all report engine initialization code...
//IReportRunnable design = eng.openReportDesign("C:/temp/ttt.rptdesign");

        	  List<OdaDataSetHandle> dataSets = design.getDesignHandle().getDesignHandle().getAllDataSets();
        	  for(OdaDataSetHandle temp : dataSets){
        		  System.out.println("DataSource - "+temp.getQueryText());
        		  System.out.println(temp.getDataSourceName());
        		  /*System.out.println(temp);
        		  if(temp instanceof DataSetHandle){
        			  System.out.println(((DataSetHandle)temp).getDataSourceName());
        		  }*/
        	  }
        	  
        	  List<OdaDataSourceHandle> dataSources = design.getDesignHandle().getDesignHandle().getAllDataSources();
        	  for(OdaDataSourceHandle temp : dataSources){
        		  System.out.println("getDriverName - "+temp.getDriverName());
        		  System.out.println(temp.getDisplayName());
        		  /*System.out.println(temp);
        		  if(temp instanceof DataSetHandle){
        			  System.out.println(((DataSetHandle)temp).getDataSourceName());
        		  }*/
        	  }

// Configure the Engine and start the Platform
		DesignConfig config = new DesignConfig();
		
		config.setBIRTHome(" ");
		IDesignEngine engine = null;

		OdaDataSourceDesign odaDataSource;

		DataEngine de = null;

		de = DataEngine.newDataEngine(config, null);
		odaDataSource = new OdaDataSourceDesign("Test Data Source");
		odaDataSource.setExtensionID("org.eclipse.birt.report.data.oda.jdbc");
		odaDataSource.addPublicProperty("odaURL", "jdbc:classicmodels:sampledb");
		// sourceHandle.getProperty("odaURL").toString() );
		odaDataSource.addPublicProperty("odaDriverClass","org.eclipse.birt.report.data.oda.sampledb.Driver");// sourceHandle.getProperty("odaDriverClass").toString());
		odaDataSource.addPublicProperty("odaUser", "ClassicModels");// sourceHandle.getProperty("odaUser").toString()
																	// );
		odaDataSource.addPublicProperty("odaPassword", "");
		
		OdaDataSetDesign odaDataSet = new OdaDataSetDesign("Test Data Set");
		odaDataSet.setDataSource(odaDataSource.getName());
		odaDataSet.setExtensionID("org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");
		odaDataSet.setQueryText("Select ORDERNUMBER from orders");// dsh.getQueryText()
																	// );

		de.defineDataSource(odaDataSource);
		de.defineDataSet(odaDataSet);

		QueryDefinition queryDefinition = new QueryDefinition();
		queryDefinition.setDataSetName(odaDataSet.getName());
		queryDefinition.setAutoBinding(true);

		IPreparedQuery pq = de.prepare(queryDefinition);

		IQueryResults qr = pq.execute(null);

		IResultIterator ri = qr.getResultIterator();
		int cc = ri.getResultMetaData().getColumnCount();
		IResultMetaData rsmd = ri.getResultMetaData();

		while (ri.next()) {
			for (int i = 0; i < cc; i++)
				System.out.print(ri.getValue(rsmd.getColumnName(i + 1)) + " ");

			System.out.println("");
		}

		ri.close();
		qr.close();
		de.shutdown();

		System.out.println("Finished");