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>