I 'm writing a webapplication in Java that allows users to store bookmarks. The system scans these pages for differences at user-selected intervals. At another user-selected interval, the system sends notification mails about changed bookmarks. The bookmark table provisionally looks like this:

CREATE TABLE bookmark (
bookmark_id INTEGER NOT NULL AUTO_INCREMENT,
bookmarkname VARCHAR (80) NOT NULL,
url VARCHAR (150) NOT NULL,
folder_id INTEGER NOT NULL,
last_scanned TIMESTAMP NOT NULL,
PRIMARY KEY (bookmark_id),
FOREIGN KEY (folder_id) REFERENCES folder(folder_id) ON DELETE CASCADE) TYPE = InnoDB;


I want to add another TIMESTAMP column, last_notified. But whenever I insert a new bookmark, the first TIMESTAMP column will be set, the other will be 0000-00-00 00:00:00.
When they get mapped by the iBatis framework to Java objects, I get an exception that aTimestamp object can not be created with 0000-00-00 00:00:0


Is there a way I can set them both when the bookmark is created? I rather not set one of them to NULL, because that would imply a lot more code to check if a user should be notified or a bookmark should be scanned.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to