Package com.broadleafcommerce.sandbox.provider.jpa.repository.support

Class JdbcConversionUtils

java.lang.Object

com.broadleafcommerce.sandbox.provider.jpa.repository.support.JdbcConversionUtils

public final class JdbcConversionUtils
extends Object

Contains common functionality useful for converting values between Java/JDBC representation.

Method Summary

Modifier and Type	Method	Description
static Timestamp	instantToTimestamp(Instant instant)	Convert the given Instant into a Timestamp representation that can be passed to PreparedStatement.setTimestamp(int, Timestamp).

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

instantToTimestamp

public static Timestamp instantToTimestamp(Instant instant)

Convert the given Instant into a Timestamp representation that can be passed to PreparedStatement.setTimestamp(int, Timestamp).

There are some quirks with how Timestamp is interpreted and converted by PreparedStatement.setTimestamp(int, Timestamp), which prevent us from using the same logic as Hibernate's InstantJavaType.unwrap(Instant, Class, WrapperOptions) to perform this conversion. More details can be seen in these sources:

• StackOverflow post
• JDBC Timestamp pitfalls

Parameters:

instant - the instant to convert to a Timestamp

Returns:

the Timestamp representation of the Instant