Quantcast

String of longer length than 255 chars...

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

String of longer length than 255 chars...

webmediauk
This post was updated on .
Hey Guys,
I've got a "notes" field in my app which is basically a long string.
I'm using Grails 1.3.7.
I've tried these variations in my model and none seem to work?

String notes

static constraints = {
        notes(maxSize:65535)
    }


I've also tried:

String notes

static mapping = {
   notes type: 'text'
}


I just keep getting a string is too long error from Postgres.

org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)

Any ideas guys?
Thanks
Baz
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: String of longer length than 256 chars...

Jordon Saardchit
If you allowed GORM to create the schema for you originally, and are now changing the maxSize constraint, it will not change the datatype of of the actual postgres column the property is bound to.  You have to do that by hand (or look at migrations plugin).

Jordon

On Jul 9, 2012, at 8:27 AM, webmediauk wrote:

> Hey Guys,
> I've got a "notes" field in my app which is basically a long string.
> I'm using Grails 1.3.7.
> I've tried these variations in my model and none seem to work?
>
> *String notes
>
> static constraints = {
>        notes(maxSize:65535)
>    }*
>
> I've also tried:
>
> *String notes
>
> static mapping = {
>   notes type: 'text'
> }*
>
> I just keep getting a string is too long error from Postgres.
>
> org.postgresql.util.PSQLException: ERROR: value too long for type character
> varying(255)
>
> Any ideas guys?
> Thanks
> Baz
>
> --
> View this message in context: http://grails.1312388.n4.nabble.com/String-of-longer-length-than-256-chars-tp4631282.html
> Sent from the Grails - user mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: String of longer length than 256 chars...

webmediauk
Thanks Jordan
Loading...