Timestamp parameter gets sent as date

<p>I&#39;m facing quite weird situation working on pure JDBC Java code connected to Postgres DB.</p>

<p>The SQL used for PreparedStatement is relatively simple:</p>

<p><span style="font-family:courier new,courier,monospace">SELECT * FROM test t INNER JOIN .... </span></p>

<p><span style="font-family:courier new,courier,monospace">WHERE&nbsp; t.id = ? AND (?::TIMESTAMP IS NULL OR t.date + t.time &lt;= ?::TIMESTAMP WITHOUT TIME ZONE) </span></p>

<p>&nbsp;</p>

<p><span style="font-family:courier new,courier,monospace">t.date is [date NOT NULL]<br />
t.time is [time without time zone NOT NULL]</span></p>

<p>&nbsp;</p>

<p>So, Java code to prepare and set parameters is as following:</p>

<p><span style="font-family:courier new,courier,monospace">PreparedStatement statement = connection.prepareStatement(<strong><em>SQL</em></strong>);<br />
statement.setInt(<span style="color:rgb(0, 0, 255)">1</span>, id);</span></p>

<p><span style="font-family:courier new,courier,monospace">if (date== null) {<br />
&nbsp;&nbsp; statement.setNull(<span style="color:#0000CD">2</span>, Types.<em>DATE</em>);<br />
&nbsp;&nbsp; statement.setNull(<span style="color:#0000CD">3</span>, Types.<em>DATE</em>);<br />
}<br />
else {<br />
&nbsp;&nbsp; statement.setTimestamp(<span style="color:#0000CD">2</span>, Timestamp.<em>valueOf</em>(date));<br />
&nbsp;&nbsp; statement.setTimestamp(<span style="color:#0000CD">3</span>, Timestamp.<em>valueOf</em>(date));<br />
}</span></p>

<p><span style="font-family:courier new,courier,monospace">ResultSet rs = statement.executeQuery();</span></p>

<p>&nbsp;</p>

<p>The issue is: though Java code sets date parameters to PreparedStatement correctly (checked with logging) i.e. $1 = &#39;29&#39;, $2 = &#39;2017-01-14:13:00&#39;, $3 = &#39;2017-01-14:13:00&#39; , but actual query performed by PostgreSQL server (logging) <strong>SOMETIMES </strong>shows parameters used <span style="font-family:courier new,courier,monospace">GMT DETAIL:&nbsp; parameters: $1 = &#39;29&#39;, $2 = &#39;2017-01-14&#39;, $3 = &#39;2017-01-14&#39;</span>.&nbsp; Strangest thing that in 95% cases of same request with different params the output (behaviour and parameters) is correct, i.e. parameters are set and seen as DATE + TIME both from API and PostgreSQL. Moreover, repeteadly passing problematic parameters finally gets right query&#39;s behavior and output, sometimes after few tries or Java application restart. Worth mentioning, Java app does not do any &quot;caching&quot; or data modification - it&#39;s simple REST API for DB calls.</p>

<p>I&#39;m not sure if it might be something very simple (JDBC/DB configuration) or a bug in postgres JDBC driver - since there is no other sofware to blame. Java code seemingly does everything right but PostgresSQL <strong>SOMETIMES </strong>receives different parameters (date instead of date + time).</p>

<p>I&#39;ve tried to enable postgres JDBC driver logging as it&#39;s said in documentation but did not manage it to operate with Spring Boot logging.</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>JDBC driver used: 42.1.4 (latest)</p>

<p>Server version: 9.5</p>

<p>Other related software: HikariCP</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>