Re: [base] Problem with Java and default date 0000-00-00

2006-03-27 Thread Kjell Petersen
Hi Audrey, If a date is optional in the MAGE-ML, it should not be part of the export if it is set to the default -00-00, and thus this should be tested for. If the date is mandatory, then a better warning telling wich BASE item that lacks a realistic date should be issued so it can be ent

[base] Problem with Java and default date 0000-00-00

2006-03-27 Thread Audrey Bihouee
Hi everyboody, When I try to export my data to MAGE-ML, I get a java exception. The error is caused by the default date -00-00. I have this for the Experiment and Protocol and certainly for other tables. java.sql.SQLException: Value '-00-00' can not be represented as java.sql.Date