Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  Buy Now
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Error in getDate() with client/server mode.
Steven Kouri
2008-05-29 11:21:36.0
When retrieving a date using the ResultSet.getDate() method, I found that sometimes, my date was off by one day. If I expected 2008-04-01, it would return 2008-03-31. This did not occur for every row I read though.

In production mode, I will be going across networks, so I was using the remote access mode for testing:

However, if I change the URL to the following, then the dates come back correctly:

Could this be a Java serialization problem? Can you please look at this and see if it is possible to fix?

Re:Error in getDate() with client/server mode.
Steven Kouri
2008-05-29 11:38:42.0
A co-worker helped me solve my problem.

My server side was running under 1.6 JVM. My client side was 1.4 JVM. It appears they are not necessarily backwards compatible.
Re:Re:Error in getDate() with client/server mode.
HXTT Support
2008-05-29 23:22:29.0
Your server side and client side should be on different time zone.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap