Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JBoss User »

Re: [JBoss-user] Default String Size

:- )

2003-11-17

Replies:

Thanks so much Alex,

I actually am using standardjbosscmp-jdbc.xml, got a bit confused, sorry!

Anyway, bad news is when I try to deploy using

* @ejb.persistence

* column-name="longString" 

* jdbc-type="VARCHAR"

* sql-type="VARCHAR(512) BINARY"

I get an error from Jboss saying:

org.jboss.deployment.DeploymentException: Error while creating table t_account; - nested throwable: (java.sql.SQLException: Invalid argument value,  message from server: "Too big column length for column 'longString' (max = 255). Use BLOB instead")

this seems to imply that all I can do is use a blob! Any idea?

thanks again so much,

brian

>From: Alexey Loubyansky
>Reply-To: jboss-user@lists.sourceforge.net
>To: jboss-user@lists.sourceforge.net
>Subject: Re: [JBoss-user] Default String Size
>Date: Tue, 18 Nov 2003 00:12:37 +0200
>
>:- ) wrote:
>
>>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
>JBoss-user@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/jboss-user


Help STOP spam with the new MSN 8 and 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 JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
©2008 junlu.com - Jax Systems, LLC, U.S.A.