0 Replies Latest reply on Feb 28, 2003 5:23 AM by harm

    mysql string mapping

    harm Newbie

      Hi all,

      I'm sorry if this been asked before (I used the search but didn't find anything).

      I'm using MySQL as my datasource.
      I noticed in the file '$JBOSS_DIST/server/default/conf/standardjbosscmp-jdbc.xml' that JBoss maps a java.lang.String to VARCHAR(250).

      I have an application that uses pretty long Strings (java.lang.String). They contain XML-messages.

      I'm not sure but I'm guessing that they could contain string-messages longer then 250 characters.

      I'm wondering what happens if I use CMP to persist these strings. (Are they cut of in the database?).

      Wat can I do to make the storage capacity larger?
      I could just change the mapping file to use TEXT or some other database type.
      But, I also have applications which store rather small strings. (I think this would be a waste of storage capacity).

      Do you guys have suggestions?

      Thanks!