commit 53f870deb4310e3418a6e22b3e0def7c2ac4e034
author Jean-Louis Monteiro <jlmonteiro@tomitribe.com> Sat Nov 28 20:38:43 2020 +0100
committer Jean-Louis Monteiro <jlmonteiro@tomitribe.com> Sat Nov 28 20:38:43 2020 +0100
tree 378f4cc3df0b306ed2fd4cea9ce753802295bccf
parent 02cf551f354b54b59d9ff5a2311e294ffbac5022

Align Derby version with TCK and TomEE and fix the SQL scripts

pom.xml

diff --git a/pom.xml b/pom.xml
index 28f08ff..b6a7b67 100644
--- a/pom.xml
+++ b/pom.xml
@@ -43,7 +43,7 @@
 
     <tomcat.version>9.0.40</tomcat.version>
 
-    <derby.version>10.11.1.1</derby.version>
+    <derby.version>10.14.2.0</derby.version>
 
     <!--
     NOTE: User must define "javaee8.cts.home" and "javaee8.ri.home" in ~/.m2/settings.xml

src/test/sql/derby/derby.ddl.sql

diff --git a/src/test/sql/derby/derby.ddl.sql b/src/test/sql/derby/derby.ddl.sql
index 60f1b95..b2bd297 100644
--- a/src/test/sql/derby/derby.ddl.sql
+++ b/src/test/sql/derby/derby.ddl.sql
@@ -22,7 +22,7 @@
 create table Real_Tab (MAX_VAL REAL, MIN_VAL REAL,NULL_VAL REAL) ;
 
 drop table Bit_Tab ;
-create table Bit_Tab (MAX_VAL SMALLINT, MIN_VAL SMALLINT, NULL_VAL SMALLINT) ;
+create table Bit_Tab (MAX_VAL BOOLEAN, MIN_VAL BOOLEAN, NULL_VAL SMALLINT) ;
 
 drop table Smallint_Tab ;
 create table Smallint_Tab (MAX_VAL SMALLINT, MIN_VAL SMALLINT, NULL_VAL SMALLINT) ;

src/test/sql/derby/derby.dml.sql

diff --git a/src/test/sql/derby/derby.dml.sql b/src/test/sql/derby/derby.dml.sql
index 1df627a..65405e6 100644
--- a/src/test/sql/derby/derby.dml.sql
+++ b/src/test/sql/derby/derby.dml.sql
@@ -78,7 +78,7 @@
 
 Real_Tab_Insert= insert into Real_Tab values(3.402E38,1.4E-37, null)
 
-Bit_Tab_Insert=insert into Bit_Tab values(1,0,null)
+Bit_Tab_Insert=insert into Bit_Tab values(true,false,null)
 
 Smallint_Tab_Insert= insert into Smallint_Tab values(32767,-32768,null)