Hi
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,
Roman
|
According to your requirement, v3.2.054 supports function expression for MS Access' default value. Please download it.
|
Hi,
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.
Thanks,
Roman
|
Please redownload. That issue was resulted by sql engine do smart constant replacement for now() function.
|