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

Options: ReplyQuote


Subject
Written By
Posted
mysql-connector-java-3.1.10 fails to handle datatype "int unsigned" for JSTL
September 13, 2005 01:34PM


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.