mysql-connector-java-3.1.10 fails to handle datatype "int unsigned" for JSTL
Posted by:
dong_liu62
Date: September 13, 2005 01:34PM
I found that mysql-connector-java-3.1.10 returns wrong number for datatype "int unsigned" for JSTL sql tag.
I have used previous versions of connector on "int unsigned" without problem. However, when recently I need to redeploy the application to different machines with this version of connector, I got a huge number for the value of "1" stored as "int unsigned". After I changed all the datatype from "int unsigned" to straitforward "int", everything worked correctly.
The funny thing is, my JDBC code works fine. The only problem happens when I need to fetch the data using sql tags of JSTL, and display the value using JSTL c:out tag.
My environment:
JDK 1.5.0_04
MySQL 4.1.10
Tomcat 5.0.27
JSTL 1.0, Apache Standard Tag 1.0.3
mysql-connector-java-3.1.10
Subject
Written By
Posted
mysql-connector-java-3.1.10 fails to handle datatype "int unsigned" for JSTL
September 13, 2005 01:34PM
September 13, 2005 02:36PM
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.