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 0000-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 entered by the user.

However, this is how it's supposed to be, and probably the code doesn't test the input well enough.

Did the error message/java trace give any hints of where in the code the exception hit ?

Cheers,
Kjell

Audrey Bihouee wrote:

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 0000-00-00. I have this for the Experiment and Protocol and certainly for other tables.

java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date


Somebody have an idea to solve this ?

Thanks very much
Audrey



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]

Reply via email to