EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Handling of '0000-00-00'  XML

Forum Index » Tuning and Migration Wizard
Author Message
[Post New]16/02/2009 09:53:20
    Subject: Handling of '0000-00-00'
[Up]
Eric _t

New member

Joined: 16/02/2009 09:45:51
Messages: 2
Offline
Although I have selected the Default Date column, when I try to migrate a table from MySQL that contains an invalid date-field, i get the following error:
Error Loading Data into Table: Value '0000-00-00' can not be represented as java.sql.Date.


Googling for this error I find the following solution:
http://community.eapps.com/showthread.php?t=8

which suggests adding '&zeroDateTimeBehavior=convertToNull' to the end of the url parameter in the server.xml connection pool resource section.
I can not find such an xml file in the migrationstudio folder.
How can I configure migration studio to have the desired handling of invalid dates ?
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team