Kettle Javascript Job Entry

alert.js

try
{
	// Something
}
catch (error)
{
	var spoon = Packages.org.pentaho.di.core.gui.SpoonFactory.getInstance();
	spoon.messageBox(
		error.message, error.name,
		true, Packages.org.pentaho.di.core.Const.INFO
	);
}

sql.js

var databases = parent_job.getJobMeta().getDatabases();
var db = new Packages.org.pentaho.di.core.database.Database(
	parent_job, Packages.org.pentaho.di.core.database.DatabaseMeta.findDatabase(databases, "DB_Name")	
);

db.connect();
var rs = db.openQuery("SELECT id FROM t1"); rs.next();
var id = rs.getLong(1);
db.disconnect();

parent_job.getLogChannel().logBasic(java.lang.Long.toString(id));