I have the same problem (I have to store a VARCHAR(5000) on MySQL 4 (witch as WARCHAR limited to 255)).
I'm not sure it will work but I have found that the mapping file is in : $JBOSS_HOME\serveur\default\conf\standardjbosscmp-jdbc.xml You have the mapping for each type of Bdd. For my case, I have change the <type-mapping> | <name>mySQL</name> | ... | <mapping> | <java-type>java.lang.String</java-type> | <jdbc-type>VARCHAR</jdbc-type> | <sql-type>VARCHAR(250) BINARY</sql-type> | </mapping> | </type-mapping> by : <type-mapping> | <name>mySQL</name> | ... | <mapping> | <java-type>java.lang.String</java-type> | <jdbc-type>VARCHAR</jdbc-type> | <sql-type>TEXT</sql-type> | </mapping> | </type-mapping> It seams to work fine after a Jboss reboot. Dont forget to select your database type in your xxx-ds.xml file <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964603#3964603 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964603 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user