search

qbicsoftware / data-manager-app

A web-based life science omics and imaging data management solution
MIT License
8 stars 0 forks source link

Increase size of stored offers #602

Closed KochTobi closed 1 month ago

KochTobi commented 1 month ago

Blob only stores 65,535 bytes. Medium blob stores 16,777,215 bytes long blob stores 4 GB

As offers are expected to be larger than 15,9MB we need a bigger type.

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table purchase_offer modify column file_content BLOB" via JDBC [Data truncation: Data too long for column 'file_content' at row 2]
        at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:94)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:574)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:514)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.migrateTable(AbstractSchemaMigrator.java:333)
sonarcloud[bot] commented 1 month ago

Quality Gate Passed Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud