Thanks Oscar and Dan. I'm using mysql and I want a textarea with unlimited length. What annotation can I use?
On Tue, Jan 28, 2014 at 1:40 PM, GESCONSULTOR - Óscar Bou < [email protected]> wrote: > Hi, Deepak. > > By default, DataNucleus implementation has a default length for String > fields of 255 [1], despite it can be changed by config. > > If you want longer lengths, you must explicitly add it to the @Column > annotation. > > Simply replace your code by: > > private String response; > > > @javax.jdo.annotations.Column(allowsNull = "true", jdbcType = "text", > length = 1000) > > @MemberOrder(name = "Response", sequence = "11") > @MultiLine(numberOfLines = 10) > @TypicalLength(800) > public String getResponse() { > > return response; > > } > > > Perhaps the @TypicalLength could be deduced from the @Column(length...), > but "Typical" is not the same as "Max" length (as the @Column annotation > indicates)... > > > In Estatio, Dan and Jeroen have centralized all data types lengths to an > external class, and I find it particularly useful. See [2]. > > HTH, > > Oscar > > > [1] http://www.datanucleus.org/servlet/jira/browse/NUCAPIJDO-37 > > [2] > https://github.com/estatio/estatio/blob/master/dom/src/main/java/org/estatio/dom/JdoColumnLength.java > > > > > > El 28/01/2014, a las 07:45, Dan Haywood <[email protected]> > escribió: > > > It might be the database you're using that has that limit, and/or the > @Column annotation you have. > > I'm just working on an entity right now that has a "memento" property, of > length 1024. its annotation is: > > @javax.jdo.annotations.Column(allowsNull="false", length=1024) > @MultiLine(numberOfLines=20) > @Hidden(where=Where.ALL_TABLES) > @MemberOrder(name="Target",sequence = "4") > @Disabled > public String getMemento() { ... } > > This is fine on HSQLDB. > > HTH > Dan > > > > > > On 28 January 2014 03:52, Deepak Gopalakrishnan <[email protected]> wrote: > > Hello Dev, > > I've been trying an entity which has a property as below... > > private String response; > > > @javax.jdo.annotations.Column(allowsNull = "true", jdbcType = "text") > > @MemberOrder(name = "Response", sequence = "11") > > @MultiLine(numberOfLines = 10) > > @TypicalLength(800) > > public String getResponse() { > > return response; > > } > > > My expected behaviour is a text area with any number of characters ( or a > very high upper limit). I however get an error stating that the value > character count exceeds 255 characters ( which is varchar count i believe) > > > Please tell me what I'm missing here. > > > > -- > Regards, > *Deepak Gopalakrishnan* > *Mobile*:+918891509774 > *Skype* : deepakgk87 > http://myexps.blogspot.com > > > > Óscar Bou Bou > Responsable de Producto > Auditor Jefe de Certificación ISO 27001 en BSI > CISA, CRISC, APMG ISO 20000, ITIL-F > > 902 900 231 / 620 267 520 > http://www.twitter.com/oscarbou > > http://es.linkedin.com/in/oscarbou > > http://www.GesConsultor.com <http://www.gesconsultor.com/> > > > > Este mensaje y los ficheros anexos son confidenciales. Los mismos > contienen información reservada que no puede ser difundida. Si usted ha > recibido este correo por error, tenga la amabilidad de eliminarlo de su > sistema y avisar al remitente mediante reenvío a su dirección electrónica; > no deberá copiar el mensaje ni divulgar su contenido a ninguna persona. > Su dirección de correo electrónico junto a sus datos personales constan en > un fichero titularidad de Gesdatos Software, S.L. cuya finalidad es la de > mantener el contacto con Ud. Si quiere saber de qué información disponemos > de Ud., modificarla, y en su caso, cancelarla, puede hacerlo enviando un > escrito al efecto, acompañado de una fotocopia de su D.N.I. a la siguiente > dirección: Gesdatos Software, S.L. , Paseo de la Castellana, 153 bajo - > 28046 (Madrid), y Avda. Cortes Valencianas num. 50, 1ºC - 46015 (Valencia). > Asimismo, es su responsabilidad comprobar que este mensaje o sus archivos > adjuntos no contengan virus informáticos, y en caso que los tuvieran > eliminarlos. > > > > > > -- Regards, *Deepak Gopalakrishnan* *Mobile*:+918891509774 *Skype* : deepakgk87 http://myexps.blogspot.com
