Thanks Alexey,
that worked. For anyone else out there doing the same thing, I'm using mysql and I used MEDIUMTEXT and it worked fine.
thanks again,
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:48:03 +0200
>
>It depends on the database you are using. For example, you could use
>LONGVARCHAR, or TEXT, or, finally, CLOB. Check the docs for your
>database supported types.
>
>:- ) wrote:
>
>>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
>
>
>
>
>
>-------------------------------------------------------
>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
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
