-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Zahid,
On 1/7/20 4:19 PM, Zahid Rahman wrote: > If you wish to find out if the database connection API is buggy. > > Is the result when you use select query from each of the operating > system same. > > Select column_name from table; > > > If select on both return values are same then likely the database > API is buggy. You have choice of two database connection APIs. > > One API is tomcat specific. The other is vendor neutral. The API that matters is the JDBC API, and the driver you are using. Most people use Connector/J for both MySQL and MariaDB. It is a correct implementation and is reliable. - -chris > On Tue, 7 Jan 2020, 21:09 Michael Osipov, <micha...@apache.org> > wrote: > >> Am 2020-01-07 um 21:58 schrieb Jerry Malcolm: >>> This may be more of a Java question than Tomcat. But I'm not >>> sure. I have the same code, talking to the same MySql Linux >>> (AWS) database. I read a date column value in a Tomcat app. >>> After calling resultSet.getDate(...) I printed the date >>> instance and the getTime() >> value: >>> >>> On windows: 2019-02-01 1549000800000 >>> >>> On linux: 2019-01-31 1548979200000 >>> >>> Again this is the SAME line of code in java reading the SAME >>> field in the SAME database. Only thing different is >>> Linux/Windows OS. The date is supposed to be 2/1/2019 and >>> shows that in phpMyAdmin. >>> >>> I've been running on Linux for a few months. But I don't have >>> an extensive background in the specifics of Linux. I'm sure >>> there must be something that is configured differently. I'm at >>> a loss. But this is not a trivial problem. I do monthly >>> billing. My dates need to be >> accurate. >> >> Have you verified that you aren't tricked by any timezone >> issues? >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> > -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl4VJwgACgkQHPApP6U8 pFj0whAAh5BtS70kaQq/G/CdHIttfjCnkkrSsEqudyKhMuzuSL+TX8OFYYpHEL8g sVsK7KWzoOCWKJa6v0St52vubU0yUh3xvgNv7VpkFkoEVL8+DuXeJrv+rKIcqI4m HxcMwZJIQQhLbTHX0pYDMWN88WaG5tdJIKjQBNXy17JSr4WMTThT4Oiei34QCD7O 9G+Cji2C6gf83AJTlMdihNEh71M/Xh2BUuz10m6CN+M2DN7UikUhU+u6St6AQp/f JTApL7cYS9d9weapGZiTHGwg6nyxj4morHRfT2BCMJq+tyK2u8X+Tim2cPzIyTdj YdtJOJQ3RtZRufS0DYlTVk5+1kHWI7l8KVBo2yo4QuRwoxesigODPNLAVsZBsFgc A1M2UyN4CKRAbTkVxoKq3ORVHXlDY6hPuCD8UATIzIfd/q0fdexue6Q8wMwOyQvp 6GuRc6WNCAXXaDdcUZzZFgteALiYG+GInLiisxP0THdb4vKQMn5XqV+PDFURAWmY SY9MZ7bUQcT/MXXxeEbF+Wj34dBDolwtkOcZ9FfCBgmXRyhUCKcYg/UAwMeg6qkN qGbtAGBRe4JzUqcKhJRLWu5Z6uoKhIcFdi8+cm3eM9cqZLcJIDAtxlbbVQDdUjZ1 X25QFzlgzMDu+b3reHus4TTWZ61GZ+ujzkgSAL0xrur5UvHpZLU= =ruIX -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org