Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  Buy Now
  HXTT Cobol v2.1
  HXTT DBF v5.2
  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)

DEFAULT value for TIMESTAMP fileds
2009-03-25 09:39:13.0
I'm evaluating you access jdbc driver (version 3.2.053) and have problem inserting new records into a table with TIMESTAMP field with DEFAULT 'Now()'.
Table definitions is
create TABLE eventLog ( EventTime TIMESTAMP DEFAULT 'now()', Message VARCHAR(255))
If I insert a new record using query
INSERT INTO EventLog ( Message ) VALUES ('msg')
the value that inserted in the EventTime field is always NULL. If I run the same query in MS Access EventTime is set to current timestamp.

Thanks for your help,
Re:DEFAULT value for TIMESTAMP fileds
HXTT Support
2009-03-27 03:56:10.0
According to your requirement, v3.2.054 supports function expression for MS Access' default value. Please download it.
Re:Re:DEFAULT value for TIMESTAMP fields
2009-03-27 06:53:18.0
Thank you for the update. Now field with default value is updated. But if I run several insert statements (5-60 seconds between inserts) then all inserted records have the same Timestamp value in the EventTime field. I tried to insert records using prepared statement in my java application and using DBVisualizer tool with the same result.

Re:Re:Re:DEFAULT value for TIMESTAMP fileds
HXTT Support
2009-03-27 22:55:40.0
Please redownload. That issue was resulted by sql engine do smart constant replacement for now() function.
Re:Re:Re:Re:DEFAULT value for TIMESTAMP fileds
2009-03-30 10:41:48.0
It works now.
Thank you

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