Hi Alex,
thanks for the reply.
Could you tell me the best way to increase the size of a column in JBoss.
I'm using the default cmp mappings to deploy and create my database, so if I want to increase the size of the file then I think I have the following options:
1) alter the default mapping file (standardjaws.xml) for my database for String - however this will be for all fields in the database and might be a bad move
Are you using CMP1.1? I would not recommend touching JAWS at all. This engine is not maintained any more. Please, use JBossCMP.
Anyway, be it standardjaws.xml or standardjbosscmp-jdbc.xml, in general, you should not touch it.
2) try to use the ejb.persistance field for only the fields required, eg:
* @ejb.persistence
* column-name="longString"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(512) BINARY"
Yes, this is supposed to be the right way.
3) modify the fields to use a blob
* @ejb.persistence
* column-name="longString"
* jdbc-type="BLOB"
* sql-type="BLOB"
but I've heard blobs are to be avoided because they're slow.
Yes and they are not searchable.
Would really appreciate some advice on this!
thanks very much,
Brian
------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
