Skip to content

Home

Jump to bottom Edit New page
Vladimír Hudec edited this page Jun 3, 2013 · 54 revisions

SQLEP - smart working with the SQLP artifacts / Tutorials

The SQL Processor (SQLP) is an engine producing the ANSI SQL statements and providing their execution without the necessity to write Java plumbing code related to the ORM or JDBC API. The input to the SQL Processor is

  • a search form (or a question form or the input values), which is just a POJO. Typically this form is seeded by an end user in a presentation layer of a web application.
  • a META SQL query or statement, which is an enhanced ANSI SQL statement. This enhancement is defined in ANTLR based grammar. All the META SQL statements are defined in the meta statements file.
  • an output mapping rule, which is a mapping prescription from an SQL query result to the Java output classes values. This prescription syntax is again defined in ANTLR based grammar. All the mapping rules are also defined in the meta statements file.

Based on the inputs the final SQL query/statement is generated. The parameters are bounded and finally this query/statement is executed. This process is known as a Data Driven Query. The binding of the input values is done using the Reflection API, without any Java plumbing code. The output of the SQL Processor is

  • a list of result class instances (or data transfer objects or the output values). Each result class instance is created using the Reflection API, again without any Java plumbing code.

The SQL Processor Eclipse Plugin (SQLEP) enables smart edition of the SQL Processor (SQLP) artifacts, POJO and DAO modelling and SQLP artifacts generation based on DB model (including all META SQL statements, POJO and DAO Java code).

This site is primarily dedicated to the SQLEP. The SQLP can found at https://github.com/hudec/sql-processor/wiki.

###Available resources The SQL Processor Eclipse Plugin is available from the next P2 repos:

The latest version of the SQLEP can be also downloaded from

###More resources

News

June 3rd, 2013

The new tutorial SQLP 2.2.1 and SQLEP 1.7 Tutorial is ready.

May 31th, 2013 - Version 1.7.0

The SQLEP version 1.7.0 is ready and released. More details can be found in the upcoming SQLP 2.2.1 and SQLEP 1.7 Tutorial.

May 14th, 2013

The new tutorial SQLP 2.2.0 and SQLEP 1.6 Tutorial is ready.

May 10th, 2013 - Version 1.6.0

The SQLEP version 1.6.0 is ready and released. The main goals are

More details can be found in the upcoming SQLP 2.2.0 and SQLEP 1.6 Tutorial.

April 13th, 2013

The new tutorial SQLP 2.1.1 and SQLEP 1.5 Tutorial is ready.

April 10th, 2013

The SQLP and SQLEP code and sites have been split

April 9th, 2013 - Version 1.5.0

The SQLEP version 1.5.0 is ready and released. The main goals are

  • the pojogen generates POJOs based on DB procedures and functions
  • the metagen generates META SQL statements based on DB procedures and functions
  • the daogen generates DAOs based on DB procedures and functions
  • supported databases: Oracle, HSQLDB, MySQL, PostgreSQL, Informix, DB2
  • Archetypes updated, JDBC and Spring stack
  • Simple samples updated for all supported databases

More details can be found in the upcoming SQLP 2.1.1 and SQLEP 1.5 Tutorial.

The older news can be found at Older News

Add a custom footer

Table of Contents

Clone this wiki locally