Fix hibernate dialect for SQLite.

Change-Id: I217dafe5a1b7dfcd4996d7741dd5711c54d7f268
diff --git a/core/pom.xml b/core/pom.xml
index f617a48..53a7679 100644
--- a/core/pom.xml
+++ b/core/pom.xml
@@ -11,9 +11,10 @@
 		<spring.version>5.3.0</spring.version>
 		<jersey.version>1.19.4</jersey.version>
 		<jetty.version>9.4.34.v20201102</jetty.version>
-		<hibernate.version>5.4.20.Final</hibernate.version>
+		<hibernate.version>5.4.25.Final</hibernate.version>
 		<log4j.version>2.13.3</log4j.version>
 	</properties>
+	
 	<build>
 		<resources>
 			<resource>
@@ -480,6 +481,12 @@
 			<version>${hibernate.version}</version>
 			<scope>provided</scope>
 		</dependency>
+		<dependency>
+			<groupId>com.github.gwenn</groupId>
+			<artifactId>sqlite-dialect</artifactId>
+			<version>0.1.0</version>
+		</dependency>
+		
 		
 		<dependency>
 			<groupId>javax.servlet</groupId>
diff --git a/full/Changes b/full/Changes
index f4efc95..906cb47 100644
--- a/full/Changes
+++ b/full/Changes
@@ -5,6 +5,8 @@
    - Introduction of a query reference rewrite mechanism (diewald)
 30/10/2020
    - Added database methods for storing query references (diewald) 
+04/12/2020
+   - Fix hibernate dialect for SQLite. (margaretha)
 
 # version 0.62.4
 24/01/2020
diff --git a/full/pom.xml b/full/pom.xml
index 575cd9b..d083b8c 100644
--- a/full/pom.xml
+++ b/full/pom.xml
@@ -8,7 +8,7 @@
 		<java.version>1.8</java.version>
 		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
 		<jersey.version>1.19.4</jersey.version>
-		<hibernate.version>5.4.23.Final</hibernate.version>
+		<hibernate.version>5.4.25.Final</hibernate.version>
 	</properties>
 	<profiles>
 		<profile>
diff --git a/full/src/main/resources/hibernate.properties b/full/src/main/resources/hibernate.properties
index 199dc73..23979b2 100644
--- a/full/src/main/resources/hibernate.properties
+++ b/full/src/main/resources/hibernate.properties
@@ -1,4 +1,4 @@
-hibernate.dialect=org.hibernate.dialect.MySQLDialect
+hibernate.dialect=org.hibernate.dialect.SQLiteDialect
 hibernate.hbm2ddl.auto=none
 hibernate.show_sql=false
 hibernate.cache.use_query_cache=false
diff --git a/full/src/test/resources/test-hibernate.properties b/full/src/test/resources/test-hibernate.properties
index 37b7ea7..23979b2 100644
--- a/full/src/test/resources/test-hibernate.properties
+++ b/full/src/test/resources/test-hibernate.properties
@@ -1,4 +1,4 @@
-hibernate.dialect=org.hibernate.dialect.MariaDB103Dialect
+hibernate.dialect=org.hibernate.dialect.SQLiteDialect
 hibernate.hbm2ddl.auto=none
 hibernate.show_sql=false
 hibernate.cache.use_query_cache=false
diff --git a/lite/Changes b/lite/Changes
index 3117c50..c9ccc2e 100644
--- a/lite/Changes
+++ b/lite/Changes
@@ -1,5 +1,7 @@
 # version 0.63
-
+04/12/2020
+  - Fix hibernate dialect for SQLite. (margaretha)
+  
 # version 0.62.4
 24/01/2020
    - Removed salt from config and updated config files.
diff --git a/lite/src/main/resources/hibernate.properties b/lite/src/main/resources/hibernate.properties
index 37b7ea7..23979b2 100644
--- a/lite/src/main/resources/hibernate.properties
+++ b/lite/src/main/resources/hibernate.properties
@@ -1,4 +1,4 @@
-hibernate.dialect=org.hibernate.dialect.MariaDB103Dialect
+hibernate.dialect=org.hibernate.dialect.SQLiteDialect
 hibernate.hbm2ddl.auto=none
 hibernate.show_sql=false
 hibernate.cache.use_query_cache=false