chris wrote:
> Ok, could somebody maybe tell me at least if they
> do not have this problem?
> Another example,
>
> select date(mydatecol) as mydate from mytable
>
> JDBC metadata would say this is a string. This is
> really screwing everything up. Any hints would be
> much appreciated, if even just to say that you
> don't have that problem and this is unexpected.
>
> Thanks
Chris,
This is a known server issue (and is listed in the bugs database multiple times at
http://bugs.mysql.com/). The only workaround currently is to ask for the type you want, not depend on ResultSet.getObject() to return the type you expect when using functions.
- Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html