Tomcat Production Date processing

[Jacob Rhoden <ja...@rhoden.id.au>]

Hi Guys,

I am getting a very strange problem I have no idea where to start and I 
thought you guys might know, its possible its not may not  be a tomcat 
problem...

I am running netbeans 5.5(tomcat 5.5.17)/java 1.5/mysql connector 3.1.13
The production server has java 1.6/mysql connecter 3.1.13/tomcat 5.5.17

My most recent version of my app is returnning the following sql error 
in response to a ResultSet.getDate(xx);

   Sql problem: java.sql.SQLException: Cannot convert value '2007-01-28 
01:19:15'
   from column 5(2007-01-28 01:19:15 ) to DATE.


I cant find any info about this anywhere!

Thanks,
Jacob

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org

Re: Tomcat Production Date processing

[Jacob Rhoden <ja...@rhoden.id.au>]

Jacob Rhoden wrote:
>   Sql problem: java.sql.SQLException: Cannot convert value '2007-01-28 
> 01:19:15'
>   from column 5(2007-01-28 01:19:15 ) to DATE.
For future reference, If you receive this error in your servlet, it can 
be resolved by upgrading the mysql connector to the latest version.

Best Regards,
Jacob

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org