"org.apache.derby.jdbc.EmbeddedDriver",
"jdbc:derby:memory:ebookshop",
"select * from books"),
"Data Source");
GenericDataSink sink = new GenericDataSink(new JDBCOutputFormat(), "Data Output");
JDBCOutputFormat.configureOutputFormat(sink)
.setDriver("org.apache.derby.jdbc.EmbeddedDriver")
.setUrl("jdbc:derby:memory:ebookshop")
.setQuery("insert into newbooks (id,title,author,price,qty) values (?,?,?,?,?)")
.setClass(IntValue.class)
.setClass(StringValue.class)
.setClass(StringValue.class)
.setClass(FloatValue.class)
.setClass(IntValue.class);
sink.addInput(source);
return new Plan(sink, "JDBC Example Job");
}