noDatetimeStringSync has no effect?!
Posted by: Ari Karhu
Date: November 01, 2006 08:33AM

I'm having a problem where the JDBC converts the date 2004-12-00 to 2004-11-30 when retreaving it with ResultSet.getString();

I read somewhere that if you put noDatetimeStringSync=true to the JDBC url it should cure this problem and pass the date string untouched. However, this is not working for me?! There is no effect if it's either true or false.

I'm using DBCP as a connection pool and my configuration xml has this:

<property name="driverClassName">
<property name="url">

The JDBC driver version is 5.0.4 and the actual db is 5.0.22.

Funny thing is that I extracted the JDBC jar file and looked the com/mysql/jdbc/configs/ file and it has the line "noDatetimeStringSync=true" already set to true? The default according to the manual id false, so what's going on here? ;)

Thanks for any replies!

Options: ReplyQuote

Written By
noDatetimeStringSync has no effect?!
November 01, 2006 08:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.