1 Reply Latest reply on Oct 6, 2003 10:56 PM by Gary

    change VARCHAR to TEXT??

    Gary Newbie

      I am using mysql as my datasource..The default mapping of String is VARCHAR(250), How can I change it to TEXT?

      <java-type>java.lang.String</java-type>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>TEXT</sql-type>

      I changed the setting in standarjbosscmp-jdbc.xml...is it right? it doesn't work...

        • 1. Re: change VARCHAR to TEXT??
          Gary Newbie

          the setting is right...and when I deploy the ejb jar. MySQL automatically create the table for me. and the data type is TEXT...However, I still cannot insert a large ammount of text into db...anyone knows why??what should I modify in the standardjaws.xml and standardjbosscmp-jdbc.xml?