Ошибка значение не умещается в тип character varying 255

When I execute my project, I get this error:
enter image description here

The goal is to save json text into a database using hibernate.

Users.java & UsersBooks.java is likewise,

enter image description here

Books.java:

@Entity
@Table(name="tblbooks")
public class Books {


@Id
@Column(name = "bookshareId")
private int bookshareId;

@Column(name="author")
private String author;

@Column(name = "availableToDownload")
private int availableToDownload;

@Column(name = "briefSynopsis")
private String briefSynopsis;

@Column(name="category")
private String category;

@Column(name = "completeSynopsis")
private String completeSynopsis;

@Column(name = "contentId")
private int contentId;

@Column(name = "copyright")
private Date copyright;

@Column(name="downloadFormat")
private String downloadFormat;

@Column(name="dtbookSize")
private int dtbookSize;

@Column(name = "freelyAvailable")
private int freelyAvailable;

@Column(name = "brf")
private int brf;

@Column(name = "daisy")
private int daisy;

@Column(name = "images")
private int images;

@Column(name = "isbn13")
private String isbn13;

@Column(name="language")
private String language;

@Column(name = "publishDate")
private Date publishDate;

@Column(name = "publisher")
private String publisher;

@Column(name = "quality")
private String quality;

@Column(name = "title")
private String title;

@OneToMany(mappedBy="book")
private List<UsersBooks> usersBooks;



//Getters & Setters

veben's user avatar

veben

18.9k14 gold badges60 silver badges80 bronze badges

asked Apr 6, 2016 at 8:58

Albin Gjoka's user avatar

2

You try to save a string value more than 255 chars length. Just increase a column length

@Column(name = "xxx", length = 1024)

you need to alter a column length in the database too.

When you use

@Column(name = "xxx")

Hibernate uses a default column length.

You can use @Lob for a really large text data.

Please, use xxx_users in place of tblusers.

Use User in place of Users.

Use CascadeType.ALL on the @OneToMany part of the association.

Use a lazy loading on the @ManyToOne part of the association.

@ManyToOne(fetch = FetchType.Lazy)
pravate User user;

answered Apr 6, 2016 at 9:01

v.ladynev's user avatar

v.ladynevv.ladynev

19.1k8 gold badges45 silver badges66 bronze badges

For String with more than 255 chars length you can increase column length : 

@Column(length = 2048)
private String column;

For large size : 

@Lob
private String column;

For unlimited size :

@Column(columnDefinition="text")
private String column;

answered Oct 18, 2017 at 15:17

veben's user avatar

vebenveben

18.9k14 gold badges60 silver badges80 bronze badges

The error message tells that you are trying to store a String which is too large for its destination column (255).

You can either :

  • Increase the column size or
  • Change the column type to TEXT instead of VARCHAR(255).

answered Apr 6, 2016 at 9:03

Arnaud Denoyelle's user avatar

Arnaud DenoyelleArnaud Denoyelle

29.7k15 gold badges90 silver badges146 bronze badges

Источник

My string field:

description: {
   type: DataTypes.STRING, 
   validate: { 
      len: { 
          args: [10, 1000], 
          msg:"10-1000!"
      } 
   }
}

Which should allow a string to only have 10-1000 characters. However, when I try to save the following garbage text:

**a jskdlfa** sdklfaj fklsafj sadklfja sdofjs adiofasj flisaj foaisdfj sadklf jasklfj saklfj asoifj asofj asfj asoifj asdklf jakslf aslp jl;k jkl; jkl; jkl; jkl; ajsdklfa; sjfsklf ;sjfkl jfklasjfasklfjasdklfasfjaslfjsklf; jaskfl ajdf kl;fjsdklf;j daklf jsf as;lfj askldf jsdklf;a fjsdaklf; asjdkfla; fjkaslf; jaskdlf; asjdfka t;sfjaskf lasjdfkasdlf; ajdkfls;a fjaksl;

Hey *this is a test*:
![Minion](https://octodex.github.com/images/minion.png)

This returns an error:

{ name: 'SequelizeDatabaseError',
  message: 'value too long for type character varying(255)',
  parent: 
   { [error: value too long for type character varying(255)]
     name: 'error',
     length: 92,
     severity: 'ERROR',
     code: '22001',
     detail: undefined,
     hint: undefined,
     position: undefined,
     internalPosition: undefined,
     internalQuery: undefined,
     where: undefined,
     schema: undefined,
     table: undefined,
     column: undefined,
     dataType: undefined,
     constraint: undefined,
     ...
Источник

Hi,

I been trying to install Ambari and ran into the following issue and so far have not been able to get passed it.
When I try to register the host nodes in my cluster they fail.

I have tried Ambari versions 1.7.0 to 2.4.1 with same results.
Google searches and searching this forum did not return results that helped me.

/var/log/ambari-server/ambari-server.log contains:

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services — 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Error Code: 0
Call: INSERT INTO hosts (host_id, cpu_count, cpu_info, discovery_status, host_attributes, host_name, ipv4, ipv6, last_registration_time, os_arch, os_info, os_type, ph_cpu_count, public_host_name, rack_info, total_mem) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [16 parameters bound]
Query: InsertObjectQuery(org.apache.ambari.server.orm.entities.HostStateEntity@8fdfba02)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:149)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.appendCall(ParameterizedSQLBatchWritingMechanism.java:82)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:605)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489)

Here is some information about my setup:
3 node cluster running on Openstack VMs:

cat /etc/redhat-release
CentOS release 6.8 (Final)

VCPUs: 4

free -m

total used free shared buffers cached

Mem: 7872 3290 4581 5 41 2435
-/+ buffers/cache: 812 7059
Swap: 0 0 0

Root passwordless ssh across all 3 nodes.

/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.147.110.58 hbase17700.localhost.com hbase17700 hbase1
10.147.110.56 hbase27700.localhost.com hbase27700 hbase2
10.147.110.57 hbase37700.localhost.com hbase37700 hbase3

java -version
java version «1.8.0_77″Java(TM) SE Runtime Environment (build 1.8.0_77-b03)
Java HotSpot(TM) 64-Bit Server VM (build 25.77-b03, mixed mode)

python.x86_64 2.6.6-64.el6

ambari-agent.x86_64 2.4.1.0-22
ambari-server.x86_64 2.4.1.0-22

Источник

Коллеги, приветствую!
Заношу файлы изображений в базу по ссылке.
Получил очень странную ошибку: django.db.utils.DataError: ОШИБКА: значение не умещается в тип character varying(50). 

img_name1 = urlparse(image).path.split('/')[-1]
response = requests.get(image)
if response.status_code == 200:
        product.image.save(img_name1, ContentFile(response.content), save=True)

Ругается на строчку 

product.image.save(img_name1, ContentFile(response.content), save=True)

делал принт img_name1, там не больше 6 символов, остается только ContentFile(response.content)
Тогда вопрос, как увеличить лимит? Нагуглить ничего не удалось, увы

Источник

Symptoms

This issue affects multiple databases with different error strings. These are the current known errors resulting from this issue:

MySQL
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#4784133]; SQL []; Data truncation: Data too long for column 'DESTSPACEKEY' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'DESTSPACEKEY' at row 1
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)

caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'DESTSPACEKEY' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3561)
PostgreSQL
2010-09-17 14:05:38,098 ERROR [http-8080-5] [confluence.pages.actions.AbstractEditPageAction] doSaveEditPageBean An error occured while storing the requested page!
 -- referer: http://localhost:8080/pages/editpage.action?pageId=720902 | url: /pages/doeditpage.action | userName: admin | action: doeditpage | page: 720902
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#852117]; SQL []; ERROR: value too long for type character varying(255); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)

Cause

There is a colon contained within square brackets [] after 255 characters, which causes the database to choke. This issue is being tracked by CONF-20558.

Resolution

  1. Add a space after the opening square bracket ‘[‘ or before the closing square bracket ‘[‘

  2. Replace the colon ‘:’ with:

  3. Insert the text inside Noformat Macro or Code Block Macro.

Last modified on Mar 30, 2016

Related content

  • No related content found
Источник

Понравилась статья? Поделить с друзьями:
  • Ошибка и заблуждение это синонимы
  • Ошибка значение не умещается в тип character varying 100
  • Ошибка и ее уголовно правовое значение это
  • Ошибка значение не соответствует шаблону основной документ серия
  • Ошибка и ее уголовно правовое значение реферат