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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
>https://lists.sourceforge.net/lists/listinfo/jboss-user
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
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
