MySQL Forums

Hi
I am using mysql 5.0.67 and
following connector mysql-connector-java-5.1.7-bin.jar

im ussing Uddi4j api's to to converse with jUddi database(on Jboss esb 4.4/Jboss AS 4.2.3) which has been configured to use a mysql database

On running the api's im getting the following errors

09:31:47,667 ERROR [AbstractService] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'LANG_CODE' at row 1

following is table with the lang_code column:
mysql> describe tmodel_descr;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| TMODEL_KEY | varchar(41) | NO | PRI | NULL | |
| TMODEL_DESCR_ID | int(11) | NO | PRI | NULL | |
| LANG_CODE | varchar(5) | YES | | NULL | |
| DESCR | varchar(255) | NO | | NULL | |
+-----------------+--------------+------+-----+---------+-------+
4 rows in set (0.11 sec)

what is the cause of the error and how to i resolve it?

Also: where can i find/generate mysql logs to find out exact table which is throwing the error considering multiple tables have the column 'LANG_CODE'..im not inserting data directly but from uddi4j api-->juddi-->mysql

After resolving application server, api errors.........last thing i expected was an mysql error. Any help in resolving the issue will be really helpful.



Edited 1 time(s). Last edit at 11/12/2008 12:37AM by Prasad V.