[OPENJPA-2853] [MSSQL Server] support sendTimeAsDatetime handling

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 3.2.0
• Component/s: jdbc
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 31/Mar/21 17:09
• Updated: 14/May/21 08:16
• Resolved: 31/Mar/21 19:39

Description

Microsoft SQL Server handles Time values in 2 different ways.

https://docs.microsoft.com/en-us/sql/connect/jdbc/configuring-how-java-sql-time-values-are-sent-to-the-server?view=sql-server-ver15

One way to make the SQLServer JDBC driver understand java.sql.Time is to add

Depending on the configuration one can now enable sendTimeAsString in the SQLServerDictionary