<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Handling of '0000-00-00'"]]></title>
		<link>http://forums.enterprisedb.com/posts/list/11.page</link>
		<description><![CDATA[Latest messages posted in the topic "Handling of '0000-00-00'"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Handling of '0000-00-00'</title>
				<description><![CDATA[ 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:<br /> Error Loading Data into Table: Value '0000-00-00' can not be represented as java.sql.Date.<br /> <br /> <br /> Googling for this error I find the following solution:<br /> <a class="snap_shots" href="http://community.eapps.com/showthread.php?t=8" target="_blank" rel="nofollow">http://community.eapps.com/showthread.php?t=8</a><br /> <br /> which suggests adding '&zeroDateTimeBehavior=convertToNull' to the end of the url parameter in the server.xml connection pool resource section.<br /> I can not find such an xml file in the migrationstudio folder.<br /> How can I configure migration studio to have the desired handling of invalid dates ?]]></description>
				<guid isPermaLink="true">http://forums.enterprisedb.com/posts/preList/1624/5672.page</guid>
				<link>http://forums.enterprisedb.com/posts/preList/1624/5672.page</link>
				<pubDate><![CDATA[Mon, 16 Feb 2009 09:53:20]]> GMT</pubDate>
				<author><![CDATA[ Eric _t]]></author>
			</item>
	</channel>
</rss>
