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
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"
* column-name="longString"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(512) BINARY"
3) modify the fields to use a blob
* @ejb.persistence
* column-name="longString"
* jdbc-type="BLOB"
* sql-type="BLOB"
* column-name="longString"
* jdbc-type="BLOB"
* sql-type="BLOB"
but I've heard blobs are to be avoided because they're slow.
Would really appreciate some advice on this!
thanks very much,
Brian
>It is cut off by the database, not JBossCMP. You should increase the size for the column.
Brian McSweeney wrote:
Brian McSweeney wrote:
Hi all,
My ejbs are cmp ones and the string parameters I use are as follows
/**
* @ejb.persistence
* column-name="stringDescription"
* @ejb.interface-method
*/
I don�t specify the string length.
However I see in my database that when the data is getting put in from a text area in a web page that it is being cut off. Is the default size of a string smaller than the max size?
Ie, how do I set the string length in the ejb to be the max allowed.
Thanks so much!
Brian
It is cut off by the database, not JBossCMP. You should increase the size for the column.
Brian McSweeney wrote:
Hi all,
My ejbs are cmp ones and the string parameters I use are as follows
/**
* @ejb.persistence
* column-name="stringDescription"
* @ejb.interface-method
*/
I don�t specify the string length.
However I see in my database that when the data is getting put in from a text area in a web page that it is being cut off. Is the default size of a string smaller than the max size?
Ie, how do I set the string length in the ejb to be the max allowed.
Thanks so much!
Brian
MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*. ------------------------------------------------------- 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
