http://planet.jboss.org/post/head_to_head_jboss_v_oracle_tca

Servers Mode

 Standalone mode is the most familiar to past JBoss Application Server users, and consists of an independent process. 

Domain mode allows multiple JBoss Application Server instances to be managed from a single domain controller spanning the same or different servers. 

Reference https://docs.jboss.org/author/display/AS7/Operating+modes 

Software release life cycle

Replace Null by zero in SQL

There is the COALESCE method which return the first non-null parameter, in your case :

COALESCE(field, 0)

But you can use this if you want more :

COALESCE(field1, field2, 0)

PENTAHO PARAMETERS AND VARIABLES

http://diethardsteiner.blogspot.com/2013/07/pentaho-kettle-parameters-and-variables.html 

ETL

http://it.toolbox.com/blogs/infosphere/17-mistakes-that-etl-designers-make-with-very-large-data-19264 

Queries Order by

SELECT * FROM tickets
ORDER BY FIELD( id, 1,2,3,4);