SQLEP 1.7.6 Tutorial - hudec/sql-processor GitHub Wiki

##The tutorial is updated for SQLEP 1.7.6+

###Introduction The new feature of the SQL Processor Eclipse Plugin (SQLEP) version 1.7.5 is the possibility to speed the initial definitions.qry provision using one of the next templates (they are offered after crtl-SPACE)

• db2
• hsqldb
• informix
• mysql
• oracle
• postgresql

For example using the template oracle the next control directives are placed into definitions.qry

resolve-pojo-on;
database-is-online;
database-jdbc-driver :oracle.jdbc.OracleDriver;
database-has-url jdbc:oracle:thin:@TODO_DB_SERVER:1521:TODO_SID;
database-login-username TODO_DB_USER;
database-login-password TODO_DB_PASSWORD;
database-active-schema TODO_DB_SCHEMA;
database-take-comments;

pojogen-generate-wrappers;
pojogen-generate-methods toString equals hashCode isDef toInit;
pojogen-implements-interfaces java.io.Serializable;
pojogen-generate-operators;
pojogen-generate-validation-annotations;

metagen-global-sequence TODO_SEQUENCE_NAME;

Next, all uppercase values should be change based on your environment.