Test Environments
Each build of exedio persistence is subject to extensive unit testing on various environments. An environment is the combination of the Database Management System (DBMS), the JDBC driver and the Connect Properties. The following table lists all environments, the framework is tested on.
| DBMS | JDBC driver | Environment | Connect Properties | ||
|---|---|---|---|---|---|
| Name | Version | Name | Version | ||
| HSQL Database Engine (12x) | 2.5.1 | HSQL Database Engine Driver | 2.5.1 | hy | connectionPool.idleInitial=2 dataField.bufferSizeDefault=1000 dataField.bufferSizeLimit=2000 |
| hy-extra | cache.item.limit=300 cache.query.limit=200 changeListeners.queueCapacity=10 changeListeners.threads.initial=2 changeListeners.threads.max=3 changeListeners.threads.priority.set=true changeListeners.threads.priority.value=1 connectionPool.idleLimit=200 dataField.bufferSizeDefault=1000 dataField.bufferSizeLimit=2000 dialect=com.exedio.cope.HsqldbDialect disableSupport.nativeDate=true disableSupport.semicolon=true disableSupport.uniqueViolation=true media.offsetExpires=PT1M6S media.rooturl=mediaroot query.searchSizeLimit=160 revise.savepoint=true schema.revision.table=whilex schema.revision.unique=protectedx |
||||
| hy-low | schema.mysql.lower_case_table_names=true |
||||
| hy-low-sq | schema.mysql.lower_case_table_names=true schema.primaryKeyGenerator=sequence |
||||
| hy-my55 | dialect.approximate=mysql55 schema.primaryKeyGenerator=sequence |
||||
| hy-my56 | dialect.approximate=mysql56 schema.primaryKeyGenerator=sequence |
||||
| hy-nprep | disableSupport.preparedStatements=true |
||||
| hy-nstmp | cache.stamps=false |
||||
| hy-sq | schema.primaryKeyGenerator=sequence schema.tableInNames=true |
||||
| hy-sqb | schema.primaryKeyGenerator=batchedSequence schema.tableInNames=true |
||||
| hy-vault | dataField.bufferSizeDefault=1000 dataField.bufferSizeLimit=2000 dataField.vault=true dataField.vault.isAppliedToAllFields=true |
||||
| hy-zero | cache.item.limit=0 cache.query.limit=0 connectionPool.idleLimit=0 dataField.bufferSizeDefault=1 dataField.bufferSizeLimit=2 media.offsetExpires=PT0S |
||||
| MySQL (52x) | 5.5.62 (9x) | MySQL Connector/J (28x) | mysql-connector-java-8.0.21 (Revision: 33f65445) | my55 | |
| my55-legacy | dialect.fullSequenceColumnName=false dialect.longConstraintNames=false dialect.smallIntegerTypes=false dialect.utf8mb4=false disableSupport.semicolon=true |
||||
| my55-nprep | disableSupport.preparedStatements=true |
||||
| my55-nprep-legacy | dialect.fullSequenceColumnName=false dialect.longConstraintNames=false dialect.smallIntegerTypes=false dialect.utf8mb4=false disableSupport.preparedStatements=true |
||||
| my55-nstmp | cache.stamps=false |
||||
| my55-nstmp-sq | cache.stamps=false schema.primaryKeyGenerator=sequence |
||||
| my55-sq | schema.primaryKeyGenerator=sequence |
||||
| my55-sqb | schema.primaryKeyGenerator=batchedSequence |
||||
| my55-unique | disableSupport.uniqueViolation=true |
||||
| 5.6.33-log (9x) | my56 | ||||
| my56-legacy | dialect.fullSequenceColumnName=false dialect.longConstraintNames=false dialect.smallIntegerTypes=false dialect.utf8mb4=false disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| my56-nprep | disableSupport.preparedStatements=true |
||||
| my56-nprep-legacy | dialect.fullSequenceColumnName=false dialect.longConstraintNames=false dialect.smallIntegerTypes=false dialect.utf8mb4=false disableSupport.preparedStatements=true |
||||
| my56-nstmp | cache.stamps=false |
||||
| my56-nstmp-sq | cache.stamps=false schema.primaryKeyGenerator=sequence |
||||
| my56-sq | schema.primaryKeyGenerator=sequence |
||||
| my56-sqb | schema.primaryKeyGenerator=batchedSequence |
||||
| my56-unique | disableSupport.uniqueViolation=true |
||||
| 5.7.27-log (17x) | my57 | ||||
| my57-compress | dialect.rowFormat=COMPRESSED |
||||
| my57-legacy | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| my57-nprep | disableSupport.preparedStatements=true |
||||
| my57-nstmp | cache.stamps=false |
||||
| my57-nstmp-sq | cache.stamps=false dialect.fullSequenceColumnName=false schema.primaryKeyGenerator=sequence |
||||
| my57-sq | schema.primaryKeyGenerator=sequence |
||||
| my57-sqb | schema.primaryKeyGenerator=batchedSequence |
||||
| my57-unique | disableSupport.uniqueViolation=true |
||||
| my57-z | dialect.connection.compress=true schema.primaryKeyGenerator=sequence |
||||
| MariaDB connector/J (7x) | 2.2.1 | my57m | |||
| my57m-legacy | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| my57m-nprep | disableSupport.preparedStatements=true |
||||
| my57m-nstmp | cache.stamps=false |
||||
| my57m-nstmp-sq | cache.stamps=false dialect.fullSequenceColumnName=false schema.primaryKeyGenerator=sequence |
||||
| my57m-sq | schema.primaryKeyGenerator=sequence |
||||
| my57m-z | dialect.connection.compress=true schema.primaryKeyGenerator=sequence |
||||
| 8.0.20 (17x) | MySQL Connector/J (10x) | mysql-connector-java-8.0.21 (Revision: 33f65445) | my80 | ||
| my80-compress | dialect.rowFormat=COMPRESSED |
||||
| my80-legacy | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| my80-nprep | disableSupport.preparedStatements=true |
||||
| my80-nstmp | cache.stamps=false |
||||
| my80-nstmp-sq | cache.stamps=false dialect.fullSequenceColumnName=false schema.primaryKeyGenerator=sequence |
||||
| my80-sq | schema.primaryKeyGenerator=sequence |
||||
| my80-sqb | schema.primaryKeyGenerator=batchedSequence |
||||
| my80-unique | disableSupport.uniqueViolation=true |
||||
| my80-z | dialect.connection.compress=true schema.primaryKeyGenerator=sequence |
||||
| MariaDB connector/J (7x) | 2.2.1 | my80m | |||
| my80m-legacy | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| my80m-nprep | disableSupport.preparedStatements=true |
||||
| my80m-nstmp | cache.stamps=false |
||||
| my80m-nstmp-sq | cache.stamps=false dialect.fullSequenceColumnName=false schema.primaryKeyGenerator=sequence |
||||
| my80m-sq | schema.primaryKeyGenerator=sequence |
||||
| my80m-z | dialect.connection.compress=true schema.primaryKeyGenerator=sequence |
||||
| PostgreSQL (12x) | 9.6.19 (6x) | PostgreSQL JDBC Driver (12x) | 42.2.9 | pg96 | |
| pg96-mysql | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| pg96-nprep | disableSupport.preparedStatements=true |
||||
| pg96-nstmp | cache.stamps=false |
||||
| pg96-public | dialect.connection.schema=public schema.primaryKeyGenerator=sequence |
||||
| pg96-sq | dialect.pgcryptoSchema=<disabled> schema.primaryKeyGenerator=sequence |
||||
| 11.7 (Debian 11.7-2.pgdg90+1) (6x) | pg11 | ||||
| pg11-mysql | disableSupport.nativeDate=true disableSupport.semicolon=true |
||||
| pg11-nprep | disableSupport.preparedStatements=true |
||||
| pg11-nstmp | cache.stamps=false |
||||
| pg11-public | dialect.connection.schema=public schema.primaryKeyGenerator=sequence |
||||
| pg11-sq | dialect.pgcryptoSchema=<disabled> schema.primaryKeyGenerator=sequence |
||||
The exedio console shows your environment along with the list of enviroments, your version of exedio persistence has been tested on.