[news.eclipse.dtp] Re: Generating DDL from SQL Model

[alex.black@xxxxxxxxxxxxxxxxxx (Alex Black)]

Hi Der Ping,

I am trying to test generate DDL from a SQL Model with this:

	public static void main(String[] args) {
		SQLSchemaFactory sqlSchemaFactory = SQLSchemaFactory.eINSTANCE;
		
		Schema mySchema = sqlSchemaFactory.createSchema();
		Table myTable = SQLTablesFactory.eINSTANCE.createPersistentTable() ;
		myTable.setName("MyTable");
		Column column = SQLTablesFactory.eINSTANCE.createColumn();
		
		//set DataType
		DataType dataType = 
SQLDataTypesFactory.eINSTANCE.createBinaryStringDataType();
		column.setDataType(dataType);
		myTable.getColumns().add(column);
		mySchema.getTables().add(myTable);
		
		
		//pass schema to DDLGen
		GenericDdlGenerator gdg = new GenericDdlGenerator();
		String[] test = gdg.generateDDL(new SQLObject[]{(SQLObject)mySchema}, 
new NullProgressMonitor());
		System.out.println(test);
	}

Right now I get an NPE from 
org.eclipse.datatools.connectivity.sqm.core.containment.ContainmentServiceImpl.<init>(ContainmentServiceImpl.java:181). 

Did I miss anything out? Am I suppose to set a property via 
EngineeringOption[] , any help would be much appreciated.

Thanks,
Alex