Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.202
  Buy Now
  HXTT Cobol 5.0.202
  HXTT DBF 7.1.203
  HXTT Excel 6.1.206
  HXTT Json 1.0.174
  HXTT Paradox 7.1.202
  HXTT PDF 2.0.202
  HXTT Text(CSV) 7.1.202
  HXTT Word 1.1.202
  HXTT XML 4.0.203
Offshore Outsourcing
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
Heng Xing Tian Tai Lab of Xi'an 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


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap