[openjpa] 02/03: OPENJPA-2850 use VARBINARY(MAX) instead BLOB column type

[struberg]

This is an automated email from the ASF dual-hosted git repository.

struberg pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/openjpa.git

commit 8283ea0fb2d455118c133540ef7f2bea4ae597cd
Author: Mark Struberg <strub...@apache.org>
AuthorDate: Tue Mar 30 09:19:57 2021 +0200

    OPENJPA-2850 use VARBINARY(MAX) instead BLOB column type
---
 .../main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java   | 5 +++++
 pom.xml                                                              | 2 +-
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git 
a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
 
b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
index c50ccb1..252748f 100644
--- 
a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
+++ 
b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
@@ -81,6 +81,11 @@ public class SQLServerDictionary extends 
AbstractSQLServerDictionary {
         timeWithZoneTypeName = "TIME";
         timestampWithZoneTypeName = "DATETIMEOFFSET";
 
+        // MS SQL Server uses those types for BLOBs
+        blobTypeName = "VARBINARY(MAX)";
+        longVarbinaryTypeName = "VARBINARY(MAX)";
+
+
         indexPhysicalForeignKeys = true; // MS-SQLServer does not 
automatically create an index for a foreign key so we will
     }
 
diff --git a/pom.xml b/pom.xml
index a03c659..c8d69f8 100644
--- a/pom.xml
+++ b/pom.xml
@@ -79,7 +79,7 @@
         <mysql.connector.version>5.1.47</mysql.connector.version>
         <mariadb.connector.version>2.2.0</mariadb.connector.version>
         <postgresql.connector.version>42.2.5</postgresql.connector.version>
-        <mssql.connector.version>7.2.1</mssql.connector.version>
+        <mssql.connector.version>7.4.1.jre8</mssql.connector.version>
 
         <!-- other common versions -->
         <kubernetes-client.version>4.7.0</kubernetes-client.version>