Bug #46099 | useServerPrepStmts=true/false setDate() behaves differently | ||
---|---|---|---|
Submitted: | 9 Jul 2009 20:41 | Modified: | 21 Dec 2015 16:02 |
Reporter: | Dmitry Popov | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / J | Severity: | S2 (Serious) |
Version: | 5.1.7 | OS: | Any |
Assigned to: | Filipe Silva | CPU Architecture: | Any |
[9 Jul 2009 20:41]
Dmitry Popov
[9 Jul 2009 20:43]
Dmitry Popov
-
[10 Jul 2009 13:16]
Tonci Grgin
Hi Dmitry and thanks for your report. Verified by looking into code.
[10 Jul 2009 14:23]
Dmitry Popov
Another issue found: If pstmt enabled and the DATE is inserted using prepared statement but selected using regular statement then result will be different.
[21 Dec 2015 16:02]
Filipe Silva
Since Connector/J version 5.1.35 there is a connection property 'noTimezoneConversionForDateType' which allows to turn on/off the time zone switching features for DATE type. This property has default value 'true' so no conversions should occur by default. Same behavior was observed when using server prepared statements and client prepared statements. This report will be closed as "Can't repeat". Please reopen it of file a new one if you find some situation were the problem persists. Thank you,