SQL Processor News - hudec/sql-processor GitHub Wiki
News
April 4th, 2024 - Version 3.6.1
JDK 21
MSSQL, Informix and DB2 are no more supported.
Hibernate is also no more supported.
March 8th, 2020 - Version 3.5.0
JDK 11
January 6th, 2019 - Version 3.3.6
The new SQLP 3.3.6 is ready. Some minority bugs are fixed.
October 23th, 2018 - Version 3.3.5
The new SQLP 3.3.5 is ready. Spring part is based on new Spring 5.
August 16th, 2017 - Version 3.3.3
The new SQLP 3.3.3 is ready. There's one minority change - a new attribute sqlName in SqlControl.
May 9th, 2017 - Version 3.3.2
The new SQLP 3.3.2 is ready. This is the first version for Java 8 (Java 7 is not supported). Also new Java 8 date/time types are natively supported (LocalDate, LocalTime, LocalDateTime and Instant).
November 8th, 2016 - Version 3.2.2
The new SQLP 3.2.3 is ready. There is a new sql command execution callback handler of type SqlExecutionCallback in SqlControl.
November 7th, 2016 - Version 3.2.2
The new SQLP 3.2.2 is ready. There is a new low level callback handler of type LowLevelSqlCallback in SqlControl. For the usage please see the sample simple-hsqldb.
October 30th, 2016 - Version 3.2.1
The new SQLP 3.2.1 is ready. Due to support NoSQL databases (mainly Cassandra), the SqlFeature has been extended. There are two new optional features COLLECTIONS_ARE_STANDARD_TYPES and SKIP_ALIASES_IN_SQL_COMMAND.
October 16th, 2016 - Version 3.2.0
The new SQLP 3.2.0 is ready. Due to support NoSQL databases (mainly Cassandra), the SqlMetaType has been completely refactored. For a custome type example please see Custom-Types-Tutorial.
June 23th, 2016 - Version 3.1.9
The new SQLP 3.1.9 is ready. In this release there's a new attribute skipEmptyStatement in SqlControl. It can be used for INSERT and UPDATE statements to skip SQL execution in the case there are no bounded input values.
April 16th, 2016 - Version 3.1.8
This release is aligned with the upcoming SQLMEP/SQLMOP 2.6.0.
February 21th, 2016 - Version 3.1.6
The new SQLP 3.1.6 is ready. In this release all samples have been consolidated. Also the new database H2 is supported. The new sample can be found at https://github.com/hudec/sql-processor/tree/master/simple-samples/simple-h2.
This SQLP is aligned with SQLMEP/SQLMOP 2.5.1.
February 11th, 2016 - Version 3.1.5
The new SQLP 3.1.5 is ready. In this release the cache processing id has been improved. For this purposes there's a new plugin SqlProcessingIdPlugin.
This release is aligned with the upcoming SQLMEP/SQLMOP 2.5.0. For more info please see SQLP 3.1.5 Tutorial.
January 18th, 2016 - Version 3.1.3
The new SQLP 3.1.3 is ready. In this release only minor bug fixes were provided.
January 3rd, 2016 - Version 3.1.2
The new SQLP 3.1.2 is ready. In this release only minor bug fixes were provided.
October 12th, 2015 - Version 3.1.1
The SQLP version 3.1.1 is available.
In this release there are new ordering types - ASC_NULLS_LAST and DESC_NULLS_FIRST.
September 5th, 2015
There's a new high level document [SQL Processor Architecture](https://github.com/hudec/sql-processor/wiki/SQL Processor Architecture).
August 21th, 2015 - Version 3.1.0
The SQLP version 3.1.0 is available.
In this release the SqlStandardControl has a new attribute dynamicUpdateValues. This attribute can hold input values for the SET fragment of the SQL Update statement (in this case the dynamicInputValues hold the input values for the WHERE fragment of the SQL Update statement). Next new feature is the {#ID order by ...} META SQL fragment can use identifier instead of number.
This release is aligned with the SQLMEP/SQLMOP 2.4.0. For more info please see SQLP 3.1.0 Tutorial.
August 14th, 2015 - Version 3.0.0
The SQLP version 3.0.0 is available.
This is the first release based on Java7. In this release the asynchronous initialization of the SQLP has been introduced. For more info please see SQLP 3.0.0 Tutorial. This is the second step in overall SQLP improvement (after the lazy initialization feature).
July 22th, 2015 - Version 2.9.0
The SQLP version 2.9.0 is available.
In this release the optional features have been completely refactored. There's a new enumeration class SqlFeature. Default features can be found in SqlDefaultFeatures.
This is the last release based on Java 6. The upcoming release 3.0.0 will be based on Java7.
July 13th, 2015 - Version 2.8.0
The SQLP version 2.8.0 is available.
In this release there is a new BeanUtils library independent from Apache Commons BeanUtils including new façade BeanUtils API. BeanUtils, which is dependent on Apache Commons BeanUtils, has been moved to sql-processor-beans. For more info please see SQLP 2.8.0 Tutorial.
June 28th, 2015 - Version 2.7.0
The SQLP version 2.7.0 is available.
In this release there's a new dynamic SQLP configuration together with the enhanced JMX interface. The SQLP Engines instantiation has been also improved. For more info please see SQLP 2.7.0 Tutorial.
May 21th, 2015 - Version 2.6.2
The new 2.6.2 is ready and aligned with the new SQLMEP and SQLMOP 2.3.0 plugins.
In this release there's a small arguable change in SqlControl - all native attributes have been replaced with their native wrappers.
May 3rd, 2015 - Version 2.6.0
The new 2.6.0 is ready and aligned with the new SQLMEP and SQLMOP 2.2.0 plugins.
In this release there's a new API devoted to process database rows in sequence. For more info please see Database row processing.
April 6th, 2015 - Version 2.5.3
The new SQLP 2.5.3 is ready and aligned with the new SQLMEP and SQLMOP 2.1.1 plugins.
(In the SQLP 2.5.1 and 2.5.2 only minor bug fixes were provided)
February 4th, 2015 - Version 2.5.0
The SQLP version 2.5.0 is available. This version is aligned with SQLEP 2.0.0. All samples have been updated for new SQLEP Grammar. For more info please see SQLEP 2.0.0 Tutorial.
December 15th, 2014 - Version 2.4.1
The SQLP version 2.4.1 is available. The SqlControl has been extended - there's a new attribute fetchSize.
September 18th, 2014 - Experimental Version 2.4.0
The SQLP version 2.4.0 is available. This version is an experimental one, not appropriate for a production! Due to support the new experimental feature Common processing cache rather a big runtime refactoring has been done. There's a new public SqlRuntimeContext interface on top of enhanced SqlProcessContext and some minor public API has been changed (like the plugins API). The main change is done in the background - all thread local context variables have been move into SqlProcessContext.
September 14th, 2014 - Version 2.3.5
The SQLP version 2.3.5 is available. In this release just a couple of minor fixes is provided. For more info please see issues related to this release.
September 2nd, 2014 - Version 2.3.4
The SQLP version 2.3.4 is ready and released. There are two new principal features
- a more precise SQL Monitor (to distinguish the SQLP and DB processing time). The basic usage is presented in Advanced Catalog Sample
- a sophisticated and rather complicated common processing cache to speed up the runtime
More info can be found in the upcoming tutorial Common processing cache.
August 25th, 2014 - Version 2.3.3
The SQLP version 2.3.3 is ready and released. There are two new principal features
- dynamic META SQL statements (redefinition of static ones in the runtime)
- simple JMX interface for new dynamic behaviour in the runtime
More info can be found in the tutorial Dynamic SQL Statements and JMX API.
July 31th, 2014 - Version 2.3.2
The SQLP version 2.3.2 is ready and released. The only new feature is a lazy initialization of SQLP.
July 27th, 2014 - Version 2.3.1
The SQLP version 2.3.1 is ready and released. The main goals are
- the new SQL execution plugin and it's Simple SQL execution plugin implementation.
May 18th, 2014
The tutorial SQLP 2.3.0 and SQLEP 1.8.0 Tutorial is ready.
May 10th, 2014 - Version 2.3.0
The SQLP version 2.3.0 is ready and released. The main goals are
- database MSSQL is fully supported
- a new simple sample based on MSSQL can be found at simple-mssql
- to unify sequences and identities handling, the new concept - ID generator has been introduced
More info can be found in the upcoming SQLP 2.3.0 and SQLEP 1.8.0 Tutorial.
May 3rd, 2014 - Version 2.2.9
The SQLP version 2.2.9 is ready and released. Only the minor bugs were fixed in this release.
December 29th, 2013 - Version 2.2.8
The SQLP version 2.2.8 is ready and released. More info can be found in the SQLP 2.2.6 and SQLEP 1.7.8 Tutorial.
December 27th, 2013
The tutorial SQLP 2.2.6 and SQLEP 1.7.8 Tutorial is ready.
December 10th, 2013 - Version 2.2.7
The SQLP version 2.2.7 is ready and released.
The new features of the SQL Processor (SQLP) is the extended interface SqlSession.
December 8th, 2013 - Version 2.2.6
The SQLP version 2.2.6 is ready and released.
The new features of the SQL Processor (SQLP) are the ability to specify Map based option feature and use the reference to another optional feature. More info can be found in the upcoming SQLP 2.2.6 and SQLEP 1.7.8 Tutorial.
November 12th, 2013 - Version 2.2.5
The SQLP version 2.2.5 is ready and released.
The new features of the SQL Processor (SQLP) is the API for the input form validation, devoted for the CRUD statements (INSERT ant UPDATE). More info can be found in the Tutorial Validation API.
October 21th, 2013 - Version 2.2.4
The SQLP version 2.2.4 is available. In this release just a couple of minor fixes is provided. For more info please see issues related to this release.
August 25th, 2013
The new advanced sample presenting web application based on Ext JS is ready
- the stateless backend based on SQLP
- the backend code is located here
- the running backend can be seen at http://simple-backend.cfapps.io/
- the backend API can be seen at http://simple-backend.cfapps.io/api-debug.js?fullRouterUrl=true
- the web application based on Ext JS
- the gui code is located here
- the running backend can be seen at http://simple-gui.cfapps.io/
- the Sencha Architect based code is located here
- another web application based on Ext JS
- the gui code is located here
- the running backend can be seen at http://simple-auth.cfapps.io/
- the Sencha Architect based code is located here
August 4th, 2013 - Version 2.2.3
The SQLP version 2.2.3 is ready and released. In this release just a couple of minor fixes is provided. For more info please see issues related to this release.
June 24th, 2013 - Version 2.2.2
The SQLP version 2.2.2 is ready and released. More details can be found in the upcoming SQLP 2.2.2 and SQLEP 1.7.1 Tutorial.
June 3rd, 2013 (Updated)
The new tutorial SQLP 2.2.1 and SQLEP 1.7 Tutorial is ready.
May 31th, 2013 - Version 2.2.1
The SQLP version 2.2.1 is ready and released. More details can be found in the upcoming SQLP 2.2.1 and SQLEP 1.7 Tutorial.
May 15th, 2013 (Updated)
The new tutorial SQLP 2.2.0 and SQLEP 1.6 Tutorial is ready.
May 10th, 2013 - Version 2.2.0
The SQLP version 2.2.0 is ready and released. The main goals are
- new SQL operators
::=and$$=. For more info please see https://github.com/hudec/sql-processor/blob/master/sql-processor/src/test/java/org/sqlproc/engine/impl/TestOperators.java. - updated simple samples for dynamic SQL operator usage
- updated simple samples for enumerations usage (generated based on check column constraints using SQLEP 1.6.0)
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 2.1.1
The SQLP version 2.1.1 is ready and released. This version is primarily devoted to the SQLEP 1.5.0. More details can be found in the upcoming SQLP 2.1.1 and SQLEP 1.5 Tutorial.
March 21th, 2013
The tutorial SQLP 2.1 and SQLEP 1.4 Tutorial is ready.
March 16th, 2013 - Version 2.1.0
The SQLP 2.1.0 and SQLEP 1.4.0 are ready. More details can be found in the upcoming SQLP 2.1 and SQLEP 1.4 Tutorial.
The SQLEP can be downloaded from P2 repository or directly from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.4.0.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.4.0.jar
February 16th, 2013 - new SQLEP 1.3.1
The SQLEP 1.3.1 is ready. More details can be found in SQLEP 1.3.1 Tutorial. The SQLEP can be downloaded from P2 repository or directly from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.3.1.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.3.1.jar
February 3rd, 2013 - Version 2.0.0
The SQLP 2.0.0 and SQLEP 1.3.0 are ready. This version is not backward compatible. All tutorials have been rewritten. More details can be found in SQLP 2.0 and SQLEP 1.3 Tutorial.
The SQLEP can be downloaded from P2 repository or directly from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.3.0.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.3.0.jar
January 26th, 2013 - new SQLEP and SQLP snapshots
The SQLP 2.0.0 and SQLEP 1.3.0 snapshots are ready. This version is not backward compatible. The main goals are
- the unified grammar
- the simplified terminology
The SQLEP can be downloaded directly from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.3.0-SNAPSHOT.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.3.0-SNAPSHOT.jar
More details can be found in SQLP 2.0 and SQLEP 1.3 Tutorial.
January 14th, 2013 - updated Tutorials
- SQLEP 1.2.x Changes Tutorial - changes and improvements in SQLEP version 1.2.0
- SQLEP 1.2.x META SQL generation - META SQL statements generation based on DB model
- SQLEP 1.2.x DAO modelling - DAO modelling and source code generation
- SQLP 1.9.x Changes Tutorial - changes and improvements in SQLP version 1.9.0
The SQLEP version 1.2.2 is ready and can be for the first time installed from P2 repository http://sql-processor.eu/plugins/releases/.
January 11th, 2013 - Version 1.9.1
The SQLP version 1.9.1 is ready and released. At the same time the SQLEP version 1.2.1 is ready and released. The plugin can be downloaded from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.2.1.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.2.1.jar
New features
- simple batch support
- compound indexes
- SqlSession as an optional parameter in DAO
This is primarily a fix release. Minor changes are going to be described in upcoming tutorials.
January 5th, 2013 - new Tutorials
- SQLEP 1.2.x Changes Tutorial - changes and improvements in SQLEP version 1.2.0
- SQLEP 1.2.x META SQL generation - META SQL statements generation based on DB model
- SQLEP 1.2.x DAO modelling - DAO modelling and source code generation
- SQLEP 1.2.x DAO generation - DAO model generation based on DB model
- SQLP 1.9.x Changes Tutorial - changes and improvements in SQLP version 1.9.0
January 1st, 2013 - Version 1.9.0
The SQLP version 1.9.0 is ready and released. At the same time the SQLEP version 1.2.0 is ready and released. The plugin can be downloaded from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.2.0.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.2.0.jar
The key new features are
- META SQL generation based on DB model
- DAO modelling and source code generation based on DB model
- Maven Archetypes for simple applications (JDBC and Spring stack)
- the improved way, how to write META SQL control directives
- much more new features are going to be described in upcoming tutorials
The advanced samples present most new features
- https://github.com/hudec/sql-processor/tree/master/sql-samples/simple-jdbc-crud
- https://github.com/hudec/sql-processor/tree/master/sql-samples/simple-jdbc-dao
November 30th, 2012 - new SQLEP and SQLP snapshots
The new features can be seen in the sample https://github.com/hudec/sql-processor/blob/master/sql-samples/simple-jdbc-crud/src/main/resources/statements.qry
- control directives can be defined directly in the statement context
- ident, identx, const, constx, col, colx, out, outx, dbcol
- optional features can be defined directly in the statement context
- SQL statement like "xx%" support
- improved advanced CRUD templates
November 19th, 2012 - Eclipse plugin 1.2.0
The upcoming SQL Processor Eclipse plugin 1.2.0 can be downloaded as binaries from
- http://sql-processor.eu/plugins/org.sqlproc.dsl-1.2.0-SNAPSHOT.jar
- http://sql-processor.eu/plugins/org.sqlproc.dsl.ui-1.2.0-SNAPSHOT.jar
This new plugin is going to be released as the SQL Processor 1.8.1. The new features are:
- DB can be created on the fly for the modelling purpose, control directives
- database-ddl-create
- database-ddl-drop
- pojogen-generate-wrappers
- updated samples